yep...use UPDATEUSAGE

This is easy...are they duplicates?

NO...just similar!

You may need to back up a bit and I would bet that you don't have a quick fix on your hands.  From my experience, most performance issues are not...

I am not 100% sure of what you are seeing.   Thought I would toss some ideas at you anyway...

Specifying ALL_INDEXES returns results for all the indexes in a table seperately. ...

Interesting topic.  We are on the same one here at work except we are throughing active/active clusters into the mix.

Even though noone is seeing problems it doesn't mean that one...

Allen...

You had me thinking on the way home last night.   There are 106 articles in the transactional push subscription.  Only 4 of these articles (tables) are of any size worth mentioning.

Do...

Allen...I went on vacation and came back to a subscription that is flagged for reinitialization.  This was over a week ago so am assuming that all of the tables need...

Thanks... I needed to run sp_addsubscription.  After doing that everything was fine 🙂

Don't hold me to this... But, my feeling is that the database security will change seemlessly although they may require a restart.  

Another way to get a high water mark would be to watch the perfmon object, user connections. 

Here's another tidbit that works very well when the Licensing Logging service (sp...

I'm sure you can find plenty with an internet search.  One of my favorite questions to ask is "Could you please explain an outer join?"  

I ask this one to...

I had tried those yesterday.  Including xp_msver and SERVERPROPERTY('edition').    This is quite frustrating as the person who installed this a couple of months ago is on vacation..if I could just...

Do the assistants get anything?

The error was somewhat misleading...better put, it was a chain of errors all masking each other.  There are some issues with SQL Server's transaction log rolling back text and ntext...

Thanks...

I have been through this process for hardware upgrades as well.  It was very simple to go through.  I am kind of hoping it will help the full text situation. ...