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

Last Sunday I presented a session by the name “30 Things You didn’t Know about SQL Server” together with Noam Brezis. We presented this...

Microsoft is working hard on pushing a SharePoint server and integrating every reporting aspect in it, from the new PivotTable to...

Our presentation booth at the Data Platform conference included an SQL Server challenge. Many people participated in trying to solve the...