Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 19,936 through 19,950 (of 66,749 total)

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

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 1

In regards to another post / thread:

Here's the latest SQL Server version list, including 2k8 R2.

And for those who don't like clicky links: http://www.sqlteam.com/article/sql-server-versions

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.

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

Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx

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: 173083 More actions · Answer 3

GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx

No. I find it professional and well-reasoned. It is the correct and necessary response to the question.

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.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 4

GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx

No, not at all. You're telling it like it is.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 5

bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....
Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......

Sorry, not me. No more travel until the Summit and except for fairly local stuff, no travel at all unless I get someone to pay for it. Mrs. Scary controls the purse strings (and wears the pants).

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Paul White SSC Guru Points: 150468 More actions · Answer 6

GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top?http://www.sqlservercentral.com/Forums/FindPost999124.aspx

No, what makes you think it might have been?

The misconceptions concerning shrinking versus truncating logs might make for a better '2sday' blog post than 'truncate table cannot be rolled back'. Both have been covered very many times, and yet both persist...:(

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 7

GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx

Not even a little bit. Very clear, to the point, fact based... looks fine to me.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

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

Paul White NZ (10/6/2010)
GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top?http://www.sqlservercentral.com/Forums/FindPost999124.aspx
No, what makes you think it might have been?

Reading over it after I posted it read (to me) almost like a tirade rather than an explanation.

The misconceptions concerning shrinking versus truncating logs might make for a better '2sday' blog post than 'truncate table cannot be rolled back'. Both have been covered very many times, and yet both persist...:(

I've written twice on that already (blog post and article). Not touching it again (until it's time to rewrite my tran log article here). If you want it, take it. I have 3 table variable myths targeted.

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

Ray K SSC-Dedicated Points: 31168 More actions · Answer 9

Chris Morris-439714 (10/6/2010)
Brandie Tarvin (10/6/2010)
Chris Morris-439714 (10/6/2010)
Brandie Tarvin (10/6/2010)
BrainDonor (10/5/2010)
When I die I'm donating my body to science-fiction.
Oh, is that a promise? I could use a few more cadavers...
@=)
More??? The next question is kinda obvious but I'm scared to ask!
He said Science-Fiction. I'm a Science-Fiction author. Been thinking of branching into Mystery... You do the math. @=)
Ok...that would be 42 then. 6 x 7.

According to the late Douglas Adams, it was 6 x 9!

Hey, it works in base 13!

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

Kit G SSCrazy Points: 2888 More actions · Answer 10

Grant Fritchey (10/6/2010)
bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....
Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
Sorry, not me. No more travel until the Summit and except for fairly local stuff, no travel at all unless I get someone to pay for it. Mrs. Scary controls the purse strings (and wears the pants).

Of course Mrs. Scary wears the pants, Grant, you wear a kilt! 😀

By the way, poking around YouTube last night, I saw a video of Michael McIntyre (comedian) on the Birth of the Kilt. Thought I'd share. 🙂

-- Kit

Paul White SSC Guru Points: 150468 More actions · Answer 11

GilaMonster (10/6/2010)
Reading over it after I posted it read (to me) almost like a tirade rather than an explanation.

I see. Well, I went back and read it again, just in case I missed it first time around...and I still think it's totally fine.

I've written twice on that already (blog post and article). Not touching it again (until it's time to rewrite my tran log article here). If you want it, take it. I have 3 table variable myths targeted.

I'm planning to do something on the read committed isolation level or partitioning - haven't decided yet.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 12

Paul White NZ (10/6/2010)
GilaMonster (10/6/2010)
Reading over it after I posted it read (to me) almost like a tirade rather than an explanation.
I see. Well, I went back and read it again, just in case I missed it first time around...and I still think it's totally fine.
I've written twice on that already (blog post and article). Not touching it again (until it's time to rewrite my tran log article here). If you want it, take it. I have 3 table variable myths targeted.
I'm planning to do something on the read committed isolation level or partitioning - haven't decided yet.

I agree - they need to understand how backups work, and the relation to how you correctly maintain the log file size.

If they can't read this, and understand it, they probably shouldn't be a DBA.

Greg E

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 13

Kit G (10/6/2010)
Grant Fritchey (10/6/2010)
bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....
Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
Sorry, not me. No more travel until the Summit and except for fairly local stuff, no travel at all unless I get someone to pay for it. Mrs. Scary controls the purse strings (and wears the pants).
Of course Mrs. Scary wears the pants, Grant, you wear a kilt! 😀
By the way, poking around YouTube last night, I saw a video of Michael McIntyre (comedian) on the Birth of the Kilt. Thought I'd share. 🙂

You're sure what he wears are kilts and not skirts, right? 😀

Anyone want to join me for dinner? There'll be plenty of pork chops for everybody. 😛 :w00t:

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 14

bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....
Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......

Up in the air here. Trying to work out a schedule that won't kill me and keep me married. I'd like to come, but we'll see.

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 15

Alvin Ramard (10/6/2010)
Kit G (10/6/2010)
Grant Fritchey (10/6/2010)
bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....
Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
Sorry, not me. No more travel until the Summit and except for fairly local stuff, no travel at all unless I get someone to pay for it. Mrs. Scary controls the purse strings (and wears the pants).
Of course Mrs. Scary wears the pants, Grant, you wear a kilt! 😀
By the way, poking around YouTube last night, I saw a video of Michael McIntyre (comedian) on the Birth of the Kilt. Thought I'd share. 🙂
You're sure what he wears are kilts and not skirts, right? 😀
Anyone want to join me for dinner? There'll be plenty of pork chops for everybody. 😛 :w00t:

Oh, I've worn skirts too. Used to wear tube skirts out "clubbing" back in the eighties. There's a reason I'm "scary."

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning