2013-09-17 (first published: 2013-09-06)
1,480 reads
Scripts
2013-09-12 (first published: 2013-02-08)
1,918 reads
2013-09-12 (first published: 2013-02-08)
693 reads
Find Foriegn Keys and their details in a database
Use this script to find all the Foriegn Keys and their details in a database
2013-09-11 (first published: 2013-09-02)
1,434 reads
Restore multiple db's to new server with new file locations
Script queries backupset & backupmediafamily tables to get latest backup file, then generates script to restore db using backup file and moves files to new locations.
2013-09-10 (first published: 2013-08-28)
1,386 reads
Kill User Processes Per Database or Server Wide
Kill any user processes per database or for the entire server instance.
2013-09-05 (first published: 2013-08-21)
1,533 reads
Display the SELECT statement for any table
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,248 reads
Show database size info across an instance
This script shows size information of every database on the instance.
2013-08-21 (first published: 2010-07-26)
5,964 reads
Generate Create View statements for database tables.
Create views based on table definitions for backwards compatibility when relocating tables to a new database.
2013-08-16 (first published: 2013-07-30)
1,134 reads
Execute T-SQL Scripts in Parallel
Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.
2013-08-13 (first published: 2009-08-28)
17,550 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers