Viewing 15 posts - 12,976 through 12,990 (of 49,552 total)
Depends.
Are those indexes enforcing uniqueness?
Does the period over which those have been tracked cover an entire business cycle (including month end and year end if applicable)?
May 28, 2013 at 9:25 am
If all you want to do is grow the database ahead of time, may I suggest ALTER DATABASE ... MODIFY FILE and specify how large you want the file to...
May 28, 2013 at 8:01 am
ivan.peter (5/28/2013)
Optimizer's choice of join type is not based on the amount of data in the tables.
Optimiser's choice of join type (nested loop, merge or hash) is based on the...
May 28, 2013 at 2:36 am
Lorenzo Mota (5/27/2013)
So, besides the DTS, is there anything automatic or internal of SQL Server that could be doing this?
No. SQL will never automatically change database settings. If recovery model...
May 27, 2013 at 10:49 am
That query's searching procedures and functions, not jobs.
Look at your SQL Agent scheduled jobs, check their steps, see what they do.
May 27, 2013 at 10:07 am
Check all your SQL Agent jobs. Probably find it's a badly written index rebuild job.
May 27, 2013 at 9:31 am
patrickmcginnis59 10839 (5/27/2013)
I was under the impression that the table was either sorted (ordered by a clustered key) or not, so this is a new one for me!
Technically tables are...
May 27, 2013 at 8:38 am
Dird (5/27/2013)
That isn't right away though? Assuming you rebuilt with an 80% fill factor then wouldn't the rebuild order everything properly (meaning no page splits)?
Meaning no fragmentation.
A page split...
May 27, 2013 at 6:09 am
ivan.peter (5/27/2013)
Have you read about In-Memory Hash Join (or this link[/url])?
The MSDN entry several times, as well as blog posts by members of the dev team. Written a few articles...
May 27, 2013 at 6:07 am
m.rajesh.uk (5/27/2013)
1. How to apply all these recommendations all at a time. How to apply them.
There's an option in DTA, accept all recommendations
2. How to verify which of them...
May 27, 2013 at 5:54 am
Dird (5/27/2013)
I would assume you could say "reduce fragmentation" or "reduce the number of pagesplits" interchangeably since as far as I understand an index rebuild would reduce both.
No, you can't....
May 27, 2013 at 5:52 am
Dird (5/27/2013)
They're 1 and the same.
No, they're not.
Can you reduce fragmentation without reducing page splits?
Fragmentation is a property of the index, a number, a measurement of how out of...
May 27, 2013 at 3:58 am
m.rajesh.uk (5/27/2013)
Is there any option that automatically applies all the recommendations from DTA.
Yes.
Is it trustworthy to implement all the suggestions from DTA.
No. You need to see which of...
May 27, 2013 at 3:05 am
Golfer22 (5/26/2013)
Do materialized views and indexed views exist in tempdb or the buffer, correct? They could be in the buffer if the view were small, right?
Neither
I think they usually...
May 27, 2013 at 3:01 am
Viewing 15 posts - 12,976 through 12,990 (of 49,552 total)