Heh... Being one that doesn't have such a understanding...

DBATools.io has a nice function called Find-DbaDbDuplicateIndex (however it has IMHO aflaw and does not report IsUnique for an index, reporting duplicate indexes composed of the same column(s)...

I'm curious... what does the PowerShell script actually do?

Hello,

I found couple of indexes which looks like duplicate indexes.  Before dropping any duplicate indexes...is there any additional checks that should be done. please advise.

Index A on Table A...

While I agree that IIF is "foreign" to SQL, it is VERY short for 2 part CASE statements.  As you know, it does resolve to a CASE statement behind the...

--...
      ALTER DATABASE [DBNameToRestoreHere] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
          ALTER DATABASE...

I hate Excel...If your cutting and pasting into excel from SSMS, you could be losing leading zeros. Usually the only time I do this is exchanging results among my...

Bad criteria.  Empty source table.  Some error that allowed the creation of the table but no data to transfer.  There are a ton of reasons but can't tell because not...

@jihene,

I don't use availability groups but I can tell you that you're using what people recommend as supposed Microsoft "recommended" "Best Practices" for index maintenance.  In fact, most of the...

Instead of worrying about where the bloody semi-colon goes, someone needs to convince this fellow that this absolutely needs to be converted to a single value iTVF or "iSF" and...

**** NOTICE!!!!  Please see Scott's warning at https://www.sqlservercentral.com/forums/topic/restore-autmomation#post-3979292 on this subject below and my post right after his.  I only use this method on "test" boxes and didn't stress...

It doesn't matter if it's ZOOM or not... meeting usually flat out just suck because the person who is supposed to be running the meeting is one of the worst...

What does that...

Of course, an even better way would be to buy an up-to-date zip code database and do a lookup because not every number from 00000 to 99998 is a valid...

Another possibility is a bit shorter, uses only LIKE instead of LIKE and the LEN() function, and does the same thing is...

IIF(D.Zip LIKE '[0-9][0-9][0-9][0-9][0-9]', d.Zip, '99999') AS...