Viewing 15 posts - 35,806 through 35,820 (of 49,552 total)
Go to the services on the server and take a look at each service. If you get the properties of each one, there's a tab 'dependencies'. A service with no...
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
November 17, 2009 at 1:10 am
Execution plan?
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
November 17, 2009 at 1:06 am
You're backing up across the network. Any other network traffic will slow the backup down. Usual recommendation: Backup local, copy remote.
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
November 16, 2009 at 12:54 pm
Wow, and you rebuilt that with no change happening to anything? Sure the rebuild succeeded?
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
November 16, 2009 at 12:45 pm
ryan.mcatee (11/16/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
November 16, 2009 at 12:38 pm
rkaucher (11/16/2009)
You should have used LMGTFY. 😉
I find that condescending and insulting. I've used it once only, after someone repeatedly demonstrated that they were not going to search themselves, and...
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
November 16, 2009 at 9:34 am
The accepted practice is to size them for the workload (regardless of recovery model) and leave them alone.
Shrinking a log is a bad idea unless it's after an unusual...
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
November 16, 2009 at 9:31 am
Do you have auto_shrink on?
Can you run the query with the detailed option and post it so that it's easily readable. If you look at the earlier posts, it's hard...
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
November 16, 2009 at 9:25 am
Stuart Davies (11/16/2009)
...in that I ask more questions than give answers;
There's nothing wrong with asking questions. That's what the forum is here for. The problem is that there are...
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
November 16, 2009 at 9:14 am
I'd say 99%. The fragment size is 1, indicating there are no two contiguous pages, and the number of fragments is the same as the number of pages. This index...
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
November 16, 2009 at 9:05 am
Steve Jones - Editor (11/16/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
November 16, 2009 at 9:04 am
If you need some help with that, start a new thread and post (or attach) the deadlock graph, along with definitions of the tables involved.
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
November 16, 2009 at 8:57 am
Looks like someone needs a basic computer theory course.
Clustering: http://www.sqlservercentral.com/Forums/Topic819325-146-1.aspx
SAN: http://www.sqlservercentral.com/Forums/Topic819323-146-1.aspx
RAID: http://www.sqlservercentral.com/Forums/Topic819327-146-1.aspx
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
November 16, 2009 at 8:56 am
Please read through this - Managing Transaction Logs[/url]
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
November 16, 2009 at 8:56 am
http://www.google.com/search?q=What+is+RAID+10
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
November 16, 2009 at 8:54 am
Viewing 15 posts - 35,806 through 35,820 (of 49,552 total)