And you know that’s a bad thing™. At least, most of the time. Some people swear by ’em, and for certain requirements a heap is the best thing since sliced bread. For most scenarios you…
SQL Server Agent has many operational properties that can be critical for troubleshooting various issues. Many of these properties are surfaced via GUI properties pages, and as such can be hard to compare across many…
Managing a large number of SQL Server instances, with many SQL Server Agent jobs on each instance, can provide a large amount of tedious work when many jobs fail simultaneously. For instance, if you run…
SQL Server Agent provides an easy-to-configure framework for notifying DBAs when jobs fail to run for any reason. Unfortunately, there are circumstances where job failures may not result in SQL Server sending a notification. For…
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…