Browse by Tags
All Tags »
Performance Optimization (
RSS)
Trace flags are very powerful settings that allow you to customize SQL Server behaviour. Most of the trace flags are undocumented in Books Online and there does not exist any official list of them. Some have been mentioned in Knowledge Base articles and...
C# and .NET Framework 4.0 has a good number of really good new features. Some of the best features, from a performance point of view, is the Task Parallel Library and Parallel LINQ (PLINQ) . I did some performance testing recently and was surprised by...
As winner of the previous round, I’ve been given the honor to write the problem for Phil Factor Speed Phreak Challenge #6. This problem is from the real world (algorithmic trading) and the sample data is real. The challenge is to reproduce highest buy...
Have you ever wanted to see the details on how data is organised in a SQL Server database? Exactly how tables, indexes, blogs, etc are stored. How SQL Server can find a specific row in a table. This is possible through two undocumented DBCC commands:...
SQLIO is a great tool to do performance tests on SANs or local hard disks. It helps you identify the optimal configurations for getting maximum data rates and latencies from your storage. Brent Ozar has created a helpful ten-minute video on how to get...
Ever wondered what is the fastest technology for your queries? One way to find out is to let a couple of SQL Server optimization freaks compete who can write the fastest solution. This is what the Phil Factor SQL Speed Phreak Competition is about. Below...