Tag Archives: performance

Carmina Burana may save us

Karen, Justin, some friends and I attended the closing show of Boris Brott’s Music Festival last night in Hamilton. I was on holiday so it was a bit of pain to get there but it was a chance to see … Continue reading

Posted in Miscellany | Tagged , , , , , , , , , | Leave a comment

How to determine where a SQL Server 2005 Index is needed

The right index in the right place can really up your database performance.  But applying too many indices can lead to a very nasty overhead problem. So how do you learn where to spend your index resources where they’re most … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

SQL Server Performance and temporary tables

Yesterday I golbed about SQL Server performance and I thought I’d continue on in that vein today. Temporary tables where a feature in SQL Server that I tended to avoid. I figured that I should handle everything through code and … Continue reading

Posted in Miscellany | Tagged , , | 2 Comments

SQL Server Performance and the IN clause

I enjoy using sub-queries with the IN clause because it fits in my head nicely. I mean that I can translate a sub-query easily in my head with little effort whereas a join requires a little more brain gymnastics. Of … Continue reading

Posted in Miscellany | Tagged , , | 6 Comments

Tuning SQL Server Queries

As everyone who has worked with a useful database for any length of times knows… they get bigger. And as they get bigger it takes longer to squeeze information or data out. So what’s the problem? You might think it’s … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment