Ed Wagner (1/14/2016)

---

Phil Parkin (1/14/2016)

---

Grumpy DBA (1/14/2016)

---

Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 - oddly the same age as...

Grumpy DBA (1/14/2016)

---

Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 - oddly the same age as David Bowie. This...

You're stuck.

Trace is probably the best answer, at least in 2008. If you moved to 2012 or greater I'd also suggest looking at moving to Extended Events. It doesn't make...

mvinokur (1/13/2016)

---

Hello,

I hope someone has help me with this. I am also getting a warning column with no statistics.

This is on a column that is a primary key.

Auto Create...

Except for upgrading (and I wouldn't suggest going to 2012, 2014 has been out for two years and is very stable), and what has been suggested, the only other solutions...

Always start with the Microsoft documentation when you have fundamental questions about what something is or how it works. For example, here's the information on indexed views. Then you can...

I know what it does. I just don't understand why it's included.

What's the query hint doing?

The reason there are tools around this task is because there really isn't any simple, quick & easy way to get it done. Especially not one that supports all the...

And Visual Studio, both versions mentioned, has been quite stable.

Hugo Kornelis (1/11/2016)

---

In most cases, the better idea is to stop halfway through...

Martin Sherwood-301653 (1/11/2016)

---

Apologies about the loaded questions and appreciate you taking on the challenge Grant.

With the advent of (MPP) capability within Azure SQL DWH was curious to field the...

ypeng5 (1/11/2016)

---

Thanks for your wonderful suggestions, I will do that! One more question, I have done some researches about table rebuild, but I found nothing useful. Does SQL Server has...

I'm having trust issues with Lenovo. Both because of the horror show of the W530 and the security issues they've been having recently.

Still, that's a nice looking piece of...

That's actually a pretty dense set of questions. Any advice I'm offering up here should be taken with a very large grain of salt.

1) Heck no. Take Azure and everything...