Question of the Day (QOD)
-
We're about to change the newsletter format to have much more inline content and include a daily question of the day. We'll keep track of the statistics so there will be a running total of what questions you got right and in what categories (ie Security, clustering, development). Look for this to begin next week in the newsletter. If you don't subscribe to the newsletter yet, check your profile by going under My Account in the above menu. Please let us know what you think of it. We think it'll be an interesting way to learn about SQL Server through a fun contest of pride.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars -
<Preparing for bruised ego> Sounds like fun, indeed!
-
I've scored my first two points today
Can I reach QOD somewhere from the main menu?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Actually you can change from UDP 1434 - although you can't define what alternative port to use.
If you click the "Hide Server" box in Server Network Utility (SQL2K) the listener port is changed to 2433 although I don't think this works on multi-instance boxes.
One note of caution - if you're playing around with this and "un-hide" the server the port remains on 2433.
Interseting to see how the ego holds up to the QOD.
. . Greg
Greg M Lucas
"Your mind is like a parachute, it has to be open to work" - Frank Zappa -
quote:
Can I reach QOD somewhere from the main menu?Should have that today! It will able to be reached under the Testing Center this afternoon.
-
quote:
Should have that today! It will able to be reached under the Testing Center this afternoon.Thanks!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
As promised, here's the direct link:
http://www.sqlservercentral.com/testcenter/QOD.asp
Also under the Test Center icon
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars -
WAH!
I selected the correct answer in the email, clicked the link, got the web page, clicked "Answer" again... and only then noticed that it had "reset" the question, automatically setting it to the first (and wrong) answer. I lost two points! I want my money back! (Oh, wait, it's free. Never mind.)
Suggestion A <impractical> -- configure the web page Answer set to that selected in the email link.
Suggestion B -- configure the answer set to have nothing selected on initial presentation.
Philip Kelley
-
Hi Phillip, sorry for the troubles. I ensure you that this is working for 90% of the people but the 10% is resetting due to the wrong variable being passed to the web page. Not sure what the deal is offhand but would you mind passing me an email or responding here with what type of email client you use?
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars -
If bulk-logged is the largest, can you please explain the following.
When I had full set on my user databases the log backups were so big that I was running out of disk space on a brand new server. When I changed them to bulk-logged they dropped to a manageable size. I can now keep 4 full days where before I couldn't even get two on there.
K
-
I have the same question as Kelseyv. I went to Books Online to check the answer and this is what I found:
When FULL is specified, database backups and transaction log backups are used to provide full recoverability from media failure. All operations, including bulk operations such as SELECT INTO, CREATE INDEX, and bulk loading data, are fully logged. For more information, see Full Recovery.
When BULK_LOGGED is specified, logging for all SELECT INTO, CREATE INDEX, and bulk loading data operations is minimal and therefore requires less log space. In exchange for better performance and less log space usage, the risk of exposure to loss is greater than with full recovery. For more information, see Bulk-Logged Recovery.
If Bulk Recovery is the largest, then why does it say 'less log space usage' in the description for Bulk Recovery?
-
Please ignore above post. I just re-read the QOD and saw that I missed the reference to the Backup instead of the file size of the log.
-
OK, you got me on the bulk-logged QOD. B)
But, it is a great question. I run all systems using full, and I suspect that like most DBA's, have never had to consider using bulk logged.
What's the business problem you're trying to solve? -
Hi Brian,
quote:
As promised, here's the direct link:http://www.sqlservercentral.com/testcenter/QOD.asp
please help a blind to see.
Can I see the overall results of QOD?
Can I see with how many points my account has been credited?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
quote:
please help a blind to see.Can I see the overall results of QOD?
Can I see with how many points my account has been credited?
You're not missing it, I haven't finished development of it. Should be ready today or more likely tomorrow though! Was trying to get a good set of scores before developing it.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply