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

How to remove the IDENTITY property from an existing column using T-SQL (without changing the order of the columns or moving the data...

Profiler is a great tool. Everybody knows that. You can catch almost any event that occurs in the server while choosing the columns to...

Last month, in the SQL Server Users Group meeting, I presented a session called “Things You didn’t Know about SQL Server”. The first...

Many people get confused, thinking that SQL Server Profiler is the actual tracing feature of SQL Server, while in fact it is only an...