Monthly Archives: September 2010

How much data is there?

We’re all familiar with trying to figure out just how much data is in our database. To get approximately how much memory the whole database takes up you can open SQL Server Management Studio, right-click on the database name you’re … Continue reading

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

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

Taking Notes

I work with quite a few different technologies and I’ll use this blog to talk about all of them as I find interesting things to say about each. Currently I’m working primarily with SQL Server and that’ll be the primary … Continue reading

Posted in Uncategorized | Tagged | Leave a comment