Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 49,906 through 49,920 (of 66,712 total)

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

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

jasona.work (8/5/2015)
On a side note, anyone want my summer cold? I'll even drive to your house and deliver it in person...

Would it make my summer cooler? It's hot in here.

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

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 2

jasona.work (8/5/2015)
On a side note, anyone want my summer cold? I'll even drive to your house and deliver it in person...

AhHA! Are you the one who gave this to me?

Or maybe I gave it to the forum last Friday and that's how you got it.

I do love my employer's work from home policy that allows me not infect the rest of the office while working on my urgent projects, though. (To be fair, I have PTO that I could be using, but I'd rather do fun stuff with that).

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

jasona.work (8/5/2015)
On a side note, anyone want my summer cold? I'll even drive to your house and deliver it in person...

Would you accept winter flu in exchange?

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

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

Ed Wagner (8/5/2015)

Just don't forget to drop the database when the interview is over. 😉

Or just create the objects in tempdb. :hehe:

_______________________________________________________________

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/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Sean Lange (8/5/2015)

Ed Wagner (8/5/2015)
Just don't forget to drop the database when the interview is over. 😉
Or just create the objects in tempdb. :hehe:

Or better yet - don't forget to format his hard drive.:cool:

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

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

SQLRNNR (8/5/2015)

Sean Lange (8/5/2015)
Ed Wagner (8/5/2015)
Just don't forget to drop the database when the interview is over. 😉
Or just create the objects in tempdb. :hehe:
Or better yet - don't forget to format his hard drive.:cool:

...and a bottle of gusano rojo mezcal to erase the "internal" memory, just in case

😎

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

Eirikur Eiriksson (8/5/2015)

SQLRNNR (8/5/2015)
Sean Lange (8/5/2015)
Ed Wagner (8/5/2015)
Just don't forget to drop the database when the interview is over. 😉
Or just create the objects in tempdb. :hehe:
Or better yet - don't forget to format his hard drive.:cool:
...and a bottle of gusano rojo mezcal to erase the "internal" memory, just in case
😎

Or you could just hit the interviewer with a sledgehammer on the head. The results are the same and the sledgehammer might be less aggressive. :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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

And in "back to the countdown" news:

49,913 posts with this post:-D

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

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

Luis Cazares (8/5/2015)

Eirikur Eiriksson (8/5/2015)
SQLRNNR (8/5/2015)
Sean Lange (8/5/2015)
Ed Wagner (8/5/2015)
Just don't forget to drop the database when the interview is over. 😉
Or just create the objects in tempdb. :hehe:
Or better yet - don't forget to format his hard drive.:cool:
...and a bottle of gusano rojo mezcal to erase the "internal" memory, just in case
😎
Or you could just hit the interviewer with a sledgehammer on the head. The results are the same and the sledgehammer might be less aggressive. :hehe:

I agree, the sledgehammer is far more gentle approach,nice touch Luis and very civil!

😎

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

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:

_______________________________________________________________

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/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

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:

Something seems wrong because CROSS APPLY and OUTER APPLY are available in SQL Server 2005.

Edit:

https://msdn.microsoft.com/en-us/library/ms177634(v=sql.90).aspx

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

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?

TomThomson SSC Guru Points: 104773 More actions · Answer 13

Luis Cazares (8/5/2015)
Here's a method to learn any programming language in 21 days.
If image is not visible, you can find it here.

That's a terribly slow timetable; it should be done in 6 days, not take 21. Day 1 not days 1 to 10, days 2 and 3 not days 11 to 21 and days 4 to 6 instead of days 22 to 697; I won't quarrel with the duration of the next 4 stages, so we can assume that the 7th and 8th steps take place on day 13920; but the 8th step is insufficiently lazy, instead of applying too much physics one can just reverse engineer dbcc timewarp and put oneself back to day 6.

Tom

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

Lynn Pettis (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:
Something seems wrong because CROSS APPLY and OUTER APPLY are available in SQL Server 2005.
Edit:
https://msdn.microsoft.com/en-us/library/ms177634(v=sql.90).aspx

CROSS APPLY works in 2005, but not CROSS APPLY (VALUES. I'm sure of this because we still have a SQL 2005 instance as well and it gets really annoying at times. :hehe:

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Ed Wagner (8/5/2015)
Lynn Pettis (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:
Something seems wrong because CROSS APPLY and OUTER APPLY are available in SQL Server 2005.
Edit:
https://msdn.microsoft.com/en-us/library/ms177634(v=sql.90).aspx
CROSS APPLY works in 2005, but not CROSS APPLY (VALUES. I'm sure of this because we still have a SQL 2005 instance as well and it gets really annoying at times. :hehe:

Beat me to it. VALUES was added in a later version.

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