Viewing 15 posts - 12,991 through 13,005 (of 49,552 total)
ivan.peter (5/27/2013)
- even an execution plan of some queries can be different (faster), if the database knows, the table fits into memory
The optimiser never considers whether a...
May 27, 2013 at 2:57 am
Mabe check google for an article on the basics of clustering?
May 27, 2013 at 2:55 am
Dird (5/26/2013)
It's the same thing -_ rebuild index -> avg_fragmentation_in_percent reduces along with page splits.
No.
Page splits cause fragmentation. Rebuilding an index does not reduce page splits, it reduces fragmentation...
May 27, 2013 at 2:52 am
Golfer22 (5/26/2013)
If you could use table variables instead of temporary tables, that could help. But it requires a large amount of memory. Upgrading memory could help.
Unlikely, since table...
May 27, 2013 at 2:50 am
Dird (5/26/2013)
If so would your focus be on avg_fragmentation_in_percent in order to minimise page splits?
Err....
Reducing avg_fragmentation_in_percent doesn't minimise page splits. Page splits cause fragmentation, resulting in high avg_fragmentation_in_percent.
I look at...
May 26, 2013 at 5:07 pm
Can you post all the printed statements?
May 26, 2013 at 5:05 pm
Dird (5/26/2013)
Where are you seeing that? Which columns are the most important to look at?
avg_fragmentation_in_percent and avg page space used. You want them low and high respectively, yours are...
May 26, 2013 at 1:40 pm
Change the proc to print not execute the dynamic SQL and run it with exactly the parameters that result in the error every 2 weeks
May 26, 2013 at 1:39 pm
Yuri55 (5/26/2013)
Moreover, as all statements were executed successfully, how SP can return error-it suppose to fail on any if there is syntax error?
Because the syntax error was in the dynamic...
May 26, 2013 at 12:57 pm
Dird (5/26/2013)
The AutoShrink setting for the database (properties -> options -> AutoShrink). It's not what you were talking about?
Yes. Sounded like you were saying that autoshrink didn't work (disabled) in...
May 26, 2013 at 12:55 pm
Dird (5/26/2013)
Autoshrink is disabled in 10.5.
???
May 26, 2013 at 11:58 am
Dird (5/26/2013)
Oh OK, so it's just about the amount of page splits?
Not necessarily. Other things than page splits can cause fragmentation, like database/file shrink operations.
May 26, 2013 at 11:44 am
The syntax error is within some dynamic SQL and hence only caught when the dynamic SQL is executed. You'll need to add a PRINT statement to print the dynamic SQL...
May 26, 2013 at 11:36 am
Dird (5/26/2013)
Judging by this it would lead me to believe that only 1-2% of each page is being used?
That's not what fragmentation means. Nothing wrong with the query or...
May 26, 2013 at 11:27 am
Viewing 15 posts - 12,991 through 13,005 (of 49,552 total)