Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 50,011 through 50,025 (of 66,815 total)

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Koen Verbeeck (8/11/2015)
GilaMonster (8/11/2015)
Koen Verbeeck (8/11/2015)
Dammit!
😀
I blame the slow internet connection. 😀

You mean my slow internet connection?

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

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 2

GilaMonster (8/11/2015)
Grant would love this query. Views within views within views with a CTE and a temp table for good measure. Parse time is around 45 seconds.

Oooh, 45 seconds is a pretty good parse time. It must be truly heinous.

"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

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 3

Eirikur Eiriksson (8/11/2015)
~~0xC34F~~0xC350 Missed it:pinch::-D
😎

... by that much.

"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

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 4

Just saw the news. Congrats Gail.

"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

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 5

Grant Fritchey (8/11/2015)
Eirikur Eiriksson (8/11/2015)
~~0xC34F~~0xC350 Missed it:pinch::-D
😎
... by that much.

It was truly a "near miss":-D

😎

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 6

Grant Fritchey (8/11/2015)
Just saw the news. Congrats Gail.

It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages and submitted it to a local AI conference. It's not a requirement of a Masters that a paper be submitted, but it is 'strongly encouraged'.

Oh, and that's not the 'news of moderate interest' which I mentioned in post 50 000. That's still to come later.

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

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 7

GilaMonster (8/11/2015)
Grant Fritchey (8/11/2015)
Just saw the news. Congrats Gail.
It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages and submitted it to a local AI conference. It's not a requirement of a Masters that a paper be submitted, but it is 'strongly encouraged'.
Oh, and that's not the 'news of moderate interest' which I mentioned in post 50 000. That's still to come later.

Well good gosh, spill. I don't have time to monitor Twitter. These presentations aren't going to write themselves.

"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

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

Am I late to the party? I was on a meeting.

Should I open the bottles of champagne? Who's in charge of the BBQ? :hehe:

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

WayneS SSC Guru Points: 95461 More actions · Answer 9

Grant Fritchey (8/11/2015)
GilaMonster (8/11/2015)
Grant Fritchey (8/11/2015)
Just saw the news. Congrats Gail.
It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages and submitted it to a local AI conference. It's not a requirement of a Masters that a paper be submitted, but it is 'strongly encouraged'.
Oh, and that's not the 'news of moderate interest' which I mentioned in post 50 000. That's still to come later.
Well good gosh, spill. I don't have time to monitor Twitter. These presentations aren't going to write themselves.

+1. Stop tormenting us Gail

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

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

jasona.work (8/11/2015)
Where are the balloons from the ceiling? Confetti?
Cake?

Is this the confetti you wanted?

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 11

Grant Fritchey (8/11/2015)
GilaMonster (8/11/2015)
Grant Fritchey (8/11/2015)
Just saw the news. Congrats Gail.
It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages and submitted it to a local AI conference. It's not a requirement of a Masters that a paper be submitted, but it is 'strongly encouraged'.
Oh, and that's not the 'news of moderate interest' which I mentioned in post 50 000. That's still to come later.
Well good gosh, spill. I don't have time to monitor Twitter. These presentations aren't going to write themselves.

Later.

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

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

Luis Cazares (8/11/2015)
Am I late to the party? I was on a meeting.
Should I open the bottles of champagne? Who's in charge of the BBQ? :hehe:

Merry Christmas! Have I missed anything?

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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 13

ChrisM@Work (8/11/2015)
Luis Cazares (8/11/2015)
Am I late to the party? I was on a meeting.
Should I open the bottles of champagne? Who's in charge of the BBQ? :hehe:
Merry Christmas! Have I missed anything?

Happy New Year!

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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 14

Gail in the Wild was lurking up on us and snatched 50k just like that.

Slow internet and all - sheesh.

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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 15

GilaMonster (8/11/2015)
And in unrelated news, something of moderate interest might be happening this afternoon/tonight (depending on timezones). Watch twitter.

With this kind of tease, you must have decided for a new career in marketing.

Now I am going to be stuck to twitter instead of finishing up those articles, presentations, and that client work.:crazy:

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