Good question but correct answer is None of the above.  Answer should be:

WITH ctePC

AS ( SELECT expression

FROM

( VALUES

('\1\cpu')

, ('\1\ram')

, ('\1\ssd')

, ('\1\gpu')

, ('\1\cooler')

, ('\1\fan')) a (expression) )

select replace(expression, '\1\', '') from...

The way that I read the MS documentation the 2 TB limit only applies if you specify the MAXSIZE parameter.  If you don't specify it, then the size is only...

Steve, thanks for the question. As is, you get a syntax error because of the schema in the Create Index statement.  If you remove the schema,then it works fine.

As is:

CREATE...

The correct answer should actually be 10. You can have up to 9 archived error logs plus the current error log.

The correct answer is 1, 2, 3 because the statement provided is invalid, so the table should not change.

I knew it would be somewhere. Thanks!!

The heading says default log directory, but the question says default data directory.  Which one is it?

Actually no rows are returned.  I guessed the first answer correctly.  The WHERE clause needs to be changed.

I have driven from Cincinnati to Indianapolis, Columbus and Louisville for SQL Saturdays several times over the past several years. About 100 miles to each city. The events...

Overall, this is a good article. One thing that I would like to see added is to set the recovery model to simple:

ALTER DATABASE [ComicBooks] SET RECOVERY SIMPLE

GO

The...

The flip side of a question from last week.

I got it wrong. Missed the part about shared storage.

SQLRNNR (4/1/2015)

---

William Vach (4/1/2015)

---

Interesting that as of 11:00 AM Eastern, only 16% picked the first answer. I thought that if you have absolutely no idea of the answer to...

Interesting that as of 11:00 AM Eastern, only 16% picked the first answer. I thought that if you have absolutely no idea of the answer to a multiple choice...