I understand that finding the root cause is important, but if you business depends on this, recreate your replication (If possible ofc).

Hi Lowell,

Thanks for taking the time to read and reply.

That approach won't work for us as the server is set to UTC and we need to be able to handle...

I started getting this error again so I added in a workaround with a synonym.

So far so good....

Repro code change:

IF OBJECT_ID('syn_CompColTbl', 'SN') IS NOT NULL

DROP SYNONYM syn_CompColTbl

-- Workaround for self...

Thanks for your input Chris.

You are right in what the function does.

I am migrating a SSIS package to a new acceptance environment. The package works fine live, but not in...

Annoyingly enough, this resolved itself after a couple of hours. :alien:

I went back to it to try adding synonyms into the mix, but it was no longer needed.

Problem's there again. Googling brought me back to my own post

Last time the SQL service was restarted to reduce the size. That happened during a major version update. No updates...

There's already a dmv for procedure stats.

sys.dm_exec_procedure_stats

SELECTDBName= DB_NAME(database_id)

, SPName= OBJECT_NAME([object_id], database_id)

, ExecCnt= execution_count

, TotalTime= total_worker_time

, TotalReads= total_physical_reads

--.... Heaps of columns

FROMsys.dm_exec_procedure_stats

WHEREdatabase_id < 32767

ORDERBY execution_count DESC

I found out the hard way, myself. Why is it the MOCs never mention it.....?

Great script! Thanks.

You can use the techniques shown here[/url] to account for the differences in SQL versions DMVs.

Thanks for sharing Randy!!

You can avoid all those cursors and simplify your code like this:

print 'I. Name of Members in Serveradmin role.:'

DECLARE @PrintResults NVarchar(4000) = ''

SELECT@PrintResults = @PrintResults + '...

Nice work Joshua!

I really like the ability to index!

@alan, I've been using the PhilFactors fabulous funky function as well.

I get the feeling I'll be using JSON Select...

The script demonstrates how metrics can be collected. It is not necessarily about the data being collected, but how to collect it. Other will probably want to collect other data....

What happened to my description?? Ugly post 🙁

Glad you like it!

Excellent article!

Great detective work and very well written!

Hope you keep them coming 🙂