Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 19,861 through 19,875 (of 66,815 total)

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 1

GilaMonster (10/4/2010)
CirquedeSQLeil (10/4/2010)
GilaMonster (10/4/2010)
Craig Farrell (10/4/2010)
Alvin Ramard (10/4/2010)
GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?
The order is not that critical if you have DBCC TimeWarp installed. 😀
I always found the time to check was 'During'. Gave me the most interesting results. 🙂
I'd agree, but the duration for drop database is so short there isn't even time to reflect on the meaning of life.
I just realized who our drop database OP was. Doh
I realised even before I opened it. Some days I wonder...

... and other days I'm VERY sure.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

BrainDonor SSCoach Points: 19269 More actions · Answer 2

Alvin Ramard (10/4/2010)
WayneS (10/4/2010)
BrainDonor (10/4/2010)
Paul White NZ (10/2/2010)
Local news: Lots of changes on 1 October. GST went up, income tax came down, and Internet bandwidth increased to 15Mbps from 10Mbps. And I'm moving house.
How much is GST increasing by? We're planning a tour of both islands for next year and had all of the hotel, fuel bills and suchlike budgeted. If we have to increase it all by a large percentage then I'm selling some of the kid's organs.
Sell them anyway... you're already a brain donor! 😀
I'd donate my brain to science if they would agree to come retrieve it immediately. 😛

When I die I'm donating my body to science-fiction.

Steve Hall
Linkedin
Blog Site

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 3

GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

Doesn't really matter does it? You can just hit the undo button.

"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

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 4

Chad Crawford (10/4/2010)
Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions or just presentation files?
Thanks,
Chad

It's several DVDs and it has all the sessions except for the pre/post-con sessions.

"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

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

I got the DVDs last year, after missing most sessions. I've listened to a few and they are pretty good. You definitely miss something by not seeing the speaker, but it's not horrible.

Chad Crawford SSChampion Points: 11610 More actions · Answer 6

Wayne posted the link for last year, if you want this year's copy I think you can purchase it when you register, or if you've already registered and need to add it (like me), you can call and have it added to your registration. It looks like it's cheaper if you pre-pay ($125?). Work agreed to foot the bill, which is nice.

Chad

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

Is it time to implement some sort of entrance exam for SSC? After reading the question I actually spent a few minutes staring at the screen thinking "What .......? "

http://www.sqlservercentral.com/Forums/Topic998393-392-1.aspx

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]

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

Alvin Ramard (10/5/2010)
Is it time to implement some sort of entrance exam for SSC? After reading the question I actually spent a few minutes staring at the screen thinking "What .......? "
http://www.sqlservercentral.com/Forums/Topic998393-392-1.aspx

That's quite funny.

Some years ago while working for a London borough, our little group of contractors used to joke that the council had an upper IQ limit as an entrance requirement. Somewhere around 70. One advantage I suppose of having a socialist local government was that otherwise-unemployable folks had somewhere to go in the mornings, even if they didn't know what to do when they got there.

^{“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

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 9

I see this a lot, even with authors. People think you are following along with them, or they don't realize they're skipping steps to ask a question and explain themselves.

It's probably obvious to that guy what a "processed" row is.

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

A guess would be a null value for CMD_File_Date_Loaded in the third table, but to paraphrase JBM "a developer should know"

^{“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: 399278 More actions · Answer 11

Steve Jones - SSC Editor (10/5/2010)
I see this a lot, even with authors. People think you are following along with them, or they don't realize they're skipping steps to ask a question and explain themselves.
It's probably obvious to that guy what a "processed" row is.

Oh yeah, the number of times where I've gotten back edits that simply say "I don't understand this paragraph" and when I read what I wrote, I don't understand it either, are too numerous to count.

"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

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

Grant Fritchey (10/5/2010)
Steve Jones - SSC Editor (10/5/2010)
I see this a lot, even with authors. People think you are following along with them, or they don't realize they're skipping steps to ask a question and explain themselves.
It's probably obvious to that guy what a "processed" row is.
Oh yeah, the number of times where I've gotten back edits that simply say "I don't understand this paragraph" and when I read what I wrote, I don't understand it either, are too numerous to count.

I read that one as the OP does not know how to do an import, or an import with a filter. My initial reaction was along the lines of "Do you even know enough SQL to be asking that question?"

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]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 13

Steve Jones - SSC Editor (10/5/2010)
I see this a lot, even with authors. People think you are following along with them, or they don't realize they're skipping steps to ask a question and explain themselves.
It's probably obvious to that guy what a "processed" row is.

Someday I hope to be an author again. Maybe after SQLSaturday and SQLRally ore over.:blink:

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 14

Chris Morris-439714 (10/5/2010)
A guess would be a null value for CMD_File_Date_Loaded in the third table, but to paraphrase JBM "a developer should know"

That's not the problem, the OP "knows", he/she just isn't sharing 😀

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 15

And just when I thought the project I'm on couldn't get any worse..

We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting with the business users yesterday to demo the half of the system that was working. Business users came up with a long list of changes they want, none of which were in the spec.

I take a look over the list and, of the 4 that impact me, rate 2 as moderate-difficult and 2 as minor, but comment that I can't give a time impact until I've had a chance to analyse a bit better. The front end dev rates 1 as medium, estimating a week's work, and the rest as minor

This morning, in project meeting, project manager announces that we will be implementing all but one of those changes before the original project deadline (2 weeks away)

WT!@#$%$#^*&^^$%???????

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