You really can't. A clustered index, columnstore or rowstore, defines data storage. You can't really redefine data storage without completely rebuilding the table. So, build a new clustered columnstore table...

Oh come on.

Thanks though.

Nah, don't apologize. This forum is here to expand knowledge, so please, use it.

I haven't tried troubleshooting the DTA too much, so I'm not sure what you can do there....

First, don't use the tuning advisor. It's actually more than a little bit dangerous in its recommendations.

Second, are you providing an XML input document? Is it that it's too large...

Hard to know what to say here without detail.

Instead of cursors, use set-based queries.

There you go.

You can't restore to another server & try to test it there? I'd argue it's important to get something like this right because messing it up could be painful.

Testing is your friend. Try Phil's suggestion. It's likely going to be faster just based on the simple idea of data movement. Moving 100 million rows through the copy may,...

Do you mean just a simple backup and restore, not data changes at all, no inserts, deletes, nothing like that, and suddenly SOME values are different after the restore?

Nope.

That doesn't...

You are getting a scan of TAllData (please tell you don't have a naming standard where you name all tables T*). It doesn't have filter criteria, but it does have...

Read the full error message. It says something about incorrect number of parameters. Without seeing your code or the message or anything else, I can't tell you what's going on,...

8gb is probably low. Jonathan Kehayias is someone I really trust on this. Follow his advice.

Yep. AdventureWorks in all it's messed up glory. Honestly, I love that sample database. Why? Because it looks like all the other messed up constructs I see everywhere else. It's...

Actually it sounds like you could put a tally table, or a table of numbers to work and simply pass in your 1-10 tanks (which really does sound like a...

Also, don't set the max of SQL Server to max of the system. You have to leave room for the operating system to have memory as well. While you can...

Without a WHERE clause, no filtering occurs, so it goes to the cluster to pull stuff together. If you want to eliminate the sort, you can create an index on...