Are the posted questions getting worse?
-
BWAAAAA-HAAAAA-HAAAAA!!! HOOOOOOIIIIIIEEEEE!!!!
I was in the process of submitting an article through the "Write for us" link and I saw the following at the top.
Considering what we just went through on this site, you understand why my reaction was...
"Yeah right... NFW!!!"
--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) -
Asking a similar question to "Are the posted questions getting worse", I have to ask "Are the posted questions getting fewer". I know it's summer time and the number of questions would typically drop off a bit in the summer and it could be just a perception but it seems to me like the question count has plummeted. It would be interesting to see the stats for Before'n'After the migration this site recently went through.
--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 wrote:
I've not actually had the "pleasure" of doing Windows Updates on our servers, Tom. That's a part of what our infrastructure team does.
I envy you that, Jeff. I'd be very glad to be able to ignore Windows Update and have someone else doing it for me. Back before I retired I always insisted on reviewing all MS updates (both OS and Database) to ensure that applying them wouldn't screw our customers, but I did use some of the support team to do any actual testing rather than testing myself - in those days the update came with documentation that told you what it did in reasonably detailed form, so it was much easier to cope with windows update then than it is now.
I followed the MS suggestion for fixing the problem (the one Iwas dubious about), and I think I now have everything up to date. But I'm appalled at what that damned update actually did when it finally worked: it deleted all SQL 2017 Server sysadmin and database creator privileges for all users, and also deleted all my databases that were built with SQL 2017 (leaving only the standard system databases). It presumably also upgraded SSMS 2017 security (that's what it said it did).
Fortunately I didn't have any database there that I didn't either have equivalents in my SQL 2016 storage or have a backup of (or both). And they are only toy databases anyway.
Tom
-
Lordy... even though your recovery was simple that still had to be a PITA to recover from, Tom.
As for me not doing the Windows updates... I agree. I'm the luckiest person on the planet. They won't let me do it even if I volunteer simply because it would be a security protocol violation. The DBA is classified as a "user" of Windows and nothing else. With the idea of separation of church'n'state, I'm simply not allowed.
For SQL Server, kind of the same thing exists... I'm not supposed to handle the SQL Server SP/CU things because that would mean that I'm handling too much in the area of security. In fact, the people in the infrastructure group are in the company that owns the company I work for and they did that because of that separation of Church'n'State thing I was talking about.
I DO, however, review all SP/CUs for SQL Server a make recommendations as to whether or not they should or should not install something. I forget what it was but there was an SP that I told them to NOT update because it wasn't ready from prime time (I think it was a 2012 CU) and told them to wait for SP3 and why... and they did.
--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) -
No pressure. None at all. Nope...
Just found out my Grace Hopper session information.
Session Name: CR119: Imposter Syndrome: Am I Ready to Mentor?
Session Location: Hyatt Plaza International Ballroom H
Session Start Time: 10/4/2019 1:00:00 PM
Session End Time: 10/4/2019 1:30:00 PM
Session Capacity: 1156
I've never spoken to an audience that big, but as they said in the email, just because the room's that big doesn't mean that many people will come. But still, they're anticipating a large audience for my presentation. They think it's that major of a topic.
No pressure at all... YIKES!
-
Weird. The first time I hit submit for the above post, it responded with "Error are you sure you want to do that?".
Not sure what in that post triggered that error as I was copying in text to the post and bolding a line.
-
You're going to blow it out of the park Brandie. Relax and have fun with it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
That's awesome Brandie. Congrats!!! You are going to crush it like you do everything else.
_______________________________________________________________
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/ -
I'm sure you'll do great. Looking forward to hearing how it goes.
-
Eell, Brandy, that look very much as I the organisers rate you very highly indeed. And they aren't stupid, so I'm sure they are right about that. You'll have a raging success.
Tom
-
Inquiring minds want to know, how many Threadzians are affected by this one?
-
Never used it in Britain, but I did use a EuroRail pass thirty years ago to travel around the continent. I wonder how many will stop going now altogether. I don't know the EU check for the chunnel for EU citizens, but there is one for sure for Americans. Kind of a pain, but didn't stop large crowds from using the train to go to Paris for a day.
- Brandie Tarvin wrote:
Inquiring minds want to know, how many Threadzians are affected by this one?
https://www.bbc.com/news/business-49263781%5B/quote%5D
I'm not sure that it's the kind of thing that will affect many people immediately. It's going to be more expensive and inconvenient for European residents planning trips to the UK in future but let's be honest, we'd shot ourselves in the foot with that one already. It makes it less likely that some tourists will travel by rail beyond London but InterRail is, if remember rightly, age limited so it's a bit of a niche market and I think overall numbers affected will be low.
It does appear to be an example of a country that makes a lot of money from tourism making it more difficult for tourists though.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
- Brandie Tarvin wrote:
Inquiring minds want to know, how many Threadzians are affected by this one?
https://www.bbc.com/news/business-49263781%5B/quote%5D
I've personally never done Interrailing but I know a couple of people at the office that have. Not sure as a Brit it'll really effect me (especially as I'm near London), but like Neil said this is more likely to effect Europeans wanting to go further afield than London when they visit the UK; and with Brexit inbound we're already going to be making it harder for them anyway so why not make it even harder again (headdesk).
I can see Edinburgh getting a hit from it, as that's quite touristy and obviously has a direct rail link from London. York perhaps, as there's a lot of heritage there. Not sure about Manchester or Liverpool, as I've actually never visited. There's always a lot of tourists when I visit the Lake District but the majority tend to be from Asian countries, not European (and you really need a car or bus tour to get around there).
Due to where the UK is, I can very much see that it is going to likely be at the "end" of your journey, or you'll likely going to just hit London (as otherwise you have to travel both up and down the country to move on), so perhaps those that would have visited further afield in the country will just go further across in Europe (i.e. into Spain and West France, if they were coming from the East).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
I'd like to go back to the Fringe Festival next year, so maybe this will lower the crowds 😉
Viewing 15 posts - 63,871 through 63,885 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply