Viewing 15 posts - 2,806 through 2,820 (of 3,008 total)
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...
June 22, 2007 at 8:49 am
This script should do what you want.
Script to analyze table space usage
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762
June 22, 2007 at 8:29 am
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...
June 21, 2007 at 8:03 am
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...
June 20, 2007 at 8:29 pm
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...
June 20, 2007 at 9:18 am
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...
June 20, 2007 at 9:05 am
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,...
June 14, 2007 at 9:58 pm
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...
June 14, 2007 at 6:13 pm
DROP INDEX Rules.IX_Rules
June 14, 2007 at 2:30 pm
Why can't you just use a UNIQUE constraint to do this?
June 14, 2007 at 2:17 pm
Here is a ready built script that will do what you want.
Script to analyze table space usage
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762
June 14, 2007 at 2:11 pm
You can make your backup to a compressed directory.
June 13, 2007 at 4:04 pm
If you are asked this question: “If you were any animal, which one would you be and why?”, the correct answer when interviewing for a management position is:
I...
June 13, 2007 at 4:00 pm
Viewing 15 posts - 2,806 through 2,820 (of 3,008 total)