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)?
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 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...
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 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...
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 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...
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 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.
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 27, 2013 at 10:07 am
Check all your SQL Agent jobs. Probably find it's a badly written index rebuild job.
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 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...
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 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...
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 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...
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 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...
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 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....
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 27, 2013 at 5:52 am
http://www.amazon.com/Server-Query-Performance-Tuning-ebook/dp/B008E6HOIS/ref=nosim/sitw-20
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 27, 2013 at 4:04 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...
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 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...
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 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...
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 27, 2013 at 3:01 am
Viewing 15 posts - 12,976 through 12,990 (of 49,552 total)