| Database Snapshot SP - This stored procedure makes creating a snapshot easier by reading the master database for the filenames of the source database then generating the snapshot creation script |
| Generate a column of numbers. - Technique for generating a column of numbers, in sequence. Can it be used to reorder PKeys without using cursors? (Yes, if certain conditions are met.) |
| dba3_Alter_ColumnInTable_Demo - Demo: Alter a Column in an existing table using the Alter Table Statement |
| dba3_0030_hr_Set_SuperSets_WithOrder_Article - Creates stored procedure hr_Set_SuperSets Used in demonstrating a Maps and Sets logical design of a hierarchical system.
|
| Generate Autofixlogins - Generate logins after restoring a database from a different server. Works for SQL 7.0 and SQL 2K |
| Create_Update_Proc - This procedure will look to the system tables and create a default Update proc. |
| List of all open connections on SQL 2005 SERVER - List of all open connections on SQL 2005 SERVER |
| dba3_prc_MonthBeginAndEndDateTime_Article - -- Procedure to find and return the first day of the month and the last day of the month
-- for a given datetime parameter
-- Modeling Date Logic II: Queries, Functions, Procedures for Business Date & Time Calculations
-- http://www.sswug.org/se |
| GetSpTrigValues - Get trigger values for the specified database |
| sp__loaddata.sql - Automates the loading of data from one server to another (uses BCP) |
| Create a DB Size Trending report - This proc will take the data from TblSizes and create a new table with database sizes and date |
| dba3_SelectAssimilatingDataForEachDayInDateSpan_Demo - Re: Select Query assimilating data for each day in a date span
- (minor modifications required for earlier Sql Server versions)
See: http://www.sswug.org/forum/ShowPost.aspx?PostID=830 |
| sp_ShowInformation - Shows information on all database files, locations and sizes. |
| stringparsing methods and variants - Different approaches to do stringparsing/filtering, by numberstable or by while loop |
| dba3_Create_Maps_Sets_Article - Creates and populates Maps and Sets tables. Used in demonstrating a Maps and Sets logical design of a hierarchical system. Use with: Modeling Hierarchical Relationships Article
(requires slight modifications for <= 6.0) |
| Force Shrink of Database Log File - Shrinks a database log file when other means fail |
| List all Active Sessions on a SQL Server 2005 BOX - List all Active Sessions on a SQL Server 2005 BOX. |
| fn_listfind() - find ordinal position of text in a delimited list - This function is similar to ColdFusion's ListFind() function; it takes a comma-delimited list and the text to find in the list as args and returns the ordinal position of the text. |
| dba3_RC4_EncryptionDecryptionScript - fn_string_helper code - by Mike Arney |
| Find out space used in all db's (oneliner) - Albeit this method is unsupported (sp_MSforeachdb) - it's a quick way to produce size output for all db's on a server with just a single line of T-SQL |
| Estimate Disk Space - Calculates disk space requirements of a table |
| Process To Log SP usage and Times - Process that will all you to see when a sp is called and how long it takes to run, including any parameters and errors. |
| xp_getfiledetails attribute values - Notes on the attribute bitmap returned by xp_getfiledetails |
| Create Database for point-in-time recovery (SS7.0 only) - Demo script how to create a db with primary and user defined filegroup and changing the default filegroup in order to support point-in-time recovery |
| index-property - Get indexes for all tables |
| Calculate total rows and disk space - Calculates the total rows and disk space used for each table, then provides a summary of the totals. |
| dba3_read_DirectoryFileNames_demo - How to use xp_CmdShell to read a given UNCs directory contents into a temp table |
| dba3_BeforeAndAfterRecordCounts_Demo - a very simple demo of before and after record counts |
| dba3_Implementing_and_maintaining_the_Calendar_design_Article - Modeling Date Logic III: Implementing Business Calendars (by example in MS Sql Server 2000)http://www.sswug.org/see/17379 A demonstration of implementation and typical end user tasks.
|
| dba3_sp_HelpReNameIndicies - Bonus Proc dbo.sp_HelpReNameIndiciesForEachTable
Bonus Script - applies to all DBs on DBMS |
