This procedure will display the rows, reserved, data, index and unused space used in KB for all user tables in the database. The idea is to call sp_spaceused repeatedly. Limitation: certain versions of sp_spaceused will truncate the table name to 20 characters.Speed will depend on current activity level and locking in the database. It will […]
2002-03-14
399 reads
Drop all indexes, constraints and statistics for given table.
2002-03-14
1,195 reads
Generates a XML document containing metadata on a specified table. Table name is provided to the procedure.
2002-03-13
585 reads
This procedure when executed with the correct parameters, backs up a database in the specified directory pathUsage :exec USP_BACKUPDATABASE databasename, directory_path
2002-03-12
586 reads
This short and simple script is a very fast way to count the rows in all your indexed tables. I ran it against a 2-gigabyte database containing large tables (some with over a million rows!), and it returned results in under a second.
2002-03-12
2,872 reads
Given a table name as the parameter, all the indexes on the table can be dropped. This script can be useful if you want to drop indexes on a table inside another procedure
2002-03-12
13,769 reads
This procedure when executed with the correct parameters, exports all stored procedures from a database into different .SQL files in the path specified.Usage :exec USP_PRINT_PROCS username, password, servername, databasename, directory path
2002-03-12
555 reads
Returns the Owner, Table Name, Row count for all user tables in the current database.
2002-03-11
605 reads
When rebuilding a server or setting up a backup or DR server the logins need to be added into master and synchronised with the user databases.Inevitably there are orphaned users is sysusers or the sid's do not match with syslogins.I use this stored procedure to check for a particular user when the user experiences a […]
2002-03-07
819 reads
--Delete all restrictions from those tables included in the input parameters Procedure HP_BORRA_CONSTRAINTS -- Include CHECK, FOREIGN KEY, PRIMARY KEY, UNIQUE, and DEFAULT constraints.
2002-03-07
459 reads
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Comments posted to this topic are about the item The Improvement Limit
Comments posted to this topic are about the item Migrate SSRS Reports to a...