SQL SERVER – DPM Backup Failure – E_COORD_LOG_CHAIN_BROKEN – The Backup Failed Because of a Gap in The LSN the Log Files
SQL SERVER – Error: Could not Load File or Assembly Microsoft. SqlServer. management. sdk. sfc Version 12.0.0.0
Could not load file or assembly errors come in many flavors. Here is how to read the assembly name and version in the message and fix the missing file.
DBCC CHECKDB Running Slow? Check the MAXDOP Option
DBCC CHECKDB running slow can trace back to the MAXDOP option. A CHECKDB with no MAXDOP option uses the server’s max degree of parallelism, and one with its own option overrides it. This post times CHECKDB on a 2 GB database with four settings, adds PHYSICAL_ONLY, and lists the other causes to rule out.
Azure – Which One to Get – Standard Disks or Premium Disks
Many customers get a slower SQL Server after moving to Azure. Should you pick Standard or Premium Disks? My short answer is Premium, and here is why.
SQL SERVER – How to Find Free Log Space in SQL Server?
Free Log Space is reusable capacity inside an allocated transaction log. I measure disk space and file size separately.
How to Search Special Characters in Table Column? – Interview Question of the Week #172
Can you find [blog.] in a column with LIKE? Most people I interview cannot. Here is how to search Special Characters in a table column the right way.
SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)
A workshop question: what is the performance comparison of function TRIM and LTRIM(RTRIM) in SQL Server? Here are the test results.