I wasn't build one file group for each index... it was for one table and it's related indexes but only if those indexes require index maintenance.

You say you have hundreds...

The...

I have a working query within MySQL based on (Managing Hierarchical Data in MySQL - http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/). The problem I have is that I need to implement the same functionality on another...

I whole-heartedly agree Michael.  Collecting data and knowing what to do with it are two very different things.

I'll also state that while extended events can be useful, it's a total...

I know this post is half a decade old but, since it was necro'd and bubbled to the surface, I have to ask......

For performance reasons, I wouldn't use a "straight" SELECT from a linked server.  Instead, I normally use OPENQUERY as the source for an INSERT INTO.

 INSERT INTO...

This should work, I think:

UPDATE t
SET t.CarStatus = '2'
FROM #Test t
INNER JOIN (
    SELECT CarID, MIN(Id) AS Id
    FROM #Test
...

We are setting up Idera SQL DM system to monitor our SQL Server's. So we have availability group setup for the repositories at database level. Looking for option to...

As a bit of a side bar, I just took a look at that.  It's quite extensive but, lordy... try scanning all of the...

That's not actually true but, even if it was, the logical selection...

I was careful to preserve as much of the original code as possible and to document this as well as the original code was. 😉

UPDATE Codes
 ...

The one below,...

It's probably because the triggers that feed it are written incorrectly as some form of dynamic SQL that materialize...

Here's one simple way.  It'll really help things if you have an index on the TimeInterval column.

DECLARE @InputParameter [decimal](15, 6) = 691195
;
 SELECT TOP 1 *
 ...

You should play the lottery tonight. 😀  You just proved that you're one of the luckiest people on the whole planet. 😀

With that (and I know you get it but...