Viewing 15 posts - 36,196 through 36,210 (of 49,552 total)
Steve Jones - Editor (10/21/2009)
Am I missing something?
I thought we were talking about the restart-recovery, not the restore from backup.
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
October 21, 2009 at 9:40 am
I could easily understand a 2.1 billion row transaction rolling back during recovery, that would mean it hadn't hit the COMMIT at the time that SQL was stopped and had...
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
October 21, 2009 at 8:51 am
Using braindumps is cheating. They are actual questions taken from the actual exams (in violation of the NDA that a candidate has to accept) and posted illegally online.
Using or promoting...
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
October 21, 2009 at 8:45 am
The only difference between an estimated and an actual execution plan is that the actual execution plan includes some runtime information. Actual row counts, actual number of executions and a...
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
October 21, 2009 at 8:34 am
Network glitch. Since you're restoring from a network drive, all you need is a moment where the backup isn't accessible and the restore will fail. Copy the file locally, then...
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
October 21, 2009 at 8:31 am
Philip Millwood-419646 (10/20/2009)
2.1 billion transactions rolled forward. 34 rolled back.
If I may suggest...
Do some ongoing monitoring on the frequency and duration of the checkpoint operations. With a default recovery...
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
October 21, 2009 at 12:48 am
Jeffrey Williams-493691 (10/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
October 21, 2009 at 12:47 am
Shark Energy (10/20/2009)
How do you all go about rolling back to Server A after a period of time of using the Server B Recovery box?
Depends on what High Availability technology...
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
October 20, 2009 at 3:08 pm
Agreed. Interviews that I did for admins I rather ask for two types of SQL backups.
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
October 20, 2009 at 8:49 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
October 20, 2009 at 8:47 am
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/Topic805754-386-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
October 20, 2009 at 8:42 am
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/Topic805754-386-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
October 20, 2009 at 8:40 am
steveb. (10/20/2009)
GilaMonster (10/16/2009)
Index types. Never yet found someone who could tell me two types and the differences between them
Seriously? I find this a bit worrying, ...
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
October 20, 2009 at 8:26 am
I've seen a case (posted here actually) where someone implemented the recommended indexes and performance degraded 40%.
I have a client that ran DTA, implemented all of it's recommendations and now...
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
October 20, 2009 at 8:26 am
Bru Medishetty (10/19/2009)
Well, according to my knowledge, SQL Server uses round robin procedure.
If there are multiple log files, they are used in a round-robin approach, but not the data...
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
October 19, 2009 at 10:35 pm
Viewing 15 posts - 36,196 through 36,210 (of 49,552 total)