SQL Server Page File location – where to put it?
Tobias asks if it matters where Windows places its page file on a SQL Server server.
Month: October 2019
Why can’t I restore encrypted backup through front end?
UserSteve is having trouble restoring an encrypted database backup to a new server. I try to walk him though the steps of getting the necessary encryption keys on the destination server.
How to create date buckets in T-SQL
I was fiddling around with some data, looking at making a quick aging report. I probably should have reached for Power BI Desktop, but sometimes I can be stubborn, and I wanted to get my T-SQL to work–if nothing else to figure out how to … [Read More]
Does a Window 10 license allow using it as a Web server?
Hussain Akbar is creating a custom app, and is wondering if he can run both his production Web & SQL Server instances on the same Windows 10 machine to save on licensing. I don’t like the sound of running the database on a web server.
How to implement a unique key for a long VARCHAR column in MySQL
Question I need to let MySQL to check the uniqueness of a VARCHAR column which is 5000 max length and is not the primary key. I can use an index of length 500 on the column to speed up query, but how to create an … [Read More]
convert sql-excel date to recognizable format
nilsinelabore is struggling with Excel date/time formats after converting a CSV to Excel.
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 recompilation … [Read More]
What the heck is Accelerated Database Recovery?
Last week, I wrote about the SQL Server Version Store. The week before, I looked at crash recovery. Let’s look next at a new feature in SQL Server 2019, where these two features intersect: Accelerated Database Recovery. What is it? Accelerated Database Recovery(ADR) is a … [Read More]
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 … [Read More]
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.