A Brute Force Way to Compress a Database
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-09
3,352 reads
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-09
3,352 reads
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
2010-11-05
2,013 reads
I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...
2010-10-27
843 reads
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
955 reads
Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...
2010-10-05
985 reads
Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.
First, let me...
2010-09-27
1,200 reads
Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say...
2010-09-23
322 reads
Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is...
2010-09-21
321 reads
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
2 reads
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
1 reads
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
In this post, I will guide you on how to deploy a dockerized simple...
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
hi, i changed my mysql based linked server's timeout to N'600' instead of N'0'...
Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...
hi a few days ago i narrowed down the cause of a new problem...
At what levels can we set the collation in SQL Server 2022?
See possible answers