Gail Shaw

Forum Replies Created

Viewing 15 posts - 40,051 through 40,065 (of 49,571 total)

RE: Restore multiple Differential backups

To restore more backups the database has to be in norecovery, which means it's not readable. Diff backups aren't really suitable for keeping a test server up to date. Have...

April 2, 2009 at 7:32 am

#970663
RE: Are the posted questions getting worse?

Ramesh (4/2/2009)
Anyways, I still think that he deserves a little more help and that too if he shows his willingness to learn and try things on his own.
We've tried to...

April 2, 2009 at 7:29 am

#970657
RE: IO Statistics

Grant Fritchey (4/2/2009)
Mainly based on the scan count. I'm still assuming, possibly incorrectly, that the second query was able to read from cache where as the first had to go...

April 2, 2009 at 7:23 am

#970648
RE: Disappearing DBCC Errors

Corruption 90% of the time is a hardware issue.
http://www.sqlskills.com/BLOGS/PAUL/post/How-to-tell-if-the-IO-subsystem-is-causing-corruptions.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-26-Myths-around-causing-corruption.aspx

April 2, 2009 at 7:19 am

#970645
RE: Master database corruption

You'd restore the backup of master that you have from Server A. The fact that you have a second server is immaterial.
http://msdn.microsoft.com/en-us/library/ms190190.aspx

April 2, 2009 at 7:17 am

#970641
RE: How to avoid Deadlock in sql server

The full procedures please (both of the ones involved in the deadlock), plus table structure and index definitions. If you can post the deadlock graph (produced by traceflag 1222) as...

April 2, 2009 at 7:09 am

#970636
RE: Data Missing in SQL Server Logs

Probably means that SQL went down or hung at 1:13.

April 2, 2009 at 7:08 am

#970633
RE: Data Missing in SQL Server Logs

sbvenkatesh77 (4/2/2009)
We are working in 24/7 production support. One day afternoon, we found that sql server was hangs.
We checked in the Windows Applicaton Event Viewer....

April 2, 2009 at 4:05 am

#970500
RE: How to avoid Deadlock in sql server

Without seeing the queries in question, the only advice I can give you is to ensure there are no unnecessary commands within the transactions, ensure that your queries are as...

April 2, 2009 at 4:03 am

#970498
RE: TempDB - TempDev will not shrink - Help!

Did you run the 'update usage' that the kb article refered to?

April 2, 2009 at 3:51 am

#970487
RE: IO Statistics

Paul White (4/2/2009)
Not so sure. The article you wrote simply shows that a range seek/scan can cover all the rows in a table. Well, yeah 😉
I was challenging...

April 2, 2009 at 3:49 am

#970486
RE: IO Statistics

Paul White (4/2/2009)
My understanding is that a 'seek' always selects one row (either by key or rid).
A scan may be a scan of any part of an index, which involves...

April 2, 2009 at 2:39 am

#970443
RE: Running Stored Procedure gives error --> The identifier that starts with is too long. Maximum length is 128.

Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic688600-338-1.aspx

April 2, 2009 at 2:28 am

#970435
RE: IO Statistics

Grant Fritchey (3/27/2009)
1. The first query, by a long shot. Although it has a higher number of physical reads. But if both these queries are accessing the same data then...

April 2, 2009 at 2:26 am

#970433
RE: How would a SQL Server 2005 database lose a few days data?

sunny Brook (4/1/2009)
First of all, to PREVENT this from happening gain, please PUT the DBs into FULL recovery mode and Schedule Regular Transcatinal LOG backup.
Full recovery is not going to...

April 2, 2009 at 2:26 am

#970432

Viewing 15 posts - 40,051 through 40,065 (of 49,571 total)