https://connect.microsoft.com/SQLServer

John Mitchell-245523 (9/13/2016)

---

Koen, I'm not sure we've enough evidence yet to prove this is a bug. It could just be that a different execution plan was compiled after the...

xsevensinzx (9/12/2016)

---

RonKyle (9/12/2016)

---

Regarding the dates, it's not uncommon for developers to advocate using an integer with the date in human friendly format, e.g. 20160912 for September 12, 2016. I...

To execute them 100% in parallel, you could create an SSIS package with 5 execute SQL Tasks, where each task kicks off a job.

This is a common problem. You need a composite key for the MonthName. Add the year as well, so that you get April 2016 instead of just April.

The reason for...

Would you mind posting the solution so that people with a similar problem might benefit?

Regarding the vertical labels, is this what you're looking for:

http://stackoverflow.com/questions/17423462/displaying-labes-vertically-above-bar-in-bar-graph

The type of fact table that you want is called an "accumulating snapshot".

It contains one row for each lifecycle (e.g. a customer that creates a specific order in your case)....

Martin Schoombee (9/12/2016)

---

I believe the restore GUI also has an option asking if you'd like to restore roles/permissions, so you can choose not to restore those when performing the restore...

Did you log a connect item for this?

Interesting question, thanks. Also nice to learn something about the other query hints.

Thanks for the question. I believe there's a parameter for the stored procedure where you can set it to run synchronously.

Nice question, thanks.

Easy one, thanks.

Yes, but be aware that the Move method cannot do an...