Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 61,531 through 61,545 (of 66,712 total)

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

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 1

I have this query that uses the same code over and over and I'm thinking putting it in a view because it will OBVIOUSLY run faster. Anybody have any idea what the ancient Greek poets would think about that?

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 2

jonathan.crawford - Monday, May 14, 2018 4:23 PM
Anybody going to be at sqlsaturday 736 in Columbus?

I'm getting ready to submit a dual session. Have just a couple of days left to do so. If it's accepted, I'll be there.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 3

jonathan.crawford - Monday, May 14, 2018 4:25 PM
I have this query that uses the same code over and over and I'm thinking putting it in a view because it will OBVIOUSLY run faster. Anybody have any idea what the ancient Greek poets would think about that?

Heh... views do get a bad rap. Like anything else, "It Depends" on how they're written.

That, notwithstanding, if you're trying to justify the purchase of more memory, SSDs, faster spinning disks, and the Enterprise Edition of SQL Server, there's nothing like a collection of cascading views and mTVFs to slow things down enough to easily justify such things. Of course, you'll be found out after the purchases when they find out the additional hardware did nothing for performance. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

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

jonathan.crawford - Monday, May 14, 2018 4:25 PM
I have this query that uses the same code over and over and I'm thinking putting it in a view because it will OBVIOUSLY run faster. Anybody have any idea what the ancient Greek poets would think about that?

Ha!

"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

BrainDonor SSCoach Points: 19254 More actions · Answer 5

Over the years I've seen a lot of threads where people complain that they're backups are invalid, just when they need them. I'm not having a lot of luck digging any of these out - does anybody know of a couple of examples?
It's for an article I'm putting together on why you need to test backups.

Steve Hall
Linkedin
Blog Site

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 6

jonathan.crawford - Monday, May 14, 2018 4:23 PM
Anybody going to be at sqlsaturday 736 in Columbus?

likely not. I may do Louisville, but vacation plans are up in the air. Trying not to kill myself over the summer.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 7

BrainDonor - Tuesday, May 15, 2018 2:01 AM
Over the years I've seen a lot of threads where people complain that they're backups are invalid, just when they need them. I'm not having a lot of luck digging any of these out - does anybody know of a couple of examples?
It's for an article I'm putting together on why you need to test backups.

https://www.youtube.com/watch?v=8dhp_20j0Ys

BrainDonor SSCoach Points: 19254 More actions · Answer 8

Steve Jones - SSC Editor - Tuesday, May 15, 2018 4:01 AM
https://www.youtube.com/watch?v=8dhp_20j0Ys

Thanks Steve, I'd forgotten about that classic.

Steve Hall
Linkedin
Blog Site

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 9

BrainDonor - Tuesday, May 15, 2018 2:01 AM
Over the years I've seen a lot of threads where people complain that they're backups are invalid, just when they need them. I'm not having a lot of luck digging any of these out - does anybody know of a couple of examples?
It's for an article I'm putting together on why you need to test backups.

Here are a few I wrote about a while back.

"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

BrainDonor SSCoach Points: 19254 More actions · Answer 10

Grant Fritchey - Tuesday, May 15, 2018 5:18 AM
Here are a few I wrote about a while back.

Pure gold - thank you.

Steve Hall
Linkedin
Blog Site

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

Ed Wagner - Friday, May 11, 2018 5:32 AM
Jeff Moden - Thursday, May 10, 2018 10:55 PM
Man, I'm in 7th heaven tonight. Chris Morris was taking a vacation in Florida with some friends that live there and he flew up here today to see myself and Ed Wagner. What an incredible treat and a huge check mark on my bucket list to meet the man in person and have several hours of conversation with him. Absolutely incredible.
Yeah, that was a very fun evening. I think one of coolest parts of the SQL Server community is the interesting people. Getting to actually meet him in person was a real treat.

Aw, you guys are too nice! This was the best part of my whole holiday by a wide margin, meeting you two (and some of your group) and sharing a few beers and stories. For those many folks out there who haven't seen Jeff talk, it's every bit as good as you would expect - interesting, fact-filled, littered with amusing colloquialisms. It was well worth the trip for the talk alone; spending some time with Jeff and Ed before and afterwards made the whole deal an absolutely unforgettable experience. Thank you so much guys.

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

Jeff Moden - Friday, May 11, 2018 7:20 AM
Eirikur Eiriksson - Friday, May 11, 2018 5:58 AM
Jeff Moden - Thursday, May 10, 2018 10:55 PM
Man, I'm in 7th heaven tonight. Chris Morris was taking a vacation in Florida with some friends that live there and he flew up here today to see myself and Ed Wagner. What an incredible treat and a huge check mark on my bucket list to meet the man in person and have several hours of conversation with him. Absolutely incredible.
I trust Jeff that you produced enough beer popsicles for my friend 😀
😎
Like Ed said, no popsicles (I gave the dust bunnies the day off) but he found a beer that he liked. I think better than that, though, he had a hamburger at Red Robin that he described as "fantastic". It was the "Southern Charm" burger and it apparently made his tongue throw a party for his mouth.

Haha yeah that was amazing! And your beers have evolved in leaps and bounds in recent years 🙂

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

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 13

ChrisM@Work - Tuesday, May 15, 2018 7:05 AM
Ed Wagner - Friday, May 11, 2018 5:32 AM
Jeff Moden - Thursday, May 10, 2018 10:55 PM
Man, I'm in 7th heaven tonight. Chris Morris was taking a vacation in Florida with some friends that live there and he flew up here today to see myself and Ed Wagner. What an incredible treat and a huge check mark on my bucket list to meet the man in person and have several hours of conversation with him. Absolutely incredible.
Yeah, that was a very fun evening. I think one of coolest parts of the SQL Server community is the interesting people. Getting to actually meet him in person was a real treat.
Aw, you guys are too nice! This was the best part of my whole holiday by a wide margin, meeting you two (and some of your group) and sharing a few beers and stories. For those many folks out there who haven't seen Jeff talk, it's every bit as good as you would expect - interesting, fact-filled, littered with amusing colloquialisms. It was well worth the trip for the talk alone; spending some time with Jeff and Ed before and afterwards made the whole deal an absolutely unforgettable experience. Thank you so much guys.

Heh... as I tell people. We aim to please... we sometimes miss but we're always aiming. 😀 Thanks again, Chris.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

WayneS SSC Guru Points: 95460 More actions · Answer 14

Anyone down in the Mobile, AL area? I'll be down there next week - it would be nice to meet up with you!

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

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

And someone new to ssc gets Celkoed. I really wish he would just go a way. Now.