Category Archives: 2008

Set Statistics

Any time you’re developing queries in SQL Server, whether they’re single use or intended for inclusion in a stored procedure that’ll be run frequently, you want to know how well your query is running. If it is intended for production, … Continue reading

Posted in 2008, SQL Server | Tagged , , , | Leave a comment

The Best Feature

The best way to learn a programming language, environment or database system is to use it. If you have the chance to play with it, everything you read in the books and on-line about it will make more sense. You’ll … Continue reading

Posted in 2008, SQL Server, Visual Studio | Tagged , , | Leave a comment

Indexes

Never underestimate what the right index can do for you. I was running a query that limited results by an integer representing a date range and it was taking around 37 minutes to run. I didn’t think it all that … Continue reading

Posted in 2008, SQL Server | Tagged , | Leave a comment

Odd bug

This blog won’t all be bugs, but they’re foremost in my mind right now. I’m fortunate to be on a job right now where I get to use the latest software. We have SQL Server 2008 R2 installed on our … Continue reading

Posted in 2008, SQL Server | Tagged , | Leave a comment

Installing SQL Server 2008

Last year I was starting a new contract and needed to install SQL Server 2008 on the machine they’d provided me. This was a machine that had been used by someone before and instead of reimaging it, they just uninstalled … Continue reading

Posted in 2008, SQL Server | Tagged , | Leave a comment