Good!

Next month I want to start using filetable.

I'm really curious.

😀

I couldn't test it, but I find this:

https://msdn.microsoft.com/en-us/library/gg492086%28v=sql.120%29.aspx

Ed Wagner (9/2/2015)

---

I'm thinking that your thinking is right. 😉

I wonder if this counts as...

"String literals as column aliases" are a deprecated feature!

Louis Hillebrand (9/2/2015)

---

3 or 9 depends how you define different...

column AS alias

column AS 'alias'

column AS [alias]

column alias

column 'alias'

column [alias]

alias = column

'alias' = column

[alias] = column

And I didn't use double quotes.

I...

The right answer

SELECT mynum AS test

FROM dbo.myTable AS mt;

SELECT test = mynum

FROM dbo.myTable AS mt;

SELECT 'test' = mynum

FROM dbo.myTable AS mt;

SELECT mynum test

FROM dbo.myTable AS...

That's a...

To get it for each db and files:

declare @sql nvarchar(max) = 'select 0 as dbid,0 as fileid WHERE 0=1'

SELECT @sql = @sql + '

UNION...

Very interesting!

Thanks!

😀

But in the real world, if Id is uniqueidentifier, how many splits of page will occur?

Boh!

BWFC (8/3/2015)

---

Not only do none of the answers appear to be correct but the the explanation does not match the options.

The correct answer is Query 2, with the MODIFY FILE...

I tested it. The qotd is right and also the answers are correct.

I learned something new.

I also tested placing a WITH(NOLOCK) on query 2 and 3, same results.

Query 1:

create table...

+1

Here, another dos command to list files, each column is separated by "*":

@for /R...

From BOL:

If you are running an edition of SQL Server that does...

I read about TEMPORAL TABLE just two weeks ago.

Good qotd!

🙂