Viewing 15 posts - 42,736 through 42,750 (of 49,552 total)
KPR (12/1/2008)
Hi Gail,Can you pls give me the syntax for creating index on temp in the proc?
Same syntax as for a regular...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 5:23 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 5:14 am
I've never used a 3rd party tool. Wouldn't know if one exists.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 4:32 am
Sure. They can work fine together. Make sure you install 2000 first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 4:31 am
Please don't use polls unless you are actually posting a poll.
What's the question?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 4:25 am
Viewing 15 posts - 42,736 through 42,750 (of 49,552 total)