While working with SQL Server databases, if you often find the database performance sluggish, it could be due to bad coding of procedures or incorrectly set database variables. Here's a tool that can ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

I have users complaining about slow performance in one of our internal applications. The application is, essentially, a front end to a SQL database. We've built a new server for it because the old one ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But this month's column will ...