Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, Miscellaneous, SQL Server 2005 Rss

   Items 1 to 6 of 6   
 

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...
By Simon Facer 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,771 reads

Row count and space used for all tables in database (update)

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...
By Rafal Skotak 2011/05/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,814 reads

Yet Another Deleting Duplicate Records (in-place)

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.  Read more...
By Peter Petrov 2009/01/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,849 reads

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...
By Simon Facer 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,771 reads

Row count and space used for all tables in database (update)

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...
By Rafal Skotak 2011/05/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,814 reads

Analyzing Disk Capacity for SQL Server

Ensuring that your disk subsystem performs well and does not run out of space is a balancing act that many DBAs learn over time through trial and "out of space" errors. New author Arindam Banerjee takes a look at some of the things to consider when capacity planning.   Read more...
By Arindam Banerjee 2006/07/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,390 reads
   Items 1 to 6 of 6   
 
Tags
t-sql (2)    
administration (1)    
strategies (1)