On the other hand, schemas can be very harmful if your DBA doesn't know what he/she is doing. I worked for a company where a previous DBA thought it'd...

Our main software is a third party solution with a legacy database that stores all it dates in a format similar to that: CYYMMDD, where C = Century = 1....

This is one of the reasons I don't take my work laptop home. I carry it around the office for internal meetings, but to work at home I remote...

Good questions, thanks Hugo. Seeing as only 8% got all four correct, I'd have liked to see each set of options as a separate QotD on four consecutive days.

Great question! This reminds me of rooting for our school team at Franciscan University[/url], one of the few US colleges where rugby is the #1 sport!

Thanks, that does help but also raises some additional questions:

1. If I'm putting this on a separate server than the ODS, I'm going to need to license 2 additional servers,...

I'll answer as best I can:

We are an online retailer, so I can think of probably 3 main cubes - POs, Orders, and Items. The largest cube (orders) could...

We ran into this earlier this year too, although we're currently on 2008 R2. The server was 5 years old so it was time for new hardware. It...

Xavon (9/2/2015)

---

Sean Lange (9/2/2015)

---

I am guessing that Aaron did NOT convince Steve to use = instead of as. 😉

I have to say that I disagree with Aaron on this. I...

Ha, I liked this one!

I guess I don't know what a mount point is well enough, but can't you get that information by looking at the file name and path in sys.master_files?

Before answering the question I read the documentation at https://msdn.microsoft.com/en-us/library/Gg492153.aspx and took the MAXDOP setting upon index creation to only affect the index creation. Steve's question seemed to ask...

Koen Verbeeck (8/13/2015)

---

OK, I didn't select the option with the in-memory table, because the sentence ends with only.

This made me believe the answer suggested that you could only create columnstore...

Awesome questions, thanks!

There is almost nothing running at that time. The event log says "The driver detected a controller error on \Device\RaidPort5". The source of that event is megasas2, event...