Viewing 15 posts - 42,751 through 42,765 (of 49,566 total)
atulkumar2 (12/1/2008)
Thanks for pointing out my mistake. Yes, we should truncate the log file just before the Database backup.
I prefer to say that the log should not be truncated at...
December 1, 2008 at 5:22 am
I wouldn't know if a 3rd party tool exists. I've never used one.
I've done all my testing with either excel or with the checksum/checksum_agg functions
December 1, 2008 at 5:14 am
Please don't cross post. It just wastes peoples time and fragments replies. There's no need to start a new thread, there are several answers to your original one.
No replies to...
December 1, 2008 at 5:14 am
I've never used a 3rd party tool. Wouldn't know if one exists.
December 1, 2008 at 5:08 am
barb.wendling (12/1/2008)
For example, I did not see the EventClass ID definitions in BoL.
In the 2008 Books Online, the section title is "SQL Server Event Class Reference" and the address...
December 1, 2008 at 5:05 am
atulkumar2 (12/1/2008)
1. I did mention that the command should be used once the Full Backup is taken. This eliminates the chances of any data loss.
Actually, it's the other way round...
December 1, 2008 at 4:56 am
You may want to consider an index on the temp table
I wouldn't normally suggest a wide clustered index, but since this is a temp table, perhaps a clustered index on...
December 1, 2008 at 4:52 am
atulkumar2 (12/1/2008)
BACKUP LOG @Database_Name WITH TRUNCATE_ONLYDBCC SHRINKDATABASE (@Database_Name, 20);
You neglected to mention that the above statements will
1) break the recovery chain of the database by discarding log records, leaving it...
December 1, 2008 at 4:36 am
puneet shadija (12/1/2008)
since we have many threads, which may concurrently try to insert a record to this table, thus I have used this lock to prevent this from happening
Why? What's...
December 1, 2008 at 4:33 am
What's the definition of the login table?
If you run the query that Chirag posted, what do you get?
December 1, 2008 at 4:32 am
Sure. They can work fine together. Make sure you install 2000 first.
December 1, 2008 at 4:31 am
Please don't use polls unless you are actually posting a poll.
What's the question?
December 1, 2008 at 4:28 am
Keep a copy of the old proc, under a different name, and you can run them both to check.
I've often used Excel to compare two resultsets. Put each resultset...
December 1, 2008 at 4:28 am
When you say "update is not working", what exactly do you mean?
Throws an error?
Runs forever?
Updates no rows?
Something else?
December 1, 2008 at 4:25 am
On the first execution, the statement has to be complied and optimised. The optimiser will optimise all of the queries in the proc, regardless of whether or not they can...
December 1, 2008 at 4:24 am
Viewing 15 posts - 42,751 through 42,765 (of 49,566 total)