Viewing 15 posts - 286 through 300 (of 1,518 total)
I hate being on call! :w00t:
When I'm on call, I want to retire early.
When not on call, I feel I want to work with SQL to the grave.
But, aside...
__________________________________________________________________________________
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]
May 31, 2011 at 2:56 pm
Craig Farrell (5/16/2011)
See this article: http://msdn.microsoft.com/en-us/library/ms187317.aspx, in particular in the remarks section for when you have to manually start a population. If WITH...
__________________________________________________________________________________
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]
May 16, 2011 at 7:03 pm
OK, thank you!
__________________________________________________________________________________
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]
May 16, 2011 at 9:19 am
The use of static readonly fields for SAFE/EXTERNAL_ACCESS assemblies is discussed here:
http://www.devx.com/codemag/Article/34918/1954
__________________________________________________________________________________
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]
May 16, 2011 at 8:09 am
Steve-524674 (5/5/2011)
Hi, Marios. Did you ever get additional information on this? Do you have a sample of the code before and after in c#?
Hmm, that was a while ago, I'd...
__________________________________________________________________________________
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]
May 5, 2011 at 4:00 pm
There is also this white paper:
Plan Caching in SQL Server 2008
http://msdn.microsoft.com/en-us/library/ee343986(v=sql.100).aspx
See "Query Plan Reuse" section on factors affecting plan reuse.
__________________________________________________________________________________
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]
May 4, 2011 at 1:21 pm
Thank you all for your responses.
There are indeed at least a couple of 'sins' committed by the devs here that are causing recompilations and are likely the culprit.
(Incidentally, the number...
__________________________________________________________________________________
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]
May 4, 2011 at 8:01 am
I found this link reporting similar issue:
http://www.sqlservercentral.com/Forums/Topic979929-360-1.aspx#bm979947
Does anyone have a query that looks at a bunch of exec plans and reports on differences?
__________________________________________________________________________________
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]
May 3, 2011 at 1:03 pm
Ninja's_RGR'us (5/3/2011)
Are use sure those are called via RPC and not via...
__________________________________________________________________________________
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]
May 3, 2011 at 12:04 pm
Here is the code:
SELECT
P.usecounts
,P.cacheobjtype
,H.query_plan
,LEFT([sql].[text], 1000) as [text]
FROM
sys.dm_exec_cached_plans P
CROSS APPLY
sys.dm_exec_query_plan(plan_handle) H
OUTER APPLY
sys.dm_exec_sql_text (p.plan_handle) [sql]
WHERE objtype ='Proc' AND LEFT([sql].[text], 1000) LIKE @procName;
__________________________________________________________________________________
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]
May 3, 2011 at 11:53 am
Run your sql statement and obtain the *actual* exec plan.
In the exec plan identify the operator(s) with the largest cost, eg. clustered index scan.
Compare actual with estimated number...
__________________________________________________________________________________
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]
May 2, 2011 at 2:58 pm
I have actually just tested the above scenario, and was able to reproduce one job schedule overwriting another, by simply using the same @schedule_uid.
I deployed a new job on a...
__________________________________________________________________________________
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]
May 2, 2011 at 2:04 pm
I've experienced this before, but I'm not quite sure why this happens either.
I do have a theory though. In the job script, there is code like in sample below:
...
EXEC @ReturnCode...
__________________________________________________________________________________
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]
May 2, 2011 at 1:57 pm
Are there any scenarios where having the dll file present is required?
I have had reports from our dev/QA teams that after a certain database is restored from production to 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]
April 20, 2011 at 5:02 pm
opc.three (4/20/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]
April 20, 2011 at 2:58 pm
Viewing 15 posts - 286 through 300 (of 1,518 total)