Building calendar table using MTVF

This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/

Calculate two internships

Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd

Date calculation

Data calculation in form yy mm dd

Getting resource content from blocked process report

This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.

Getting resource name from blocked process report

The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.

Query to Excel Stored Procedure

Transform your query result into an Excel file using this technique.

How to add comments to your database

Practical usage of SQLCLR: Building QueryToHtml function

This article shows a few techniques with SQLCLR to to transform a query result into HTML.

How to Capture Deleted Records

This article shows a few techniques that help in capturing deleted records.