SQLServerCentral - Scripts by Joshua A. Walker

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 2011/04/06 | Source: SQLServerCentral.com | Category: sp_who2

Rating:

|

Discuss |

Briefcase | 2,273 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 | 3,798 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,540 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,353 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 2011/03/31 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 7,078 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,475 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 2011/03/08 | Source: SQLServerCentral.com | Category: data warehousing

Rating:

|

Discuss |

Briefcase | 19,992 reads