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,824 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,823 reads
Blogs
Interview with Greg Low
By damianwidera
This is the sixth interview we have done. This time our guest is Greg...
Azure SQL Database Types
By Arun Sirpal
I want to do a quick summary post of the many different types of...
Azure SQL Database – Azure Portal Updates
By Arun Sirpal
A small but useful change has been made to the Azure Portal for Data...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Which items can be built (do we have enough product for)?
I have a stupid question. I'm dealing with a Bill Of Materials problem... I...
Modifying the Dataframe in R
Comments posted to this topic are about the item Modifying the Dataframe in R
Ask SSC