convert sql-excel date to recognizable format
nilsinelabore is struggling with Excel date/time formats after converting a CSV to Excel.
Continue readingBrowse the archive
Databases
How does a database RESTORE affect plan cache?
If you restore a database, what does that do to the plan cache? Well, let’s start by looking at the documentation for RESTORE. (Emphasis mine) Restoring a database clears the plan cache for the instance of SQL Server. Clearing the plan cache causes a …
Continue reading
What the heck is Accelerated Database Recovery?
An overview of Accelerated Database Recovery and how it changes SQL Server crash recovery.
Continue reading
SQL log file 2TB is not enough, now what?
Question This is a hypothetical question, that flows from the answer by sepupic where they explain that 2TB is the physical limit for SQL log file. if you need it more than 2Tb you add the second log file. I have long held the belief that multiple log files …
Continue reading
Copying SQL Server settings to new server
UserSteve is upgrading to a new server and needs to move all his server settings to the new instance. I introduce him to DBA Tools as a quick way to copy configurations and other stuff to the new instance.
Continue reading
What the heck is the SQL Server Version Store?
Explore how SQL Server’s version store supports row versioning and how to monitor its impact.
Continue reading
Recovery of database is 0% complete (approximately 1000000 seconds remain)
recovering from this crash is going to be pretty difficult If you've ever had a server reboot unexpectedly, you've probably seen SQL Server start up, with some databases "stuck" in recovery status, then eventually they come online. Or maybe you thought "this …
Continue readingSQL database stuck in recovery
Question I have SQL server 2017. I have one 3 TB size database there. Somehow due to long running transaction the database got stuck 'IN Recovery' mode after SQL server Restarted. When I checked the sql error logs it says 2 189 255 seconds remaining (Phase 2 …
Continue readingHow To Fix High DTU Usage on Specific Query
Question I have a query that runs every few seconds on a Microsoft SQL Azure Database. It is from a web job that checks if there are actions that need to be done based on rows in a specific table (its a queueing table). Based on the image attached, does …
Continue readingLinked server from SQL server on AWS RDS to On premises MS SQL server database
Question We are planing to migrate an on-premises SQL Server db to AWS RDS SQL Server. My only concern is how can I create a linked server from AWS RDS SQL Server to on-premises SQL Server db? Is it possible? I am checking it because there are many views …
Continue reading