Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Joshua A. Walker

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

Capture and Alert for Blocked SPIDS with SP_WHO2

This will capture locked/blocked spids and alert with the inputbuffer info as well as the login info. Then email it and record the history of the blocks.  Read more...
By Joshua A. Walker 2013/12/04 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 3,320 reads

Functions for using the keys from the Date and Time Dimensions

Three functions for obtaining the date and time dimension keys with a date or the date from the keys  Read more...
By Joshua A. Walker 2011/05/03 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,254 reads

Function to Add Leading 0's (Zeros) to an INT

Very simple function code to add leading zeros to a passed in int for a length also passed.  Read more...
By Joshua A. Walker 2009/03/05 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,572 reads

Function to Return Date and Time String for File Archiving

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.  Read more...
By Joshua A. Walker 2009/02/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,396 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,424 reads

Search All SQL Script Objects in All Databases for Text

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.  Read more...
By Joshua A. Walker 2013/05/21 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,652 reads

Date and Time dimension creation and population T-SQL

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.  Read more...
By Joshua A. Walker 2013/10/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 23,020 reads
   Items 1 to 7 of 7