This will probably be heresy so up front I will apologise to Gail,

but,

what I did was select the proc stats from dm_exec_procedure_stats and order by total logical reads descending.

THEN

Copy...

For anyone googling, the solution is that SSRS does not explicitly set the arithabort option.

It will inherit whatever is set at the DB level.

In my case, the DB's have...

When you say 'update' do you mean rebuild or reorganize or is there a fragmentation level that your maintenance plan uses to decide whether to rebuild or reorganize.

If you are...

Add an unnecessary sort.

That should make the index seek use proportionately less cost of the entire query.

But, why would you want to?

So Diff's don't worry me too much.

A failed backup is of course top priority...

Thanks for the ideas.

We had an issue recently where a backup did not actually fail but was stuck for an extended period so the job did not complete and hence...

Looking at the example, it looks like it should run that subquery iteratively.

Looks like maybe this is a prime example for APPLY?

But an alias is being referenced (RT) which has...

This seems to work well.

;WITH XMLNAMESPACES ('www.microsoft.com/SqlServer/Dts' AS pNS1,

'www.microsoft.com/SqlServer/Dts' AS DTS) -- declare XML namespaces

SELECT c.name,

SSIS_XML.value('./pNS1:Property[@pNS1:Name="ObjectName"][1]',

'varchar(100)') AS ObjectName,

SSIS_XML.value('./pNS1:Property[@pNS1:Name="Description"][1]',...

For anyone looking for this type of solution, this will check up to 10 levels of separation, and also return the number of jumps to get to the base object.

Of...

Thanks Anthony.

The issue was that my fetch next was outside the loop.

So my initial diagnosis that I was cross eyed was true.

Will a rebuild also update stats with fullscan or will it do sampling?

Currently I'm thinking of changing the job to do a reorganise daily based on fragmentation and an indiscriminant...

SQL services lock files

Thanks Gail

We have a screen which displays all records relevant to a particulart screen.

We also only show records where the status = 1.

The DB has never been archived so I tried...

GilaMonster (3/8/2012)

---

No, nothing on catch-all queries in the simple-talk article. That's just about poor indexing. I always meant to write a follow-up about poor T-SQL. but could never decide what...