June 27, 2014 at 10:24 am
Tried to mix it up on this one! Appreciate all the comments. Think I have a couple more in the pipeline, then I'll work on a new batch and try to avoid all the pitfalls I've learned about so far.
June 27, 2014 at 10:40 am
Ugh, missed it because that number isn't the max "size" of log files, it's the max number of pages.
June 27, 2014 at 10:55 am
Thanks, Andy!
June 27, 2014 at 3:53 pm
Thanks, Andy. Like Jason said, it was straightforward and useful. Thanks.
June 28, 2014 at 3:38 am
pmadhavapeddi22 (6/27/2014)
I generally use the below sql for logical name,physical name and path for any db, so this number seemed very familiar, after seeing the question, I have immediately tried the below sql and got the number :-), did not check the other options as the answer is radio buttonselect * from sys.sysfiles
Thanx 4 sharing 🙂
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
June 28, 2014 at 1:00 pm
Nice question.
That, Andy, is I think the least complicated QotD from you yet :-). Asd it's certainly one that no-one could sensibly complain about.
Tom
June 30, 2014 at 12:21 am
Nice one
Thanks
June 30, 2014 at 2:03 am
I thought it is a phone number of customer help...
June 30, 2014 at 2:06 am
Bangla (6/30/2014)
I thought it is a phone number of customer help...
:hehe:
June 30, 2014 at 2:19 am
Bangla (6/30/2014)
I thought it is a phone number of customer help...
This is interesting and funny, though it is not in the answer options 😉
Andy could have used it as one of the options 🙂
June 30, 2014 at 2:51 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 8, 2014 at 2:17 am
Good to know, thanks for the question
Viewing 12 posts - 16 through 26 (of 26 total)
You must be logged in to reply to this topic. Login to reply