So just to clarify. if i have a clustered index on say contactid and invoiceid however none of the updates are on those columns then there wouldn't be a...

Are you on the latest CU?  If you are behind any maintenance patch, I'd put that on first before doing other work.

SELECT SUBSTRING(TableName, CHARINDEX('dbo.', TableName), 8000) AS TableName

FROM dbo.whatever

WHERE TableName LIKE '%dbo.%'

WARNING: make sure that no more than, say, 3500 tables or so are processed by this script.  The script is fairly complex and having way too many tables present  (particularly...

If you just want table names that start with 'dbo.', then you can do this:

SELECT STUFF(Tablename, 1, 4, '') AS Tablename
FROM dbo.ListOfTables
WHERE Tablename LIKE 'dbo.%' /*allows an...

You can't ever look at missing index stats in isolation.  You also need to look at existing indexes and their usage stats (and often I/O counts as well).

First, before doing...

Thanks for the answer,

We already have views on top of our tables, so it would be easy to do. But that would serve no purpose. The main goal would...

Going from 28 to 19 would reduce the storage required, so, as you've discovered, I think SQL would create a new column and copy the data over to it.

If you...

SELECT ca1.*
FROM dbo.Table1 t1
CROSS APPLY (
    SELECT EmpNo, EmpName, DeptName, Location
    UNION ALL
    SELECT EmpNo, EmpName, DeptName, Location
...

CONCAT is not a safe way to do this because different values could appear to be the same.

Do all the columns have to match?  Or just some?

For now, I'll assume...

There could be a lot of different reasons for latency.  Did this just start recently?  Here are some possible things; (1) should be done first, the others are in no...

We need to see the DDL for Clicks2 and Clicks3 as well.  Particularly if those tables are not clustered uniquely on ClickID, the MERGE join could be less efficient.

As Jeffrey...

For efficiency, you should really just scan the table once to count all columns, as the code generated below does.  I've added the view name as input so the code...

Of course it must vs taking locks.

"and use snapshot isolation."  MEGA-HUGE overhead.  SI should...

Of course it must vs taking locks.

"and use snapshot isolation."  MEGA-HUGE overhead.  SI should only be...