Viewing 15 posts - 136 through 150 (of 1,518 total)
Wow, thank you guys, this is great!
I was thinking of UNPIVOT too, but had no clue how to do it.
In the past I have done this comparison with a series...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
December 10, 2011 at 6:56 am
Evil Kraig F (12/9/2011)
Are there identifiers that can be used to group these rows?
Basically, what you're...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
December 9, 2011 at 1:21 pm
SQLRNNR (12/5/2011)
Is it installed on same box or different box as SQL Server?
If...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
December 5, 2011 at 11:22 am
GilaMonster (11/18/2011)
http://sqlskills.com/BLOGS/PAUL/post/Missing-index-DMVs-bug-that-could-cost-your-sanity.aspx
Wow, thanks!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 18, 2011 at 12:00 pm
Ninja's_RGR'us (11/18/2011)
It's a known bug. I don't know if and when it was fixed since I'm still heaviliy stuck on 2K5.
Thank you, I will google it further.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 18, 2011 at 9:27 am
I found this link which deals with this exact issue;
(my server is on SQL 2008 SP1):
I am able to view the XML graphically through SQL Sentry plan explorer:
http://sqlsentry.net/plan-explorer/sql-server-query-view.asp
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 18, 2011 at 8:15 am
It looks like you have SSMS tools installed.
This is a free download:
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 15, 2011 at 1:11 pm
_Beetlejuice (11/12/2011)
Are the execution plans on the dev and live environments the same?
Plans are quite different.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 13, 2011 at 5:13 am
Ninja's_RGR'us (11/12/2011)
Please upload the actual execution plan.
I would love to do that, and I do understand the need for it. However, I will first have to check with my...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 12, 2011 at 6:24 am
wiseman1982 (11/11/2011)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 12, 2011 at 4:53 am
SQLRNNR (11/11/2011)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 11, 2011 at 2:47 pm
The main problem here is lack of consistency.
How can I expect the developer to fix this, if it cannot be reproduced in the dev environment?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 11, 2011 at 12:49 pm
SQLRNNR (11/11/2011)
did it get progressively slower, or did it just happen all of a sudden?
It happened suddenly; it was completing daily in a few seconds until one day at the...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 11, 2011 at 12:46 pm
Still no luck after recompiling proc in production.
Proc run in production is still very slow.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 11, 2011 at 12:35 pm
I am still confused about something.
Several of the tables involved in the sproc have their stats updated daily through a daily manual process.
These tables are found in the SQL statement...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 11, 2011 at 11:48 am
Viewing 15 posts - 136 through 150 (of 1,518 total)