Naomi explains her winning solution to TSQL Challenge 17

This challenge is related to a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.

Here is another XQuery exercise that uses the contains() function to match a string pattern against an XML element and retrieves values from a sibling element.

This post explains how to fix the SQL Server error message "Msg 468, Level 16, State 9, Line 1 Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation".

Have fun with this TSQL Holiday Message. Run the code given in the story and you will be surprised to see the output.

Michael DeFehr has written an excellent explanation of his winning solution to TSQL Challenge 14.

How to copy, cut and paste column names from tables while in the SQL 2000 Query Analyzer.

I have created a Backup Script to backup all the databases in our SQL Server 2005. I want to keep old backups for sometime for some reason; so I want to create subdirectory with the run date as the name of the folder to separate the set of backups by date.

For some reasons, DBA’s need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes. Here we are going to rename our Database named “Bad_Ass_DB” into “Best_Practice_DB”. This is how Database renaming with TSQL is done in SQL Server 2005....

Watch out for these events!

Link to the "Writing Better Queries" presentation that Joe Webb gave at the Nashville SQL Server User Group meeting on 4 April 2008.

Does the order of the search criteria make any difference in Microsoft SQL Server's ability to use indexes or resolve a query? In this post, Joe provides a demonstration of how SQL Server can optimize the WHERE clause to its benefit.

Build a complete Stored Procedure based Data Access Layer using Code Generation - Part 2

Build a complete Stored Procedure based Data Access Layer using Code Generation Part 1