Clearly, this illustrates the problem with trying to help inexperienced people on a forum that have no desire to listen when you try to suggest a better way.

It would be a good idea to backup the logs much more often to prevent file growth.  Why don't you do it every 5 minutes if that is what your...

The best way to check for a temp table (SQL 2005 only) is to also include the object type parameter in the OBJECT_ID function call.  This makes sure that it...

http://www.google.com, search for NetApp

Please post your non-cursor solution.

The only format that is unambiguous to SQL Server in all circumstances is this:

YYYYMMDD HH:MM:SS.MSS, Example: 20071231 23:23:59.997

Any other format can have...

This script should do what you want.

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

I have been using SQLPing 3.0 that I found at the link below to discover servers, but it is GUI based, so it is hard to automate. It does...

It isn't that hard to recover from transaction log backup files, even if you have hundreds of them.  I use a script that gets the contents of a directory, loads...

You also have to consider what the offset to UTC was at the time the data was written.  If the data you are looking at is from January, then the...

If you are making backups daily and transaction log backups every 15 minutes, then an additional backup should not be necessary.  You can recover forward to the point in time...

The base 12 computer was invented long ago.  You have one on the end of your arm.

"base 12 originates from an ancient method of finger counting, first documented in Babylon,...

Ways to represent 2/3 exactly:

0.2 in base 3

0.4 in base 6

0.6 in base 9

0.8 in base 12

and so on..

I believe any rational number can be represented as a non-repeating number...

DROP INDEX Rules.IX_Rules

Why can't you just use a UNIQUE constraint to do this?