|
|
|
|
|
|
|
| Getting Output To a File without Column Headings - Saturday, November 22, 2008This examples shows you how you how to get output from a T-SQL statement into a file without it having column headings. read more ...
|
|
| Obtaining SQL Server Setup Information - Thursday, July 17, 2008This example obtains different SQL Server instance setup information by running a number of select statements. read more ...
|
|
| Displaying SQL Server Agent Job Statistics - Thursday, June 19, 2008This example displays SQL Server Agent Job statistics like, maximum duration, average duration and number of executions. read more ...
|
|
| Finding Status of SQL Server Agent Using T-SQL - Sunday, June 15, 2008This example allows you to determine the status of SQL Server Agent using T-SQL. read more ...
|
|
| How to Delete a File with T-SQL - Friday, May 23, 2008This short example shows you how you delete an operating system file with T-SQL. read more ...
|
|
| Output Record Set to File Using T-SQL - Thursday, May 15, 2008This example shows how to T-SQL to ouput the results of a SELECT statement to a file. read more ...
|
|
| List Transaction Log Backups Taken in the Last 24 hours - Sunday, May 04, 2008This short example shows how to find all the transaction log backups for database "SSD" for that where taken in the last 24 hours. read more ...
|
|
| Executing T-SQL Script File Using T-SQL - Wednesday, April 30, 2008This short example shows how to execute a T-SQL script file using T-SQL. This example uses the xp_cmdshell extended stored procedure and the OSQL utility to accomplish submitting a script file using T-SQL. read more ...
|
|
| Finding Missing Indexes - Thursday, April 24, 2008This script uses DMV information to identify missing indexes. SQL Server identifies missing indexes based on commands that have been run since instance last started. The output of this script identifies the value of implement a new index and display a CREATE INDEX statement for the missing index. read more ...
|
|
| Set all databases to DBO ONLY - Sunday, December 02, 2007This script will set all databases to DBO ONLY mode. read more ...
|
|
| Get Record Counts for All Tables in Every Database - Sunday, December 02, 2007This stored procedure produces a report of record counts for every table on your server. read more ...
|
|
|
|
 |
|
|
|
|
|
|
|
|