Viewing 15 posts - 40,861 through 40,875 (of 49,552 total)
Your disk stats are high. Both sec/read and sec/write should be around 10ms. On C, your sec/read reaches 0.5, on D, G and Z the sec/write reaches 0.1. Both of...
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
February 21, 2009 at 3:11 am
susaabraham (2/21/2009)
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
February 21, 2009 at 3:03 am
angel0in (2/20/2009)
I am planing to use SQL Server Express on one machine and use it from 5-6 machines on LAN. In that case is also stable according to GilaMonster
That's not...
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
February 21, 2009 at 3:01 am
y.koteswarrao (2/21/2009)
I have executed the DBCC Checkdb() and found that the database is mared as suspect,How can i reslove this issue?
Depends why it's suspect.
Please post the full output of checkdb...
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
February 21, 2009 at 2:58 am
Ninja's_RGR'us (2/20/2009)
If you start with a fresh set of backups once the server is back online, can it avoid restoring troubles later on?
I would think so. I'm not sure...
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
February 21, 2009 at 2:20 am
Lynn Pettis (2/20/2009)
Nope. Check your profile.
:blush: I forgot that was in there.
So much for that...
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
February 21, 2009 at 2:04 am
Krishna (2/20/2009)
Because in SQL server, the first column is enforced by an index
No, the entire primary key is enforced by an index, not just the first column.
A second 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
February 21, 2009 at 2:03 am
brekher (2/20/2009)
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
February 21, 2009 at 2:01 am
Lynn Pettis (2/20/2009)
Let me guess, let's say around early 30's. Say right around the time I graduated high school. Close??
Just about dead on.
Lucky guess?
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
February 20, 2009 at 3:21 pm
xgcmcbain (2/20/2009)
as for reubilding indexes, sql server does not do this automatically at some point?
No
What are the reasons for having to rebuilding indexes? inserts, deletes?
Inserts mostly, updates a bit, deletes...
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
February 20, 2009 at 3:20 pm
Bob Hovious (2/20/2009)
Is there an easy way to search for all the threads he has originated?
Yup. Click on his username, select "View all posts by this member"
You sure you want...
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
February 20, 2009 at 3:18 pm
Lynn Pettis (2/20/2009)
Bob Hovious (2/20/2009)
I graduated high school in 74.
I graduated 77, so I wasn't so far off.
I don't think I want to give away date of birth. I...
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
February 20, 2009 at 3:15 pm
Ninja's_RGR'us (2/20/2009)
Would it be prudent to rerun all the backups after the rebuild is done so that any data loss cannot screw something up later on?
Repair or rebuild?
Repair, definitely.
Rebuild is...
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
February 20, 2009 at 3:14 pm
Access gets corrupt because it's in memory on the client machine. Remember that SQL is a server app. It's running on the server, not the client PC adn it won't...
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
February 20, 2009 at 3:12 pm
Hmm. I think we're going to need more info.
Please post sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
February 20, 2009 at 3:09 pm
Viewing 15 posts - 40,861 through 40,875 (of 49,552 total)