Tag Archives: testing

Clarity in Code

Posted on October 18, 2010 by Stefan

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

Posted on October 15, 2010 by Stefan

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?

Posted on September 29, 2010 by Stefan

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

Posted on September 26, 2010 by Stefan

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