Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 43,471 through 43,485 (of 66,709 total)

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

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

dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?

There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀

_______________________________________________________________

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/

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

Ed Wagner (3/28/2014)
Of course, the question of how it could be right came up because there wasn't enough code. Sigh.

Fantastic way to measure accuracy, I'll have to remember that one...

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀

Would you call yourselves programmers or developers?

I have often heard that programmers are more like code monkeys and developers have higher skills.

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

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

Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀

<<cough>>

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

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

SQLRNNR (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
Would you call yourselves programmers or developers?
I have often heard that programmers are more like code monkeys and developers have higher skills.

I tend to think of myself as knuckle dragger. 😉 To be honest I use those two terms interchangeably, sort of like employee and associate.

_______________________________________________________________

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 6

ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
<<cough>>

Well shoot. I can't remember everybody. 😛 Of course I don't really know what everybody does for work but we certainly all deal with sql at some level or other.

_______________________________________________________________

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

SQLRNNR (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
Would you call yourselves programmers or developers?
I have often heard that programmers are more like code monkeys and developers have higher skills.

I'm glad that someone else brought up that distinction because I make that same distinction in my mind but a lot of people don't have a similar distinction. With that in mind and giving Developers that call themselves "Programmers" the respect they deserve, I try to avoid using the word "programmer" in a derogatory sense and just go straight for "moroff". 😛 It covers both worlds, as well. :hehe:

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

Grant Fritchey SSC Guru Points: 398881 More actions · Answer 8

Jeff Moden (3/28/2014)
SQLRNNR (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
Would you call yourselves programmers or developers?
I have often heard that programmers are more like code monkeys and developers have higher skills.
I'm glad that someone else brought up that distinction because I make that same distinction in my mind but a lot of people don't have a similar distinction. With that in mind and giving Developers that call themselves "Programmers" the respect they deserve, I try to avoid using the word "programmer" in a derogatory sense and just go straight for "moroff". 😛

Don't forget to include the booth babes.

"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

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

Sean Lange (3/28/2014)
ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
<<cough>>
Well shoot. I can't remember everybody. 😛 Of course I don't really know what everybody does for work but we certainly all deal with sql at some level or other.

OMG I'm a GUM :crying:

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

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

ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
<<cough>>
Well shoot. I can't remember everybody. 😛 Of course I don't really know what everybody does for work but we certainly all deal with sql at some level or other.
OMG I'm a GUM :crying:

What's a GUM???

_______________________________________________________________

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 11

Jeff Moden (3/28/2014)
SQLRNNR (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
Would you call yourselves programmers or developers?
I have often heard that programmers are more like code monkeys and developers have higher skills.
I'm glad that someone else brought up that distinction because I make that same distinction in my mind but a lot of people don't have a similar distinction. With that in mind and giving Developers that call themselves "Programmers" the respect they deserve, I try to avoid using the word "programmer" in a derogatory sense and just go straight for "moroff". 😛 It covers both worlds, as well. :hehe:

I'm moroff and wear it with distinction and pride. It took a lot of work to get this far off. 😀

_______________________________________________________________

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/

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

Sean Lange (3/28/2014)
ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
<<cough>>
Well shoot. I can't remember everybody. 😛 Of course I don't really know what everybody does for work but we certainly all deal with sql at some level or other.
OMG I'm a GUM :crying:
What's a GUM???

http://www.acronymfinder.com/Great-Unwashed-Masses-(GUM).html

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

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

ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
ChrisM@Work (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
<<cough>>
Well shoot. I can't remember everybody. 😛 Of course I don't really know what everybody does for work but we certainly all deal with sql at some level or other.
OMG I'm a GUM :crying:
What's a GUM???
http://www.acronymfinder.com/Great-Unwashed-Masses-(GUM).html

ROFL. Never heard of that site, could come in quite handy. I would certainly not suggest you are a GUM. Dang, see what I get for mentioning a couple of names. :ermm:

_______________________________________________________________

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/

Ed Wagner SSC Guru Points: 287026 More actions · Answer 14

Grant Fritchey (3/28/2014)
Jeff Moden (3/28/2014)
SQLRNNR (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower than a snail going backwards.
http://www.sqlservercentral.com/Forums/FindPost1555701.aspx
Based on what I have to deal daily answer is easily :-):-(
This kind of things happen when programmers write t-SQL.
Here, here! Let's keep all the programmers out of SQL!
What sayeth the SQLverse?
There are more programmers around here (including me) than you realize. Gail and Lowell, Jack Corbett...not sure who else I might be missing. 😀
Would you call yourselves programmers or developers?
I have often heard that programmers are more like code monkeys and developers have higher skills.
I'm glad that someone else brought up that distinction because I make that same distinction in my mind but a lot of people don't have a similar distinction. With that in mind and giving Developers that call themselves "Programmers" the respect they deserve, I try to avoid using the word "programmer" in a derogatory sense and just go straight for "moroff". 😛
Don't forget to include the booth babes.

Grant - You have booth babes??? :w00t:

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

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

Ed Wagner (3/28/2014)
Grant - You have booth babes??? :w00t:

Grant *is* the booth 'babe' 🙂

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