Deterministic Functions

Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005

James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.

Distinct with Aggregate Function

Sample of combination the Distinct clause with Aggregate Function

T-SQL Function to Determine Holidays in SQL Server

While working on a project recently I was asked to develop a mechanism that would provide the dates for state and federal holidays in a given year. Since this project deals with all states and territories of the United States, the list had to be comprehensive and the client asked that this list be in the form of a SQL query calculated on-the-fly, rather than a static list.

Owning the Spelling Suggestion Feature

To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it.

XML Index

Checking XML indexs with a sample.

Using sp_xml_preparedocument

Using sp_xml_preparedocument and sp_xml_removedocument

Get Missing Index info

A script to get the missing index information for a table.

Script to return Rows count from table using sp_ExecuteSQL

Script to return Rows count from table using sp_ExecuteSQL

Delete Duplicate values

Delete duplicate values from table