SQL Server Performance

Virtualizing SQL Server: 8 Things To Avoid

Virtualizing SQL Server: 8 Things To Avoid

Last year I wrote an article for SQL Server Pro Magazine on things to avoid when virtualizing SQL Server. I finally got around to putting the article into slide format and posted it to Slideshare. You’re welcome. The full link to the slides is here: http://www.slideshare.net/ThomasLaRock/virtualizing-sql-server-8-things-to-avoid If you find that you have been doing one(…)

SQL Server Troubleshooting Useful Links

SQL Server Troubleshooting Useful Links

When it comes to troubleshooting performance issues with SQL Server queries, you don’t need an advanced degree in rocket surgery. You just need an idea of what the possible bottlenecks are and then apply some common sense. I “bucketize” performance issues by following a process of asking some simple questions. It goes something like this: Are all queries(…)

HOW TO: ALTER TABLE in Windows Azure SQL Database Without Filling Up Your Transaction Log

HOW TO: ALTER TABLE in Windows Azure SQL Database Without Filling Up Your Transaction Log

One of the things I love most about Windows Azure SQL Database (WASD) is that you don’t have many options when it comes to performance tuning. WASD makes you focus on code and design in order to maximize performance. I would estimate that 98% of all performance issues are due to sub-optimal code and database design(…)

Load More