Please post the actual execution plans (not estimated) as .sqlplan files for each scenario.  If you're inserting 2000 rows into @p3 and then passing that as the argument for @BusinessObjectDataGuids then that's...

No, that won't work.  You could set up an alias, but I think you'd have to do that on every client computer.

John

Damien

Are you supplying the instance name as well - VIRTUALSERVERNAME\INSTANCENAME?

John

If you want to put results from dynamic SQL into variables, you need to use sp_executesql instead of EXEC.  Or you can take the variables out of the dynamic SQL...

Yes, my mistake.  You were getting a concatenated list of every value in the table rather than every value in a particular string!  Try this:

SELECT
 ...

Or, somewhat more scalably:
SELECT
     c.ID
,    c.LIST
,    r.Reconcat
FROM #CSV c
CROSS APPLY (
    SELECT ',' + s.value
    FROM #CSV c
    CROSS APPLY STRING_SPLIT(c.LIST,',') s
    ORDER...

So what is your problem here - the syntax error, the conversion error, or the performance?  Do you have any control over the code in that view?  If so, start...

I assume that before you detached the database, the tops3_3a.ndf file was on the F drive?  I can't think why your CREATE DATABASE statement isn't looking for it where you tell...

You mean you want to create the same index on the current table as on the new one?  You'll need to query sys.indexes to generate the CREATE INDEX DDL.

Well, yes.  A unique index is (almost) the same as a primary key.  Take the UNIQUE out of the statement and everything will be good.  You only need the index...

Create a clustered index on table2 on the same columns that will form the clustering key on the main table.  You'll then need to write a query that will not...

Perhaps it's a default language thing.  Suppose you have a line in your query WHERE DateCreated > '01-12-2017', this could be interpreted differently depending on whether a user's...