Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 37,981 through 37,995 (of 66,738 total)

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

Paul White SSC Guru Points: 150468 More actions · Answer 1

Grant Fritchey (9/25/2012)
That was a very thorough answer. I'll bet you it's not what he wants though. I'm still not sure where he's trying to get to.

My best guess 🙂

But you're probably right 🙁

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

Grant Fritchey (9/25/2012)
SQL Kiwi (9/25/2012)
Grant Fritchey (9/25/2012)
I'm not getting what this guy is after, so I'm clearly not helping. Could someone else check it out please?
I tried my best, but it is an awful question. If I had seen it on http://dba.stackexchange.com/ or http://stackoverflow.com/ I would likely have down-voted it and moved on.
That was a very thorough answer. I'll bet you it's not what he wants though. I'm still not sure where he's trying to get to.

Paul and I answered in the same vein (Paul's answer is substantially more thorough). I'd agree he probably won't care to hear the options, but mostly because he's stuck on a testing methodology which is going to lead him to bad conclusions.

In short - probably not what he *wants*, but more along the lines of what he actually *needs*.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Paul White SSC Guru Points: 150468 More actions · Answer 3

Matt Miller (#4) (9/25/2012)
Paul and I answered in the same vein

Ooo I missed that one - must have come in while I was writing mine. I might not have bothered! :laugh:

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

WayneS SSC Guru Points: 95460 More actions · Answer 4

Just figured out a solution to a SSRS report that I've been messing with for way too long.

:satisfied: (as long as the customer likes it)

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

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 5

THREADIZENS!

Who is going to make it to any of the SQL in the City events coming up in the next week+?

"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

Dwain Camps SSC Guru Points: 86978 More actions · Answer 6

Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?

If you ever get around to having one in Bangkok, I'm there!

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

Ant-Green SSC Guru Points: 113507 More actions · Answer 7

Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?

I missed the London one's due to family commitements, if you every do them again in the UK, maybe one in the Manchester area as well as London as that would be easier for us Northener's

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?

If you do one in Brussels (capital of Europe :-D), I'll be there for sure.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

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

Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?
If you do one in Brussels (capital of Europe :-D), I'll be there for sure.

Hahaha! Brussels is just about big enough for a brewery, a monastery and a chippy - so long as the brewery is IN the monastery!

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 10

It still has the seat for the European Union/Committee. 😛

(always great traffic jams when they have a meeting)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

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

Koen Verbeeck (9/28/2012)
It still has the seat for the European Union/Committee. 😛
(always great traffic jams when they have a meeting)

I rest my case - room for only one seat 😀

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 12

I know Europe is small, that's why we shipped all the village idiots to another continent to make more room 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 13

ChrisM@Work (9/28/2012)
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?
If you do one in Brussels (capital of Europe :-D), I'll be there for sure.
Hahaha! Brussels is just about big enough for a brewery, a monastery and a chippy - so long as the brewery is IN the monastery!

But the brewery IS Cantillon... and they've got the Mannekin Pis

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 14

Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?
If you do one in Brussels (capital of Europe :-D), I'll be there for sure.

Grant asked who'd come furthest in one session in London, & some people had come from Brussels specially for the day - so that's no excuse 😀

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 15

laurie-789651 (9/28/2012)
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?
If you do one in Brussels (capital of Europe :-D), I'll be there for sure.
Grant asked who'd come furthest in one session in London, & some people had come from Brussels specially for the day - so that's no excuse 😀

I know, they were two colleagues of mine 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP