Whoops mis read you post

SELECT o.NAME, ps.execution_count FROM sys.dm_exec_procedure_stats ps

INNER JOIN sys.objects o ON ps.object_id = o.object_id

WHERE o.name = 'sprocname'

Last question

7. If the setup becomes synchronous and it still fires from the trigger does it have to complete the full cycle ie converstaion needs to completely finish before the...

5.How to write asynchronous SSSB so it doesn’t affect tempdb.

6 How to change to Synchronous SSSB, without performance issues.

Base table captures NTuser name (domain name). Never captures sa. 'sa is a red herring from the previous post.

Ok if the base table captures the user who made the changes and the time, is CDC a suitable vehicle to be used for auditing.

Thanks. Not using sa from the APP. Only when I update via SSMS it captures as sa.

Thanks, thats a new one for me. Is there anywhere which has a list of all these things in T-SQl that can cause scans.

Great article with a solution.

Dymanic SQL thats not open to vunerability.

OVER AND OUT. THAT EXPLAINS IT FULLY.

THANKS

In my db there are many sprocs which can be filtered by the parameter. Which is not good new for me.

There will be 1 parameter for each column. so the...

I would do everything Stuart has said. But in addition you need to find out how much data loss is acceptable for the db (IN WRITING). I wouldn't change any...

Google is your friend!! Google is a friend of evrey DBA.

http://www.mssqltips.com/sqlservertip/2573/monitor-sql-server-alwayson-availability-groups/

The whole db is one massive problem, no it's not but it annoys me and I'm trying to make improvements where I see fit.

Once I tighten up the top 30...

Thanks,

On a slightly different note. My DB suffers from serious Lookups. The only way I know to improve this is to see if I can consolidate the included columns...