Deleting old files (with/without archive bit)
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-01 (first published: 2008-12-09)
2,504 reads
Scripts
Automatically Restore Backup Files for SQL 2005
This script helps with restoring backup files SQL Server 2005
2008-12-31 (first published: 2008-12-11)
1,608 reads
Insert Multiple Records using a Single insert statement
This is used to insert the multiple values using a single insert statment.
2008-12-31
524 reads
Tables referenced by a stored proc (2000)
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
2008-12-30 (first published: 2008-12-05)
1,041 reads
How to Change all Table owner one in to another in sql server 2000?
we need change all user table db owners For selected database using T SQL we can easily use this method.
2008-12-29 (first published: 2008-11-30)
1,234 reads
Finding Execution Time of a SQL Statement
Capturing the execution time for rebuilding an index for set of tables.
2008-12-26 (first published: 2008-11-27)
1,713 reads
Deleting Duplicate Records
This article explains a simple solution for the common problem in MSSQL 7.0/2000, finding & deleting duplicate records from a table.
2008-12-24 (first published: 2008-11-26)
2,820 reads
2008-12-23 (first published: 2008-11-10)
2,950 reads
search every database on server from a single sp
i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works
2008-12-19 (first published: 2008-11-11)
1,002 reads
Generate CREATE DATABASE FOR ATTACH for all databases on server
I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.
2008-12-18 (first published: 2008-11-14)
1,276 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers