Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.
2009-09-30 (first published: 2009-09-16)
2,067 reads
2009-09-29 (first published: 2009-09-17)
918 reads
Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.
2009-09-25 (first published: 2009-09-15)
902 reads
2009-09-24 (first published: 2009-09-15)
698 reads
Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.
2009-09-23 (first published: 2009-08-27)
2,530 reads
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,254 reads
The script will produce a Drop/Create script for all the jobs existing on the server. Instead of scripting them individually.
The output script will also have schedules scripted out
2009-09-18 (first published: 2009-09-08)
7,232 reads
This script will list columns data type and size for every table in a database.
2009-09-15 (first published: 2009-09-02)
2,001 reads
Query to generate a dynamic Select statement from any table for moving data between servers.
2009-09-11 (first published: 2009-09-01)
1,615 reads
this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.
2009-09-10 (first published: 2008-11-21)
3,322 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Finding Motivation
Comments posted to this topic are about the item The Last Binary Value of...
Comments posted to this topic are about the item SQL Art, Part 2: New...
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers