Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 48,901 through 48,915 (of 66,712 total)

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

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

rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
I sent the link around the lads here. One of them sent the picture back with ticks on the ships he's flown 😉
Nice 😀
So how is life treating you Chris?
Rodders...

Hiya Rodders, I'm back at this place again, see if you can guess who it is: (.)(.) ( )( )

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

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

rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
I sent the link around the lads here. One of them sent the picture back with ticks on the ships he's flown 😉
Nice 😀
So how is life treating you Chris?
Rodders...

And right back at you...

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

rodjkidd SSCoach Points: 15915 More actions · Answer 3

ChrisM@Work (6/16/2015)
rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
I sent the link around the lads here. One of them sent the picture back with ticks on the ships he's flown 😉
Nice 😀
So how is life treating you Chris?
Rodders...
And right back at you...

Yes I think you mentioned it a while ago!

Me - OK. Back from Edinburgh after helping out with the SQL Sat. Extended until October here in Reading. Looking to move Midlands / Leciestershire way either later this year or early next, so let me know if they are looking 😉 - I never realized they were based in Leamington Spa. 😀

Rodders...

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

rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
rodjkidd (6/16/2015)
ChrisM@Work (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
I sent the link around the lads here. One of them sent the picture back with ticks on the ships he's flown 😉
Nice 😀
So how is life treating you Chris?
Rodders...
And right back at you...
Yes I think you mentioned it a while ago!
Me - OK. Back from Edinburgh after helping out with the SQL Sat. Extended until October here in Reading. Looking to move Midlands / Leciestershire way either later this year or early next, so let me know if they are looking 😉 - I never realized they were based in Leamington Spa. 😀
Rodders...

They're currently looking for a permy DBA, if you know of anyone in the area. Christian B still looks after architecture and Rich D comes in from time to time to assist, but I don't think they'll be looking for more contractors for a while.

This gig finishes in 5 weeks, any crumbs left in Reading? The commute is killing me, 3 1/2 hours a day!

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

rodjkidd SSCoach Points: 15915 More actions · Answer 5

Chris,

Ask Alex Whittles about any DBA's in the area looking. I get the Midlands job alert he / the User Group set up. So worth asking him to add it the mailing list. They also have a UG coming up soon - SSIS focused thought - Steph Middleton is presenting.

This place doesn't want any extra contractors - only looking for perm.

I've had a few agency people LinkedIn recently but no follow up emails. Always assumed they would have a job they wanted to tout hence the LinkedIn request. The alternative is they are thinking ahead - scary thought!

But if I hear of anything I'll let you know.

Avis might be looking? Can always ask MPM?

Rodders...

Brandie Tarvin SSC Guru Points: 173056 More actions · Answer 6

Ed Wagner (6/10/2015)
djj (6/10/2015)
Caught a stone on my way home with my new (to me) truck. Did not crack that day but I noticed it a week later. Only $100 out of pocket for windshield even though my deductible is $500.
Some states have different deductibles for glass breakage and cover it under the "comprehensive" category on your car insurance. The collision coverage is the expensive and the one that has the greatest impact on your premiums when you raise your deductible. I found that the $2 a year saved by having a high deductible on comprehensive wasn't worth it.

Some states actually have laws requiring insurance companies to replace windshields (Florida) because of the visibility issues. In cases like that, there is little-to-no deductible.

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.

Brandie Tarvin SSC Guru Points: 173056 More actions · Answer 7

BWFC (6/15/2015)
Apparently it was only filmed that way because Harrison Ford had eaten something that disagreed with him and didn't want to spend too long away from his trailer. The original intent was for a much longer fight.

Ford actually had malaria at the time. That's why he was sweating so much. They'd refilmed that sequence a few times and he was sick and tired, so just shot the sword guy. The other actor was so good that he just went with it. Hence the reason the scene was good enough to keep.

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.

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

So, been playing with using Extended Events to track use of deprecated features before we migrate to SQL2012. I'll admit to cheating and creating the session in SQL2012 then scripting it out and "tweaking" it to work in SQL2008R2. That part was easy.

The fun part was figuring out how to query the XML data for what I want, rather than trying to read the XML directly.

Now to continue to putter around with xQuery / xPath to get it formatted even better...

Brandie Tarvin SSC Guru Points: 173056 More actions · Answer 9

jasona.work (6/16/2015)
So, been playing with using Extended Events to track use of deprecated features before we migrate to SQL2012. I'll admit to cheating and creating the session in SQL2012 then scripting it out and "tweaking" it to work in SQL2008R2. That part was easy.
The fun part was figuring out how to query the XML data for what I want, rather than trying to read the XML directly.
Now to continue to putter around with xQuery / xPath to get it formatted even better...

Jason, stop making the rest of us look lazy and bad!

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.

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

Brandie Tarvin (6/16/2015)
jasona.work (6/16/2015)
So, been playing with using Extended Events to track use of deprecated features before we migrate to SQL2012. I'll admit to cheating and creating the session in SQL2012 then scripting it out and "tweaking" it to work in SQL2008R2. That part was easy.
The fun part was figuring out how to query the XML data for what I want, rather than trying to read the XML directly.
Now to continue to putter around with xQuery / xPath to get it formatted even better...
Jason, stop making the rest of us look lazy and bad!

Nah, most of the xQuery / xPath were based on examples from other sites. I'll admit, the .value method took me a while to figure out, but I've at least got the ground floor now...

Now, if I wanted to make folks look bad, I'd say we're migrating to SQL2016 already...

:hehe:

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

Gail, thanks for stepping in on that other thread.

TomThomson SSC Guru Points: 104773 More actions · Answer 12

dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.

Why no Dahak?

Tom

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

TomThomson (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
Why no Dahak?

I couldn't even find the Millenium Falcon.

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

Dwain Camps SSC Guru Points: 86948 More actions · Answer 14

Luis Cazares (6/16/2015)
TomThomson (6/16/2015)
dwain.c (6/15/2015)
Here's one for the hard-core Sci-Fi fans out there:
Size Comparison - Science Fiction Spaceships
Count me among 'em.
Why no Dahak?
I couldn't even find the Millenium Falcon.

Wiki lists the Millennium Falcon at 34.75 meters in length, so in the scale of the image that is a mere 3.5 pixels. I suspect it was left off for fear it may be mistaken as a speck of dust.

I am unfamiliar with "Dahak" as a ship.

No doubt there are many others omitted. But you gotta admire the work and attention to detail that went into this.

Note: I am now reading Starhammer (Christopher Rowley) which somehow escaped my attention many years ago when I discovered the Vang.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 15

dwain.c (6/16/2015)
I am unfamiliar with "Dahak" as a ship.

The ship whose controlling AI (also called Dahak, of course) is one of the principal characters in David Weber's 3 volume Dahak series. It's a spherical ship, 2159 miles in diameter.

Tom