Viewing 15 posts - 31,636 through 31,650 (of 49,552 total)
sqlblue (7/26/2010)
This table has one non-unique clustered, so it couldn't be a heap (a heap is a table has no index, correct?).
A heap is a table without a clustered 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
July 26, 2010 at 6:40 am
Ray Mond (7/26/2010)
The thing to remember is that while your backup data goes nowhere, SQL Server still recognises it as a 'valid' backup.
Yup. SQL doesn't care what the file...
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
July 26, 2010 at 6:36 am
Are you sure that the data is the same?
The actual plan for Environment Q has 3.4 million rows coming out of the parallelism operator (the last operator that shows the...
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
July 26, 2010 at 6:28 am
Same hardware?
Same load?
Same amount of data?
Same schema?
Can you post the actual execution plans rather than the estimated please. There's a lot of info that isn't in the estimated plans.
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
July 26, 2010 at 5:44 am
TheSQLGuru (7/26/2010)
IIRC the way frag is presented/calculated on heaps is a bit different than for clustered tables.
Yup. The avg_fragmentation_in_percent in dm_db_index_physical_stats is extent fragmentation for a heap and logical fragmentation...
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
July 26, 2010 at 5:24 am
From what I've heard, deadlocks are 'expected' on sharepoint when running the search crawl. They can be ignored as the search will retry the queries. (this is per the Sharepoint...
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
July 26, 2010 at 5:23 am
Restore from backup is the way to 'undo' changes. If you have no backup (why not?) then there's no practical way of undoing.
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
July 26, 2010 at 4:50 am
NUL is a special 'file' in the file system (same as LPT1, COM1, CON if you remember back to the DOS days). It's the nul device, the trash bin, the...
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
July 26, 2010 at 4:48 am
Please note: Year-old thread.
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
July 26, 2010 at 2:20 am
Is that a single attribute or 4 different values that need storing?
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
July 26, 2010 at 2:17 am
Under 24 pages, a rebuild will have little to no effect, due to the way SQL allocates pages for small indexes. The 1000 page threshold is usually specified as an...
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
July 26, 2010 at 2:15 am
Excellent. Is that good enough or do you need it optimising further?
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
July 26, 2010 at 2:11 am
You could always edit that and change the thresholds if you want. Unless you know that you need to rebuild/reorganise for performance.
If you're rebuilding or reorganising, you're going to generate...
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
July 25, 2010 at 1:57 pm
So the deletes make space and the inserts reuse that space. If the rows are all the same size, I'm not too surprised this causes minimal fragmentation.
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
July 25, 2010 at 10:39 am
Why don't you use a custom index rebuild script that only rebuild indexes in need of it? That should reduce the log impact.
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
July 25, 2010 at 9:40 am
Viewing 15 posts - 31,636 through 31,650 (of 49,552 total)