Look at the following 3 scripts: Transact-SQL -- 1. Hardcoded SELECT * FROM Sales.Orders WHERE DateAndTime < '19900101' -- 2. Variable...

A lot of times, when creating a procedure, we need to use some kind of an empty table in order to perform all kinds of calculations. The...

A few weeks ago Kalen Delaney presented a 3-day seminar in Israel. Unfortunately, I wasn’t able to attend the seminar, but some of our...

Three months ago, I presented a session at the special Rosh HaShana user group meeting. The session was about Monitoring Page Splits. I...

This script creates the “PrintMax” stored procedure, which prints a text of any size. It’s intended to replace the “Print” statement,...

Recently I’ve stumbled upon an apparently little known fact about SQL Server – specifically SQL Server collations and how they affect...

Last week we organized the 24 Hours of PASS event, and we watched together 24 professional webcasts about SQL Server (well, not all 24)....

Hi Everybody, Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course ! Here’s the...

We are opening another class of the “Advanced Programming in SQL Server” course on 28/08. You can find all the details here. Here is an...

This query returns redundant indexes. An index is considered redundant if there is at least one other index for the same table or view...