BANGALORE, INDIA: SQL Server 2008 comes with quite a few new features that have more stress on query performance such as filtered index. In this article, we will see how exactly filter indexes help ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

In an earlier tip I discussed how indexes can speed up processing. It's only fair that I also talk about when indexes don't help. First: Because indexes don't always help but do always increase the ...

SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...

It is usually a good idea to index columns that contain primary keys since they are unique and can often be referred to by row numbers. You can create a nonclustered index faster by selecting only the ...

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

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.

As part of my weekly maintenance routine, I rebuild the indexes on several of my larger high-activity tables. I'd like to try and get an idea of just how long the rebuilds take. The rebuilds are ...

Anyone have any ideas about how to simulate real-world scenarios in a dev environment? Specifically regarding SQL Server. To get a good picture of real-world performance behaviors (locking, blocking ...