Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 44,161 through 44,175 (of 66,712 total)

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

jasona.work SSC Guru Points: 50117 More actions · Answer 1

Ed Wagner (6/13/2014)
Jack Corbett (6/13/2014)
GilaMonster (6/13/2014)
Thought process of last 10 minutes.
- Tune a proc quick, then go home
- Wait, it's got user defined functions
- Wait, the UDFs have cursors
- I'm going home!
There's a great decision.
Yeah, really. It's Friday at 11:30 EST, so I think that sounds like a good idea.

Can I go home too?

Please?

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

Ed Wagner (6/13/2014)
Jack Corbett (6/13/2014)
GilaMonster (6/13/2014)
Thought process of last 10 minutes.
- Tune a proc quick, then go home
- Wait, it's got user defined functions
- Wait, the UDFs have cursors
- I'm going home!
There's a great decision.
Yeah, really. It's Friday at 11:30 EST, so I think that sounds like a good idea.

And World Cup coverage starts up today in about 11 minutes. Would so much prefer sitting a tavern somewhere with a cold beer watching the games instead of sitting at my desk working.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

jasona.work (6/13/2014)
Ed Wagner (6/13/2014)
Jack Corbett (6/13/2014)
GilaMonster (6/13/2014)
Thought process of last 10 minutes.
- Tune a proc quick, then go home
- Wait, it's got user defined functions
- Wait, the UDFs have cursors
- I'm going home!
There's a great decision.
Yeah, really. It's Friday at 11:30 EST, so I think that sounds like a good idea.
Can I go home too?
Please?

Sure. Fine by me!!! 😛

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

Please do not disturb.

Watching the World Cup and cheering for Mexico!:-D

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

Luis Cazares (6/13/2014)
Please do not disturb.
Watching the World Cup and cheering for Mexico!:-D

I won't tell anyone you are not at your desk. 😛 I imagine that most of the country is glued to the television right now.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 6

I'm very busy working right now. Didn't just see that corner kick by Cameroon. Nope. Working on an article for Red Gate. That's what I'm doing.

"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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 7

Heh, Grant...

I just literally rolled out of bed. 🙂 I love this contract.

Good game today though?

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

I hope I don't have to avoid SSC for the next month so I don't hear scores before I am able to watch the games on my DVR. :w00t:

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 9

NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it was dramatic.

"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

Sean Lange SSC Guru Points: 286590 More actions · Answer 10

Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it was dramatic.

That is was. Well worth the time to watch it.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 11

Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it was dramatic.
That is was. Well worth the time to watch it.

I couldn't even have it on in the background. I'm trying to finish my book and need to concentrate.

"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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it was dramatic.
That is was. Well worth the time to watch it.
I couldn't even have it on in the background. I'm trying to finish my book and need to concentrate.

What, you don't want to put random football commentary into the book?

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 13

Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it was dramatic.
That is was. Well worth the time to watch it.
I couldn't even have it on in the background. I'm trying to finish my book and need to concentrate.

My wife pretty much hates June/early July every 4 years. I told her it is much easier than it used to be. I haven't watched every single game since we got married, only around 20-25 of the games. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004353 More actions · Answer 14

Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it was dramatic.
That is was. Well worth the time to watch it.
I couldn't even have it on in the background. I'm trying to finish my book and need to concentrate.

Ooooooo.... now you have my interest. What's the subject?

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

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 15

SQLRNNR (6/13/2014)
Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it was dramatic.
That is was. Well worth the time to watch it.
I couldn't even have it on in the background. I'm trying to finish my book and need to concentrate.
What, you don't want to put random football commentary into the book?

From Grant's latest draft:

In other words, the optimizer figures out how best to implement the request represented
by the T-SQL query you submitted. It decides if it can access the data through indexes,
what types of joins to use and much more. The decisions made by the optimizer are based
on GOOOOOOOOAAAALLL!!! <airplane run> <shirt off> <knee slide> <dogpile> what it calculates to be the cost of a given execution plan, in terms of the required
CPU processing and I/O. Hence, this is a cost-based plan.

Jason Wolfkill