Interesting. Glad you fixed it. Sorry I didn't have anything better to offer.

One generic index should be best. If you had created multiple indexes, all with the same key values, you might not see them used even in the queries that suggested...

Just did a series of searches on both Bing and Google. There is no recorded instance that I can find of this part of the message:

"10.00.5500. That version is incompatible...

That should work. I've never heard about or run into issues restoring an R2 database from a 2008 backup. Just did some searching online. Everything I'm finding suggests it's pretty...

You do realize that indexes are absolutely wonderful things and extremely helpful in lots of situations? Lots of heap tables on a database sounds like a very questionable design. I'd...

Matt Miller (#4) (10/29/2014)

---

Grant Fritchey (10/28/2014)

---

The best way is to have a full script that does the restore and cleans up the database to remove or modify the data that...

cdesmarais 49673 (10/29/2014)

---

Grant Fritchey (10/28/2014)

---

cdesmarais 49673 (10/27/2014)

---

It's not magic. It's also not a free lunch. There are tradeoffs even beyond the extra up front work of TDD and...

The read out to get the extra data is going to happen one way or another. Even if you have a lookup back to the cluster, you'll have to read...

Everyone else has largely nailed it. For the most part, adding a row to a table costs the same if it's an empty table or one that has one million...

Which means that it does impact the non-clustered index. Is that necessarily bad? No, but it's something to take into account when choosing whether or not to include, or even...

er.mayankshukla (10/29/2014)

---

The older technology, the nonclustered columnstore, was designed to work on heaps and standard clustered indexes in combination with existing indexes. But, functionally, it's similar to the standard...

Not sure what you mean by perf logs. Since you're on SQL Server 2012, I'd be using the extended events to capture query executions in order to understand which queries...

er.mayankshukla (10/28/2014)

---

Hello Experts,

The columnstore clustered index doesn't allows any other index to be built on that table and that makes sense as we are storing the complete table in columnar...

It doesn't sound like it's 2014. It sounds like your linked servers and your DTC are not set up correctly. It's also possible it's a security issue. I'd suggest double...

There are a few options. If you have access to MSDN at work, get a developer copy through that. Or, if you have MSDN at work, hook up your Azure...