Viewing 15 posts - 39,136 through 39,150 (of 49,552 total)
mrlucmorin (5/12/2009)
I'm just stating to think in terms of result set instead of thinking in terms of sequential programming (cursors) for my triggers.
<applause>
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
May 12, 2009 at 12:52 pm
Alvin Ramard (5/12/2009)
You can sing that at our next meeting, next week.
Record it. Please?
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
May 12, 2009 at 12:52 pm
So single disks? No RAID array?
What is an important production database doing on single disks?
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
May 12, 2009 at 12:13 pm
Snapshots don't capture modifications. They show the database as it was at the time the snapshot was created. So, in your scenario, if you query snapshot 1, it will show...
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
May 12, 2009 at 12:09 pm
Just bear in mind that snapshots aren't free. Having lots of them could slow down inserts, updates and 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
May 12, 2009 at 11:39 am
Jonathan Kehayias (5/12/2009)
Out of curiousity, how many disks are in the RAID Array that this database sits on and what RAID level is the array configured for?
Also, is it direct...
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
May 12, 2009 at 11:01 am
What does DBCC OPENTRAN return?
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
May 12, 2009 at 10:59 am
mark (5/12/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
May 12, 2009 at 10:59 am
What's the value of log_reuse_wait_descr in sys.databases for this database?
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
May 12, 2009 at 8:33 am
Have you checked for hardware-related errors in the system event logs, RAID controller logs, etc?
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
May 12, 2009 at 8:09 am
David Benoit (5/12/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
May 12, 2009 at 8:09 am
mark (5/12/2009)
Also, I don't think that your log file should exceed your database size, which will inevitably happen if you leave it alone.
Log file should never get 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
May 12, 2009 at 8:05 am
Steve Jones - Editor (5/12/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
May 12, 2009 at 7:55 am
tosscrosby (5/12/2009)
Hey, watch your language!
I suspect that was nothing more than a mistype. "Tell me the procedure how to restore a DB"
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
May 12, 2009 at 7:52 am
RPSql (5/12/2009)
It is running since 20 hours....Any idea why it is taking so long and why it is not completed yet?
Maybe because there is corruption.
The checkDB algorithms are written in...
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
May 12, 2009 at 7:47 am
Viewing 15 posts - 39,136 through 39,150 (of 49,552 total)