Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 56,596 through 56,610 (of 66,000 total)

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

jasona.work SSC Guru Points: 50021 More actions · Answer 1

jasona.work

SSC Guru

Points: 50021

November 15, 2016 at 7:55 am

#1912518

Cool!

Hmm, now to plan a Mexican vacation with the wife...

😀

Ed Wagner SSC Guru Points: 287015 More actions · Answer 2

Y.B. (11/15/2016)

My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to expect other than rocks in the middle of nowhere. However, once you get there and monkeys are swinging from the trees and you come around the clearing...well you can't help but think "damn, this isn't something you see everyday!"

I'd thought I'd share a few images. These pyramids/ruins are at Chacchoben which are a far cry from the likes of Giza or Chichen Itza (I can imagine). All the same It was pretty cool to see and experience. :w00t:

Here is an areal shot from wiki: https://en.wikipedia.org/wiki/Chacchoben#/media/File:Chacchoben.JPG

Now that is very cool. It's a trip I hope to do someday. Thanks for sharing.

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

jasona.work SSC Guru Points: 50021 More actions · Answer 3

Grant Fritchey (11/15/2016)

VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

If I recall, though, to give the poor guy a break, this did come from an Oracle to SQL conversion on a very tight timetable and he wasn't the original architect of the Oracle side...

At least it's using datetime to store date information!

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

Grant Fritchey (11/15/2016)

VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

Even better when it is defined as NOT NULL and has a constraint to enforce > ''

😛

_______________________________________________________________

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/

Luis Cazares SSC Guru Points: 183686 More actions · Answer 5

Y.B. (11/15/2016)

My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to expect other than rocks in the middle of nowhere. However, once you get there and monkeys are swinging from the trees and you come around the clearing...well you can't help but think "damn, this isn't something you see everyday!"

I'd thought I'd share a few images. These pyramids/ruins are at Chacchoben which are a far cry from the likes of Giza or Chichen Itza (I can imagine). All the same It was pretty cool to see and experience. :w00t:

Here is an areal shot from wiki: https://en.wikipedia.org/wiki/Chacchoben#/media/File:Chacchoben.JPG

Yes, the Mayans built a great civilization in the middle of the Jungle. That's just a part of what made them amazing. 🙂 I really love when people are excited after visiting my country. There are so many places that will amaze anyone.

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

Y.B. SSChampion Points: 11572 More actions · Answer 6

Ed Wagner (11/15/2016)

Y.B. (11/15/2016)

My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to expect other than rocks in the middle of nowhere. However, once you get there and monkeys are swinging from the trees and you come around the clearing...well you can't help but think "damn, this isn't something you see everyday!"

I'd thought I'd share a few images. These pyramids/ruins are at Chacchoben which are a far cry from the likes of Giza or Chichen Itza (I can imagine). All the same It was pretty cool to see and experience. :w00t:

Here is an areal shot from wiki: https://en.wikipedia.org/wiki/Chacchoben#/media/File:Chacchoben.JPG

Now that is very cool. It's a trip I hope to do someday. Thanks for sharing.

My pleasure...I even had the opportunity to visit Chichen Itza on the same trip from Cozumel. However, it was a 10 hour round trip from the port and it would have cut it close to when the ship was set to depart. I was a little uneasy with the chance of watching the ship leave without me. lol

I'll have to head back some day.

SELECT quote FROM brain WHERE original = 1
0 rows returned

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

Eirikur Eiriksson

SSC Guru

Points: 182631

November 15, 2016 at 8:34 am

#1912546

Grant Fritchey (11/15/2016)

VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

Even better when the length isn't specified.

😎

DECLARE @BONKERS VARCHAR = 'ABCDE';

SELECT @BONKERS;

----

A

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 8

That pyramid looks amazing.

BTW, I'll be going on SQL Cruise in January. It's stopping at Cozumel. Who wants to go see the pyramid with me?

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Hugo Kornelis SSC Guru Points: 64748 More actions · Answer 9

Grant Fritchey (11/15/2016)

VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

