paul 25096 (11/4/2015)

---

I think the reason "Options 1, 2 and 3" has more votes than "Option 2" is because of course you should also avoid statements that cause a syntax...

Excellent!

I get it wrong because I forgot this from BOL:

READUNCOMMITTED and NOLOCK hints apply only to data locks. All queries, including those with READUNCOMMITTED and NOLOCK hints, acquire Sch-S (schema...

Easy questions.

Thanks!

😀

But, what happen?

Interesting question!

Thanks.

Toreador!

Default collation is case insensitive.

😀

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 ALL SELECT '''+RIGHT(database_id,10)+''',fileid FROM '+name+'.sys.sysfiles'

FROM...

Very interesting!

Thanks!

😀

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