Category Archives: SQL Server

Stored Procedures don’t necessarily stop at an error

Posted on August 29, 2011 by Stefan

I normally expect precedence to save me in my stored procedures. If I have six statements and the third ones fails, I expect the fourth through sixth not to run. Boy, was I wrong. Normally I test my stored procedures … Continue reading →

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

Column Naming

Posted on November 4, 2010 by Stefan

When you’re designing your tables it is important to keep track of the names you’re using for the columns. Don’t just name the ID columns ID. Name them so you’ll know what table the ID belongs to. For example, if … Continue reading →

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

Redundancy

Posted on November 1, 2010 by Stefan

There are certain types of redundancy that are good in the IT world: Backups, failover servers, recovery plans and the like. Most redundancy however, is bad. In the programming world, bad redundancy comes in the form of repeated code instead … Continue reading →

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

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

Resources

Posted on October 13, 2010 by Stefan

I’d like to recommend a web site for learning SQL Server and for all your questions as you get stuck. And you will get stuck, believe me, at least if you do anything at all beyond the basics and probably … Continue reading →

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

Data Transformation Quirk

Posted on October 12, 2010 by Stefan

In SSIS when creating a Data Flow Task, you’ll usually want to have a destination for your data. From everything I’ve read, if your package is running on the same server as your destination, you’ll want to use SQL Server … Continue reading →

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

File System Task

Posted on October 5, 2010 by Stefan

I’ve used the File System task before, but it was to do a daily copy of files in a directory. I used copy directory so I didn’t have to specify or loop through any files. It was the same process … Continue reading →

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

Aliases

Posted on October 1, 2010 by Stefan

Aliases seems to be something people don’t think much about. They learn that you can call a table or a column something else for reference elsewhere in your query and they go about using it. Sure, sometimes they can’t understand … Continue reading →

Posted in 2008, SQL Server | Tagged , , , | 2 Comments

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