2009-10-05 (first published: 2009-09-21)
2,272 reads
Scripts
The Ultimate PK-Less / CLIDX-Less Table Finder
Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.
2009-10-02 (first published: 2008-11-05)
1,167 reads
BCP command to export data to excel with column headers
This script export data into excel/CSV file using BCP comnand with column headers
2009-10-01 (first published: 2009-09-22)
3,589 reads
Execute SQL Scripts in paralel for real performance tests
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,087 reads
2009-09-29 (first published: 2009-09-17)
936 reads
Runaway Job Management
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)
919 reads
2009-09-24 (first published: 2009-09-15)
710 reads
Shrink Log File to Target Percentage
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,559 reads
Generate Data Script for a Table
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,280 reads
Script all the jobs on a SQL server 2005 and apply them in SQL 2008
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,317 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
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...
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