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,858 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
3,919 reads
Blogs
On Dynamic Ports, Named Instances, and Firewalls
By Will Assaf
Recently I had a client and their vendor trying to configure a firewall for...
Daily Coping 13 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Last Week Reading (2020-07-12)
By Kamil
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....
Forums
The C in ACID
Comments posted to this topic are about the item The C in ACID
Renting Features
Comments posted to this topic are about the item Renting Features
Basic Git for DBAs: Making Changes in GitHub
Comments posted to this topic are about the item Basic Git for DBAs: Making...
Ask SSC