Really? Even better than NVARCHAR(MAX) CHECK (Column IN (N'Y', N'N'))?

EDIT: ... or NCHAR(1000) CHECK (Column IN (N'Y', N'N'))

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Eirikur Eiriksson SSC Guru Points: 182631 More actions · Answer 10

Y.B. (11/15/2016)

My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to expect other than rocks in the middle of nowhere. However, once you get there and monkeys are swinging from the trees and you come around the clearing...well you can't help but think "damn, this isn't something you see everyday!"

I'd thought I'd share a few images. These pyramids/ruins are at Chacchoben which are a far cry from the likes of Giza or Chichen Itza (I can imagine). All the same It was pretty cool to see and experience. :w00t:

Here is an areal shot from wiki: https://en.wikipedia.org/wiki/Chacchoben#/media/File:Chacchoben.JPG

It is well worth seeing, the only thing kind of awkward was the fact that the Mayans were considerably shorter than I so I had to bend backwards when entering the ruins.

😎

Y.B. SSChampion Points: 11572 More actions · Answer 11

Grant Fritchey (11/15/2016)

That pyramid looks amazing.

BTW, I'll be going on SQL Cruise in January. It's stopping at Cozumel. Who wants to go see the pyramid with me?

Awesome! I do have some advice...as I mentioned heading to Chichen Itza was a 10 hour round trip excursion from Cozumel. Cruise ships have and will leave without you if you don't make it back in time. That being said most cruise ships offer these excursions directly on board (or can be booked ahead of time). They will be more expensive than if you just walked off the pier and booked the same tour directly with the local provider. The upside is that they (at least Royal Caribbean did) guarantee that you will make it back on board. What this involves I'm not sure...maybe they wait, or send transportation if something like a breakdown happens, who knows? Either way that's not a 'bus' you want to miss.

SELECT quote FROM brain WHERE original = 1
0 rows returned

Luis Cazares SSC Guru Points: 183686 More actions · Answer 12

Y.B. (11/15/2016)

Grant Fritchey (11/15/2016)

That pyramid looks amazing.

BTW, I'll be going on SQL Cruise in January. It's stopping at Cozumel. Who wants to go see the pyramid with me?

Awesome! I do have some advice...as I mentioned heading to Chichen Itza was a 10 hour round trip excursion from Cozumel. Cruise ships have and will leave without you if you don't make it back in time. That being said most cruise ships offer these excursions directly on board (or can be booked ahead of time). They will be more expensive than if you just walked off the pier and booked the same tour directly with the local provider. The upside is that they (at least Royal Caribbean did) guarantee that you will make it back on board. What this involves I'm not sure...maybe they wait, or send transportation if something like a breakdown happens, who knows? Either way that's not a 'bus' you want to miss.

And remember that Cozumel is an island, so you'll need a ferry to get to/from Playa del Carmen. I'm not sure if the tours will have a special transportation, but I'd be glad to ask a friend who lives there if you want more information.

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

Steve Jones - SSC Editor SSC Guru Points: 728159 More actions · Answer 13

Y.B. (11/15/2016)

My pleasure...I even had the opportunity to visit Chichen Itza on the same trip from Cozumel. However, it was a 10 hour round trip from the port and it would have cut it close to when the ship was set to depart. I was a little uneasy with the chance of watching the ship leave without me. lol

I'll have to head back some day.

My vacation there:

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Y.B. SSChampion Points: 11572 More actions · Answer 14

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try an Irish Cheddar which was excellent. I like something with a stronger flavor profile when it comes to cheeses...Asiago, Swiss, Oka. Although I did stray a little too far once and bought some Stinton. Ooooh boy that was something else...acquired taste for sure. Well for me anyway.

SELECT quote FROM brain WHERE original = 1
0 rows returned

JustMarie SSCertifiable Points: 7771 More actions · Answer 15

Grant Fritchey (11/15/2016)

VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

Personally I like the NVARCHAR(1) fields. Those make me realize the level of understanding of the person who made the database.

Behind that one is the series of VARCHAR(50) showing they just took the defaults without thinking about the field use.

Good times...