When I was young we used to go to see our local football, sorry, soccer team and cheer them on rain or shine on a Saturday afternoon in England. In those days the cheapest way to watch the game was ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

Microsoft on Thursday released Service Pack 3 (SP3) for SQL Server 2008. The new service pack arrives about one year after the release of Service Pack 2. SP3 contains a lot of fixes to the earlier ...

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

Creates indexes on columns in tables. Restriction: You cannot use CREATE INDEX on a table accessed via an engine that does not support UPDATE processing. an IN subquery where the column in the inner ...