These queries are used to compare the data in two tables. In these examples all the rows in each table is retrieved and compared using the UNION ALL command. I would recommend adding additional WHERE criteria for very large tables to reduce the number of rows that will be compared.These SQL statements are based on […]
2007-08-09 (first published: 2006-11-29)
2,791 reads
Choosing a backup solution can be a trying exercise with all the various add on products these days. New author David Bird gives us some insight into his testing and decisions with a look at Litespeed and Tivoli's Storage Manager.
2006-03-28
8,055 reads
I use this script to shrink the log files for development databases. The intention is keep the log files as small as possible when the database is not in use. By scheduling this script I can control when it happens as oppose to using auto shrink.
2005-07-08 (first published: 2005-06-29)
2,526 reads
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Comments posted to this topic are about the item AlwaysON health check alerts
Comments posted to this topic are about the item Bat and SQL script to...