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...

Sometimes you need to create a new login from an existing login. For example, recently I helped one of my customers to move all the...

Since SQL Server 2005, Microsoft added the nice addition to the common DML statements UPDATE and DELETE by allowing the use of the TOP...