Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 28,516 through 28,530 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Ninja's_RGR'us (7/28/2011)
Now this is funny if this is what I think it is!
http://www.sqlservercentral.com/Forums/Topic1149828-391-1.aspx

The 'backup the tail of the log' option has no place in maint plans. Shouldn't be there, absolutely no reason to ever select it and a nasty trap for wannabe DBAs who check options without reading up on what they do.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Paul White SSC Guru Points: 150467 More actions · Answer 2

GilaMonster (7/28/2011)
The 'backup the tail of the log' option has no place in maint plans. Shouldn't be there, absolutely no reason to ever select it and a nasty trap for wannabe DBAs who check options without reading up on what they do.

IIRC it has been removed in Denali CTP 3.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

SQLkiwi (7/28/2011)
GilaMonster (7/28/2011)
The 'backup the tail of the log' option has no place in maint plans. Shouldn't be there, absolutely no reason to ever select it and a nasty trap for wannabe DBAs who check options without reading up on what they do.
IIRC it has been removed in Denali CTP 3.

I remember that discussion. Bout time too, should never have been there in the first place. The log backup dialogue box, yes, the log backup maint plan task, no way.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 4

GilaMonster (7/28/2011)
Ninja's_RGR'us (7/28/2011)
Now this is funny if this is what I think it is!
http://www.sqlservercentral.com/Forums/Topic1149828-391-1.aspx
The 'backup the tail of the log' option has no place in maint plans. Shouldn't be there, absolutely no reason to ever select it and a nasty trap for wannabe DBAs who check options without reading up on what they do.

I've never selected it because I never understood it. I never tried to find out what it does because backups seemed to do everything I needed without it. There's so much else to learn, it kept getting pushed off. Glad to know it isn't something I should have prioritized.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 5

Jeff Moden (7/27/2011)
Steve Jones - SSC Editor (7/27/2011)
I don't control the announcement. I assume it will be a business day or two afterward.
From the website... kind of a buried link...
Important dates
1.Deadline for nominations: Thursday, June 30th 2011 at 17:00 hours (GMT).
2.Finalists announced to SQL Server Central community for voting: Monday, July 18th 2011.
3.Deadline for votes for winner: Friday, August 12th 2011 at 14:00 hours (GMT).
4.Winner announced: week commencing Monday, September 12th 2011.
5.Awards ceremony: at the PASS Community Summit, November 2011, Seattle, USA.
Obviously, that last one is incorrect.

Thanks.

The award will be at PASS, just not sure where/how. PASS doesn't want the SSC party used for this, so that's one of the sticking points. Searching for other venues/options now.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Stefan Krzywicki (7/28/2011)I've never selected it because I never understood it. I never tried to find out what it does because backups seemed to do everything I needed without it. There's so much else to learn, it kept getting pushed off. Glad to know it isn't something I should have prioritized.

Essentially BACKUP LOG ... WITH NORECOVERY

Backs the log up and switches the database into the restoring state. It's used for the last log backup of a DB in full/bulk-logged recovery before starting a restore (over the existing database) to ensure that no transactions are lost.

It's one of the forms of the tail-log backup (the other being BACKUP LOG ... WITH NO_TRUNCATE for a damaged database).

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 7

GilaMonster (7/28/2011)
Stefan Krzywicki (7/28/2011)I've never selected it because I never understood it. I never tried to find out what it does because backups seemed to do everything I needed without it. There's so much else to learn, it kept getting pushed off. Glad to know it isn't something I should have prioritized.
Essentially BACKUP LOG ... WITH NORECOVERY
Backs the log up and switches the database into the restoring state. It's used for the last log backup of a DB in full/bulk-logged recovery before starting a restore (over the existing database) to ensure that no transactions are lost.
It's one of the forms of the tail-log backup (the other being BACKUP LOG ... WITH NO_TRUNCATE for a damaged database).

Ah, so it is something primarily used for immediate database recovery. I can see where that would be useful and also why you'd never want it as a regular part of a maintenance plan. Thanks!

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 8

Steve Jones - SSC Editor (7/28/2011)
Jeff Moden (7/27/2011)
Steve Jones - SSC Editor (7/27/2011)
I don't control the announcement. I assume it will be a business day or two afterward.
From the website... kind of a buried link...
Important dates
1.Deadline for nominations: Thursday, June 30th 2011 at 17:00 hours (GMT).
2.Finalists announced to SQL Server Central community for voting: Monday, July 18th 2011.
3.Deadline for votes for winner: Friday, August 12th 2011 at 14:00 hours (GMT).
4.Winner announced: week commencing Monday, September 12th 2011.
5.Awards ceremony: at the PASS Community Summit, November 2011, Seattle, USA.
Obviously, that last one is incorrect.
Thanks.
The award will be at PASS, just not sure where/how. PASS doesn't want the SSC party used for this, so that's one of the sticking points. Searching for other venues/options now.

Apologies. I knew it would be awarded at PASS... just not in November of this year. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 9

Well Jeff, I voted for you at the Exceptional DBA awards.

Not only because you are the only one I know from that list, but also because of your amazing work here at SSC.

Good luck!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 10

Ugh. Another copyright violation.

http://www.sqlservercentral.com/Forums/Topic1150675-391-1.aspx?Update=1

Original article:

http://www.databasejournal.com/features/mssql/sql-server-index-t-sql-statements.html

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 11

Gosh... has anyone ever heard of a good reason to have two identically named SQL Server instances in the same Domain? My gut says there isn't one and except (possibly) for the very brief period of bringing a new system online, it should never be done. Could someone that knows for sure (I just don't know and would actually like to know the answer for the future) respond to the following thread with either a "yay" or "nay" reason? The link takes you to my very sincere but totally unqualified response...

http://www.sqlservercentral.com/Forums/FindPost1150874.aspx

Thanks folks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 12

Koen Verbeeck (7/28/2011)
Well Jeff, I voted for you at the Exceptional DBA awards.
Not only because you are the only one I know from that list, but also because of your amazing work here at SSC.
Good luck!

Very kind words, Koen. Thank you for that and the vote. I really appreciate it.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 13

Jeff Moden (7/29/2011)
Gosh... has anyone ever heard of a good reason to have two identically named SQL Server instances in the same Domain? My gut says there isn't one and except (possibly) for the very brief period of bringing a new system online, it should never be done. Could someone that knows for sure (I just don't know and would actually like to know the answer for the future) respond to the following thread with either a "yay" or "nay" reason? The link takes you to my very sincere but totally unqualified response...
http://www.sqlservercentral.com/Forums/FindPost1150874.aspx
Thanks folks.

Done.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

Koen Verbeeck (7/29/2011)
Ugh. Another copyright violation.
http://www.sqlservercentral.com/Forums/Topic1150675-391-1.aspx?Update=1
Original article:
http://www.databasejournal.com/features/mssql/sql-server-index-t-sql-statements.html

Thanks, I was going to spend the afternoon tearing it apart. Lots of bad info in there.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 15

SAN experts (or experts with SAN Monitoring experience) needed at this thread with monitoring tool recommendations, please:

http://www.sqlservercentral.com/Forums/Topic1149982-391-1.aspx?Update=1

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.