Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 21,421 through 21,435 (of 66,738 total)

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

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

GilaMonster (11/12/2010)
Stefan Krzywicki (11/12/2010)
Once everone who went to PASS is back (I think it is over now, yes?)
No, today's the postcon day (should be starting in about an hour).

Got it, thanks! I shall hold my horses for at least one more day. : -)

--------------------------------------
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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

GilaMonster (11/12/2010)
I swear this project is going to drive me to drink.
Email from BA/architect:
Urgent! Business confirms that it is possible to have more than one X per Y. Out design must cater for this.
My reply:
During my initial analysis I identified that this was the case based on a discussion with <someone>. The current system design allows for any number of X per Y and has done so since the beginning.

Should have replied back with "You sound like a bunch of panicking students who don't know how to do their assignment and subsequently post it in the forums for somebody else to do."

Would that have gotten the BA's goat?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

Jeff Moden (11/12/2010)
Paul White NZ (11/11/2010)
Did you also bust the myth that table variables are always estimated as containing one row?
Statement level recompile?

Yup.

There's still no statistics, but the storage engine knows the total rows in the table. The optimiser can generate a non-1 estimate from that. It may still be totally wrong, because there's no density information, no histogram, so no way of telling what the data actually looks like. The estimate appears to be a 'magic number' formula based just on the total row count in the table.

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

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

CirquedeSQLeil (11/12/2010)
GilaMonster (11/12/2010)
CirquedeSQLeil (11/11/2010)
I have a few articles that I am finishing up currently.
Topics?
Physical Join Operators

Toss it over. If I need a break from genetic algorithms this weekend I'll take a look. Will just be brief comments.

gail (at) <blog domain>

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

WayneS SSC Guru Points: 95460 More actions · Answer 5

The Dixie Flatline (11/11/2010)
Congratulations, Wayne. Applause! Thunderous applause
Let me ask what logging takes place with table variables, since they are not affected by rollbacks.

They are not affected by explicit rollbacks (begin tran / rollback tran). They are affected by implicit transactions (update/insert/delete statement failing, causing a rollback of all previously changed rows by that statement).

Please refer to Gail's blog http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ for everything you need to know about that - it explains it very thoroughly.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95460 More actions · Answer 6

Paul White NZ (11/11/2010)
WayneS (11/11/2010)
I started the presentation asking questions. Everyone thought that table variables were 1. memory-only, 2. did no logging, and 3. had no indexes. Now, about 20 more people know better.
Well done. It's amazing how few database people know the basics of table variables.
Did you also bust the myth that table variables are always estimated as containing one row?

I assume you mean with the OPTION (RECOMPILE) hint? Sure did.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

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

GilaMonster (11/12/2010)
I swear this project is going to drive me to drink.
Email from BA/architect:
Urgent! Business confirms that it is possible to have more than one X per Y. Out design must cater for this.
My reply:
During my initial analysis I identified that this was the case based on a discussion with <someone>. The current system design allows for any number of X per Y and has done so since the beginning.

I think that particular project might drive me to felonies...

---------------------------------------------------------
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."

WayneS SSC Guru Points: 95460 More actions · Answer 8

CirquedeSQLeil (11/11/2010)
WayneS (11/11/2010)
WayneS (11/11/2010)
Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk, and all the other stuff you need for public speaking.
Well, I think it went pretty well. In a similar vein to Gail's "statistics" 5 times in a minute, I did get a little bit tongue-tied saying "tempdb" and "temporary tables" in the same sentence. I ran the PowerPoint presentation in presenter mode, but then ran into some minor issues flipping back and forth with SSMS and my virtual machine back to the slide. I might try setting up the monitor in slave mode the next time.
I started the presentation asking questions. Everyone thought that table variables were 1. memory-only, 2. did no logging, and 3. had no indexes. Now, about 20 more people know better.
Congrats and good job.
When can I book you to speak for my User Group - same topic?

Almost anytime - though we need to ensure a better internet connection than what I ran into trying to view your last meeting.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

GSquared SSC Guru Points: 260824 More actions · Answer 9

Henrico Bekker (11/12/2010)
another one....
http://www.sqlservercentral.com/Forums/Topic1019796-1550-1.aspx?Update=1
oh and I reached a 1000 point...small milestone 😀

Congrats on the millennial mark!

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

WayneS SSC Guru Points: 95460 More actions · Answer 10

GilaMonster (11/12/2010)
WayneS (11/11/2010)
Everyone thought that table variables were 1. memory-only, 2. did no logging, and 3. had no indexes. Now, about 20 more people know better.
And I thought the 'no logging' myth was a rare one. Glad I did spend some (lots of) time debunking that one.

Not only am I glad that you did so, but also that you let me use your work in my presentation. THANK YOU!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

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

Because you're bored, it's Friday, and I'm stuck :-D:-P

http://www.sqlservercentral.com/Forums/Topic1019985-1633-1.aspx

---------------------------------------------------------
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."

WayneS SSC Guru Points: 95460 More actions · Answer 12

The Dixie Flatline (11/12/2010)
Paul, thanks for the reply. I understand now.

Okay, that's 21 now! :w00t:

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

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

GilaMonster (11/12/2010)
I swear this project is going to drive me to drink.
Email from BA/architect:
Urgent! Business confirms that it is possible to have more than one X per Y. Out design must cater for this.
My reply:
During my initial analysis I identified that this was the case based on a discussion with <someone>. The current system design allows for any number of X per Y and has done so since the beginning.

How about - can you test and verify I accounted for this correctly?

I thought this was covered very early on.

Must be the Urgent! that rattled you.

Greg E

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

Henrico Bekker (11/12/2010)
another one....
http://www.sqlservercentral.com/Forums/Topic1019796-1550-1.aspx?Update=1
oh and I reached a 1000 point...small milestone 😀

congrats!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

GilaMonster (11/12/2010)
CirquedeSQLeil (11/12/2010)
GilaMonster (11/12/2010)
CirquedeSQLeil (11/11/2010)
I have a few articles that I am finishing up currently.
Topics?
Physical Join Operators
Toss it over. If I need a break from genetic algorithms this weekend I'll take a look. Will just be brief comments.
gail (at) <blog domain>

Sent - thanks for the help. Brief comments are good. 🙂

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events