You have multiple issues here in my opinion.

1) You have a table variable in your query. Table variables have no statistics, so the optimizer assumes there is exactly 1 row...

Unfortunately no. I would have loved to attend and meet you (at last!).

I'll be speaking at...

I agree with your Joe, but I'm under the impression that the OP cannot change the schema definition and is working on a very limited requirement.

While I find your...

Glad I could help

We need much more information to be able to answer.

Pleast post:

* table definitions as CREATE TABLE scripts

* some sample data as INSERT INTO scripts

* the desired output based on sample...

I've had the same issue in the past and I can tell for sure it has nothing to do with the encryption: it's a random bug in the restore GUI...

You can start from the MSDN page for clustered and nonclustered indexes: https://msdn.microsoft.com/en-us/library/ms190457.aspx

Google returns 97.000 results for "sql server difference between clustered and nonclustered index". Does any of those answer...

Another option is a bacpac file.

See http://blogs.msdn.com/b/brunoterkaly/archive/2013/09/26/how-to-export-an-on-premises-sql-server-database-to-windows-azure-storage.aspx

Be aware that some limitations apply.

In the export dialog you can select a single schema. The import process is straightforward.

See http://www.mssqltips.com/sqlservertip/2465/how-to-connect-to-sql-server-if-you-are-completely-locked-out/

and https://msdn.microsoft.com/en-us/library/dd207004.aspx

You are probably thinking of Oracle exports, which are not available in SQL Server.

The closest thing to an Oracle export is a collection of BCP files. BCP is an utility...

sysprocesses is an old compatibility view from the sql2000 days. Stop using it.

Use sys.dm_exec_sessions, sys.dm_exec_requests and sys.dm_exec_connections instead.

Don't re-invent the wheel. There's a great stored procedure by Adam Machanic called...

Koen Verbeeck (2/5/2015)

---

spaghettidba (2/5/2015)

---

GilaMonster (2/4/2015)

---

And about 5 more 'generating units' have gone offline. And it's still summer, I dread to think what winter's going to be like, current forecasts are...

GilaMonster (2/4/2015)

---

And about 5 more 'generating units' have gone offline. And it's still summer, I dread to think what winter's going to be like, current forecasts are we're getting the...

You can use the SSMSBoost addin to export the grid results to Excel, keeping data types and formatting intact.

Is it an automated process or a one-off requirement? In the latter case, you can use the SSMSBoost[/url] add-in to export the query results to Excel.