So do you all avoid dynamic SQL as much as possible then? Do you have any stored procedures that use dynamic SQL?

Since I have been in my current position...

Another factor that moved me toward the DBA position I took was I wanted to stop traveling (as an installer I traveled two weeks out of every three) and the...

Correct, in my first job as a DBA we only had on SQL Server 7.0 and none of us had experience with it since I moved all our data from...

I don't think we've had a problem with security since our web site uses one user login for all stored procedures. And data updates by our researchers are done...

Learning experiences like this are not fun at the time they are happening and I certainly would never go out of my way to create them. However, problems like...

Are you talking about the log files that a DTS package will produce to tell you which task succeed and which fail. If so, I don't like them because...

I keep forgetting that there are major differences between SQL Server 7.0 and SQL Server 2000. The servers I use are SQL Server 7.0 and my previous post describes...

I prefer production servers to be dedicated to SQL Server only. This way there is no conflict of resources and no question as to where a problem is if...

Early this morning I added a cluster index to a table with 9 million rows in it. Upon completion I noticed that the database size had grown from about...

I have used a similar technique in DTS packages. When testing a certain part of a DTS package and unable to monitor its progress I'll go to where I...

This sound similar to something we do that could work for you. We have DTS packages that create a table with _new on the end and then pump the...

Thanks! I'll remember these for next time, unfortunately the tables seem to have vanished on there own.

Robert Marda

I liked your funny article, especially numbers 1, 22 and 32.

Robert Marda

Are you using a maintenance plan to back up all transaction logs? If so you might want to backup the transaction log for each database separetely to find out...

These are and will be good improvements. I hope the ratings on FAQ's will not automatically be factors in the on going contest as I don't think it would...