I think the answer to that question relies most on what it is your current role is and what the company needs out of it's databases.

My role requires that I...

The longer I've been doing this (only about 4 years now), the more I write and diagram before I code.

Simple stuff I still just write off the top of my...

The last time I had to do this, I resorted to a cursor and temp table. I was thinking about it though, and if you can put the min...

I think Antares686 meant to say:

coalesce(column1,1) * coalesce(column2,1)

Matthew Galbraith

I've used all three methods, depending on the situation. I use packing bits most of the time when I need to "score" rows based on some criteria to determine...

That was a good article on packing bits into integer fields, I just wanted to add a little something. Before I begin, though, I want to note that this...

They call me a Database Analyst, but really my role is more of a programmer flavored with a hint of DBA...

I've done a lot of VB coding, SQL coding, and...

Just a quick addition regarding the TS comment.

If your server isn't running Terminal Services, you can use a remote control program to remotely start the file copy. There is...