Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 66,106 through 66,120 (of 66,815 total)

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

David Burrows SSC Guru Points: 65144 More actions · Answer 1

Jeff Moden wrote:

Eirikur Eiriksson wrote:
Happy new year everyone! 😎 May the source be with you 😉
Same to you, ol' friend. Glad I got to know you and others from this site. Missed seeing you on the Friday night call this past weekend.

Happy new year to you both 😀

Hope the year goes well for you 👍

Far away is close at hand in the images of elsewhere.
Anon.

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

David Burrows wrote:

Jeff Moden wrote:
Eirikur Eiriksson wrote:
Happy new year everyone! 😎 May the source be with you 😉
Same to you, ol' friend. Glad I got to know you and others from this site. Missed seeing you on the Friday night call this past weekend.
Happy new year to you both 😀
Hope the year goes well for you 👍

Good to "see" you David! We've never met but we've know each other "forever". Here's to you and yours.

--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)

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 3

David Burrows wrote:

Jeff Moden wrote:
Eirikur Eiriksson wrote:
Happy new year everyone! 😎 May the source be with you 😉
Same to you, ol' friend. Glad I got to know you and others from this site. Missed seeing you on the Friday night call this past weekend.
Happy new year to you both 😀
Hope the year goes well for you 👍

Happy new year David, good to "see" you are still around 😉

😎

Would be good to meet up, been far too long!

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 4

Steve Jones - SSC Editor

SSC Guru

Points: 738609

January 3, 2023 at 6:17 pm

#4133154

Happy New Year, everyone, and welcome to 2023!

Steve Collins SSCrazy Points: 2227 More actions · Answer 5

Steve Jones - SSC Editor wrote:

Happy New Year, everyone, and welcome to 2023!

HNY SSC! Thank you Steve for being a great host. All the things 😉

Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 6

Steve Jones - SSC Editor wrote:

Happy New Year, everyone, and welcome to 2023!

Thanks, Steve, and thanks for taking care of this Website and all that you do for the community!

--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)

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 7

Happy top o' 2023 to all!

I've been absent from these forums for a decent bit (life has been interesting, but not too interesting), but I'm hoping to pop in a bit more this year.

Good to see a lot of the "old guard" still taking care of business.

Cheers!

Ant-Green SSC Guru Points: 113563 More actions · Answer 8

@steve-2 / @Grant / @Webmaster

I guess you already know this, but the ASK site is broken at the moment as the license to the software looks to have expired.

Your License Has Expired

The license you currently have installed for this TeamHub site has expired. Please contact sales@answerhub.com to extend your evaluation or purchase a new license.

Cheers

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 9

Thanks, submitted a ticket. I never go over there, so I wasn't aware.

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 10

I have been having the worst time with this website on my work PC for the past 9 months. Couldn't log in (and login screen looked weird). When I did log in, got blank pages for forums, etc. Tried this on Edge, tried it on Chrome. Nothing worked.

Occasionally I try on and off to see if I can get it fixed, but nothing. Until today when I changed Edge to IE 11 mode AND compatability mode. FINALLY I can see and post. Login page still looks weird, though.

Hello, everyone. Long time no talk. I'm keeping up with the emails from this thread but was unable to respond until now. Happy New Year!

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.

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

Brandie Tarvin wrote:

I have been having the worst time with this website on my work PC for the past 9 months. Couldn't log in (and login screen looked weird). When I did log in, got blank pages for forums, etc. Tried this on Edge, tried it on Chrome. Nothing worked.
Occasionally I try on and off to see if I can get it fixed, but nothing. Until today when I changed Edge to IE 11 mode AND compatability mode. FINALLY I can see and post. Login page still looks weird, though.
Hello, everyone. Long time no talk. I'm keeping up with the emails from this thread but was unable to respond until now. Happy New Year!

Congrats, Brandie. Considering the rough time you had getting it to work in your browser, I'd advise you to mentally prepare yourself before you try to post any code. I haven't posted any in quite some time. The last time I tried, I struggled to get it to look decent and finally just added an apology for the formatting.

This reply was modified 2 years, 8 months ago by Ed Wagner.

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

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 12

SGAB, I had high hopes for the new GENERATE_SERIES() function in 2022, which I finally took the time to download the Developers Edition for and install. Things were looking promising for generation a single large series. For a million rows, here's the stats compared to one of my simpler fnTally functions...

--===== GENERATE_SERIES()

SQL Server Execution Times:

CPU time = 593 ms, elapsed time = 187 ms.

--===== fnTally16()

SQL Server Execution Times:

CPU time = 765 ms, elapsed time = 252 ms.

But, then I had each do a crossapply of 0 to9 row expansions a million times (about 5.5 million rows in the result) and fnTally16() is about 25% quicker on both fronts.

--===== GENERATE_SERIES()

SQL Server Execution Times:

CPU time = 7769 ms, elapsed time = 824 ms.

--===== fnTally16()

SQL Server Execution Times:

CPU time = 4608 ms, elapsed time = 619 ms.

That's not an Earth-Shattering difference. It's certainly not enough for me to poo-poo the use of GENERATE_SERIES() to others but 1) I am disappointed a bit and 2) I won't be using it myself. 🙁 It might make for an "SQL Spackle" article.

Up next, Eirikur's 2012 version of DelimitedSplit8K against the (hopefully) improved version of STRING_SPLIT(). I have a funny feeling the results are going to be similar. I'll also check to see if it has a performance penalty when spliting BLOBs.

--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: 95461 More actions · Answer 13

Jeff Moden wrote:

SGAB,....

Okay, I give up. What is SGAB?

Let me know if you need any help with your testing. You know I like this kind of stuff.

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

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 14

WayneS wrote:

Jeff Moden wrote:
SGAB,....
Okay, I give up. What is SGAB?

It's the initials from a phrase I use a lot... "Shifting gears a bit". 😀 Hopefully, you derived what I mean when I say that. 😀 Who knows... maybe it'll catch on like RBAR did. 😀

WayneS wrote:

Let me know if you need any help with your testing. You know I like this kind of stuff.

Most definitely. Thanks for the offer.

--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)

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 15

So, I could use some help on this one: To Drop or Not to Drop (the temp table question) – SQLServerCentral Forums

I've tried Googling it but not finding exactly what this person is talking about.

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.