When faced with a SQL Server that is performing poorly, a great starting place for troubleshooting is looking at wait stats. Once you’re gathering wait stats, if you see lots of IO-related waits, you may…
SQL Server includes a little-known, but handy, function that can show you common data-type conversions for a target system; useful for ETL between disparate systems. Run this code:
DECLARE @source_dbms sysname = N'%'
, @source_version sysname = N'%'
, @source_type sysname = N'%'
, @destination_dbms sysname = N'%'
, @destination_version sysname = N'%'
, @destination_type sysname = N'%'
, @defaults_only bit = 0;
FROM sys.fn_helpdatatypemap (
The above code returns a result-set…
I use the following code to determine which specific version of the Microsoft .Net Framework 4.0 is installed on my SQL Server. It detects versions from 4.5 to 4.7, and can be easily extended as…
Performance troubleshooting should begin with capturing wait stats so we can understand where SQL Server is busy. The script below captures wait stats into a table in tempdb; the script should be ran via a…
Attempting to debug production performance problems in your development environment can be problematic in many ways, leading to a frustrating troubleshooting experience. One very common situation is the resources on the development environment are substantially…