Defrag Tables
Over a period of time, because of the inserts, updates and deletes, the data and the index pages can get fragmented. Here's a script that can help to defrag the database:
2001-08-08
5,859 reads
Scripts
Drop all Connections from a Database
On development servers, at times there is a need for dropping and renaming database(s). These scripts can be used for achieving these tasks. The usp_DropDB script will kill the connections to the database and then drop the database. It takes care of the space in the database name, if any and also makes sure that […]
2001-08-08
3,921 reads
Forcibly Shrink the Transaction Log
I got this script from SQL Server Professional Magazine in an article by Andrew Zanevsky. It performs transactions to fill up virtual log files and continually shrinks the log until the desired level of shrinkage is achieved.
2001-08-08
9,805 reads
Kill All Users in A Given Database
This script will kill all users in a given database. Before disconnecting, it can optionally send the user a NET SEND Message giving them a warning to disconnect. To run, simply call it like usp_killusers 'dbname'. Make sure the @dbname parameter is not the master database.
2001-08-08
4,312 reads
Quickly Enable/Disable Triggers and Constraints
When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]
2001-08-08
2,950 reads
Blogs
Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)
By KendraLittle
I'm not an expert on collation in SQL Server, but there are a few...
Do More, With Less
Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is...
Daily Coping 16 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Backup server
We will have backup server maintenance with the outage between 15mins to 1 hr....
Is SQL developer edition exactly the same as enterprise edition?
Hey all, Regarding licensing of SQL server, we are considering the possibility of running...
Logging (auditing) in the table vs. having a logging (auditing) table
I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I've...
Ask SSC