Viewing 15 posts - 33,436 through 33,450 (of 49,552 total)
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/Topic885294-1044-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
March 18, 2010 at 1:55 am
Do you get them while building the search indexes?
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
March 18, 2010 at 1:44 am
T_SqueaKquel (3/17/2010)
(ii) Checksum before writing to media
No. Backup with the CHECKSUM option.
And both are for full and log backups, not just log
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
March 17, 2010 at 3:25 pm
No, you don't want to run a checkDB every time you back the log up. That's just insane. If you're backing up every 15 min, CheckDB can easily take longer...
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
March 17, 2010 at 2:51 pm
T_SqueaKquel (3/17/2010)
1. How much overhead would it add if I include a verify backup when finished, is there a way to test it out.
Put it this way. Would you rather...
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
March 17, 2010 at 2:25 pm
Tim Weintz (3/17/2010)
You most likely be under surveillance the entire time and will only be provided with an erasable felt pen and a calculator.
Excluding the calculator, that's standard exam centre...
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
March 17, 2010 at 2:21 pm
Do you think that you could grab that Statistics XML plan and post it please? As I mentioned, I mixed the two profiler events up, and the showplan doesn't have...
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
March 17, 2010 at 11:04 am
Edited..
Is that the only index on the table? No primary key?
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
March 17, 2010 at 9:34 am
Your data is committed to the data file. That happens shortly after a transaction completes. In full recovery, the inactive log records are not cleared until they are backed up.
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
March 17, 2010 at 9:11 am
The pass mark is 700. The number of questions varies and there's no way to tell how the questions are scored.
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
March 17, 2010 at 9:09 am
That just shows a table scan. It's not using any index at all, estimating one row only. Looks like it's only a partial plan too, not sure why, so lots...
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
March 17, 2010 at 9:06 am
1) Whenever a checkpoint occurs. Only log records up to the beginning of the oldest open transaction can be truncated.
2) Do it in batches and run CHECKPOINT between those batches.
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
March 17, 2010 at 6:54 am
Bhuvnesh (3/17/2010)
if possible, required ORDER can be set in physical table and then avoid "order by" clause in derived query
Order of returned rows is NOT guaranteed unless ORDER BY...
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
March 17, 2010 at 6:47 am
David Nash-367764 (3/17/2010)
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
March 17, 2010 at 6:46 am
The Dixie Flatline (3/16/2010)
Gail, in ancient Geece you would have been a goddess in the Geek pantheon.
:hehe:
I have 3 t-shirts now that have geek written on the front. One 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
March 16, 2010 at 3:54 pm
Viewing 15 posts - 33,436 through 33,450 (of 49,552 total)