Security by obscurity does not work.

What exactly do you mean by 'adding...

That's not all that helpful, expecially since Management throws an error on that XML. Could you maybe just attach the saved plan rather than making someone else fix the XML,...

No.

Last year,...

The latest

Don't script the data unless your database is under a couple hundred MB.

Script the schema, use bcp to export the data to flat files.

Actual execution plan please?

In the mean time, first thing to try is to replace all those table variables with temp tables. So:

CREATE TABLE #TCut([Val] [nvarchar](MAX) NULL)

CREATE TABLE #TColor([Val] [nvarchar](MAX) NULL)

CREATE...

How big is the index? How many pages (or how many kb)?

Same answer as I gave you before.

In this case, both tables were scanned once. The merge join is efficient when the two resultsets are in the order of the join...

If you just run the installer, you'll only be allowed to install a new instance (different name). If you want to replace an installation, uninstall then reinstall.

That's just a whole bunch of SET statements. It's not doing anything other than assigning values to session-scoped settings. There's no query there.

You've probably got no useful indexes for that query, so in the absence of indexes to support the WHERE and JOIN, SQL has to scan the table. The optimiser would...

The clustered index has the non-leaf levels that are additional to the data. They're small in comparison.

The clustered index does not enforce the physical order of pages within the data...

Or install a new instance on...

SQL Server doesn't have incremental backups.

It has full database backups, differential database backups and log backups. Which are you asking about?