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?

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!

🙂

Easy, thanks!

😀

Correct answer:

When J is between -999,999,999 and -100,000,000 or between 1,000,000,000 and 2,147,483,647

Correct explanation:

...

If the expression is between -999,999,999 and -1(,0)00,000,000 or between 1,000,000,000 and 2,147,483,647 it's decial representation...

I'm surprised, how an "answers bad worded" qotd gets more than 60% of right answers.

:crazy:

-- Using credentials on database requires enabling traceflag

DBCC TRACEON(4631,-1)

Instead of

-- Using credentials on database requires enabling traceflag

DBCC TRACEOFF(4631,-1)

deroby (6/18/2015)

---

I'm going to chime in on the 'Yay for sp_helptext' team.

The stored procedure might be old (and indeed in need for some TLC, thumbs up for the...

I fixed this bug in the sp_helptext in 2002 in SQL2000 in the same way. I changed the length from 255 to 4000, but the problem is not solved completely....

I thought that this statement was missing:

alter INDEX SalesArchive_CI_SalesPersonID ON dbo.SalesArchive disable

... and got it right!

😀