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,010 reads
I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...
2010-10-27
841 reads
From time to time I hear of DBAs that had to restart the SQL Server service on a 2005 or...
2010-10-06
949 reads
Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...
2010-10-05
752 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
949 reads
Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say...
2010-09-23
320 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
320 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
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
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers