Setup error 25641 stopped a SQL Server 2012 installation in a client environment. The ERRORLOG said the filename parameter for the event_file target was invalid. Process Monitor showed Access Denied for the service account on the drive that holds the LOG folder.
go-sqlcmd: The New Command Line Tool for SQL Server
Set up go-sqlcmd on Windows, verify the executable, run scripts and variables, control output, and review optional container commands.
What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245
SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.
RSFXDEVICEOPS Wait: Unneeded WAITFOR DELAY Slowing Queries
The RSFXDEVICEOPS wait, listed as PREEMPTIVE_OS_RSFXDEVICEOPS, was high at a client that did not use FileStream. Their queries carried a WAITFOR DELAY nobody remembered adding. When the clause came out, the wait dropped and the queries got fast again.
AVG of an Integer Column Returns an Integer: Getting Decimals Back
The dashboard says the average is 1 when everyone can see it is 1.5. Here is why AVG does that and the one-line fix.
How to Download the Latest SQL Server Docker Image? – Interview Question of the Week #244
Question: How to Download the Latest SQL Server Docker Image? Answer: The command to download the latest SQL Server Docker Image is here:
SQL SERVER – Strange Error Related to Alias
They immediately paid for Comprehensive Database Performance Health Check and we got online to look at their strange error related to alias.