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,991 reads
Rahul Sharma
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
5,005 reads
Blogs
Daily Coping 27 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Seeding an Availability Group Replica from Snapshot
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
Forums
Need to provide access to database without giving access to production
Hoping I could find some best practice answers here: We have analysts who need...
Fill missing rows in dataset
I have data in table like this. I want to fill/insert the rows with...
Sign all stored procedures with a Certificate.
Hello, My company is going about ever increasing our security on all our Servers/databases....
Ask SSC