Tag Archives: testing

Clarity in Code

Commenting code is always a good idea and there are more ways than one to comment your code. When running a long series of SQL queries it can be useful to know what has run. If you have conditional statements … Continue reading

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

Lecture

I went to a SQL Server lecture tonight on Virtual Machines and SQL Server by Brent Ozar. It wasn’t what I expected. The lecture was great, as have been all the ones in this lecture series, but the advice was … Continue reading

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

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