Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 49,996 through 50,010 (of 66,712 total)

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

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

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.

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

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

Only 4 posts to go! 😛

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

rodjkidd SSCoach Points: 15916 More actions · Answer 3

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.

You get all the fun queries to tune! :w00t:

Rodders...

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

Ah, Gail had one more reply, so that should have been 3.

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

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

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

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

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

50000!

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 7

Eirikur Eiriksson

SSC Guru

Points: 182912

August 11, 2015 at 6:38 am

#1818894

~~0xC34F~~0xC350 Missed it:pinch::-D

😎

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

Dammit!

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

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

Koen Verbeeck (8/11/2015)
Dammit!

😀

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

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

GilaMonster (8/11/2015)
Koen Verbeeck (8/11/2015)
Dammit!
😀

I blame the slow internet connection. 😀

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

andrew gothard SSChampion Points: 12314 More actions · Answer 11

Eirikur Eiriksson (8/5/2015)
Sean Lange (8/5/2015)
GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against the wall trying to write a query with a cross apply to a hard coded list of three values. I swear the syntax is correct...I tried a simple version on my local and it was fine. WTF is the problem?? Oh yeah, production is still running 2005. :crying:
Honestly, I don't think your coding is the problem here, trailing back to Yukon/Picasso means you're environment is slightly behind, not to say more.
😎
For the giggles (or rather buckets of tears) how many are still running outdated versions of SQL?

Aye, all the way back to 2000. In fact the last v7 based system only died a few months back. I do, however, have a (funded) cunning plan ...

We do currently have a vendor requesting we put in a new 2008R2 box for them. Really, you want us to install a non-supported version of SQL Server - that is SUCH a good sign of your commitment to the future this product ...

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.

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

Where are the balloons from the ceiling? Confetti?

Cake?

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

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

This has been quite the disappointment.

I thought we all would get 50,000 extra points.

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

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

Koen Verbeeck (8/11/2015)
jasona.work (8/11/2015)
Where are the balloons from the ceiling? Confetti?
Cake?
This has been quite the disappointment.
I thought we all would get 50,000 extra points.

Ah well, up to 100K!

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 15

Koen Verbeeck (8/11/2015)
Koen Verbeeck (8/11/2015)
jasona.work (8/11/2015)
Where are the balloons from the ceiling? Confetti?
Cake?
This has been quite the disappointment.
I thought we all would get 50,000 extra points.
Ah well, up to 100K!

Better get at it then!

😎