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...

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 shouldn't be accessible, all as...

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 automation. CI is...

Evil Kraig F (10/27/2014)

---

CI works in the app development world because of a particular idea: non-persistance of the layer. I'm not discussing the concept of CI, but the reality...

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

---

Iwas Bornready (10/27/2014)

---

My experience has been that projects are late because of unrealistic deadlines up front. To take a slower approach would only make them later. To...

Iwas Bornready (10/27/2014)

---

My experience has been that projects are late because of unrealistic deadlines up front. To take a slower approach would only make them later. To be realistic about...

Meow Now (10/27/2014)

---

Developers love to push CI since it's simple and makes sense with application code. It's a whole new beast when you're trying to automate deployment of a terabyte...