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

What is the difference between Shared Storage and SMB File Share? The link on that msdn page goes to https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx#storagetypes, but it doesn't really describe them, it just names...

I agree with TomThomson - This msdn page says "The bcp utility is written by using the ODBC bulk-copy".

I'd say that means it does indeed use an ODBC connection to...

Thanks to all our service men and women who have given so much so we can live the way we do.

Anyone looking for a good book related to Memorial Day...

We run a daily trace that captures SQL running longer that X seconds. This gives us a good idea of what SQL can be tuned to provide the biggest...

Whew, I'm not the only one.

Great question, thanks for sharing!

I loved Clancy's first nine books, but Red Storm Rising was my favorite. After the first nine they all seemed to be about the same thing with slightly different...