Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 16,081 through 16,095 (of 66,749 total)

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

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

Grant Fritchey (6/30/2010)
...Maybe a really big article on the best way to nest views inside of views inside of views all while joining views...

A recursive CTE using a recursive CTE as input takes some beating.

Darwinian coding; a little accidental bit at a time, survival of the last statement that worked.

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

Gianluca Sartori (6/30/2010)
I initially posted a cross-post warning on both threads and I realized they were not the same problem and different OPs...

Removed your "removed" posts.

GabyYYZ SSCertifiable Points: 7913 More actions · Answer 3

Stefan Krzywicki (6/30/2010)
GabyYYZ (6/30/2010)
Happy Canada Day for all Canadians north of the 49th and in the diaspora!
Is it not Canada Day for Canadians in Canada south of the 49th?

Oops, I guess U.S. is sort of diaspora, but not really. Happy Canada Day to Canadians everywhere then! 🙂

Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

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

GabyYYZ (6/30/2010)
Stefan Krzywicki (6/30/2010)
GabyYYZ (6/30/2010)
Happy Canada Day for all Canadians north of the 49th and in the diaspora!
Is it not Canada Day for Canadians in Canada south of the 49th?
Oops, I guess U.S. is sort of diaspora, but not really. Happy Canada Day to Canadians everywhere then! 🙂

I just meant the large, populous parts of Canada that are below the 49th parallel, like Montreal and some of the island provinces. I'm not that familiar with Canada Day and thought maybe the Western Provinces celebrated something different, like Patriots Day here in Massachusetts.

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

WayneS SSC Guru Points: 95461 More actions · Answer 5

GabyYYZ (6/30/2010)
Roy Ernest (6/30/2010)
This is the first time that one my articles did not bring out any discussion. It was rated very good, but it is very quiet... 🙂
Lucky...still shell-shocked from the discussion on mine. For my next topic, I will keep away from talking about cursors and stay with something everyone can agree on, why autoshrink is a good thing. 😀
Happy Canada Day for all Canadians north of the 49th and in the diaspora!

Gaby, how did the discussion go on it from it being republished? I wasn't able to look at it... was kinda fearful for 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

Steve Jones - SSC Editor SSC Guru Points: 736632 More actions · Answer 6

There was a little discussion, but not too much contention on it. Gaby added a nice introduction to the beginning of the article as well noting that it was older and some of the advice was tempered by new experience.

spaghettidba SSC Guru Points: 105732 More actions · Answer 7

Steve Jones - Editor (6/30/2010)
Gianluca Sartori (6/30/2010)
I initially posted a cross-post warning on both threads and I realized they were not the same problem and different OPs...
Removed your "removed" posts.

Thank you!

One could think that those posts contained vital information on how to solve the issue and I removed them to drive the OP crazy. 😀

-- Gianluca Sartori

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

Could someone who knows their way around deadlocks take a look at this please? Not going to be able look at it before the weekend

http://www.sqlservercentral.com/Forums/Topic944536-338-1.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

GabyYYZ SSCertifiable Points: 7913 More actions · Answer 9

WayneS (6/30/2010)
GabyYYZ (6/30/2010)
Roy Ernest (6/30/2010)
This is the first time that one my articles did not bring out any discussion. It was rated very good, but it is very quiet... 🙂
Lucky...still shell-shocked from the discussion on mine. For my next topic, I will keep away from talking about cursors and stay with something everyone can agree on, why autoshrink is a good thing. 😀
Happy Canada Day for all Canadians north of the 49th and in the diaspora!
Gaby, how did the discussion go on it from it being republished? I wasn't able to look at it... was kinda fearful for you!

Conversation has died down and I've submitted a disclaimer at the beginning. It's all good.

Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

WayneS SSC Guru Points: 95461 More actions · Answer 10

GilaMonster (6/30/2010)
Could someone who knows their way around deadlocks take a look at this please? Not going to be able look at it before the weekend
http://www.sqlservercentral.com/Forums/Topic944536-338-1.aspx

I threw some info out there, we'll see if it helps.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 11

Dave Ballantyne (6/30/2010)
Coincidence ? , homework ? or left hand not talking to right hand ?
Both similar problems , 2000 to 2008 upgrade , udf performance
http://www.sqlservercentral.com/Forums/Topic945233-392-1.aspx
http://www.sqlservercentral.com/Forums/Topic945210-392-1.aspx

It can't be coincidence! Here's another one:

http://www.sqlservercentral.com/Forums/FindPost945960.aspx

-- Gianluca Sartori

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

Can someone please help out here? i thought it might be the TokenAndPermUserStore problem, but it doesn't appear so. Don't want ppl to think that that because there's a ot of posts it's resolved.

http://www.sqlservercentral.com/Forums/Topic945562-149-1.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