Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,376 through 9,390 (of 59,099 total)

Reply To: Are the posted questions getting worse?

WayneS wrote:
Jeff Moden wrote:
I've done something rather rare but well deserved for me... I'm finally going to use some (a lot, actually) very well deserved "stay-cation" time this year. I've...
--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)

May 7, 2019 at 2:24 am

#3636834
Reply To: Are the posted questions getting worse?

BTW and while we're on the subject...
They say that old people don't get enough exercise. As I've gotten older, I've found that's simply not true. Mother Nature has a plan...
--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)

May 7, 2019 at 12:22 am

#3636790
Reply To: Are the posted questions getting worse?

Greg Edwards-268690 wrote:
Jeff - The fishing buddy from Detroit has a ‘shotgun plunger’. That statement might be made in jest, but if Doug says that, it would be like pulling a...
--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)

May 7, 2019 at 12:18 am

#3636787
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
Phil Parkin wrote:
Greg Edwards-268690 wrote:
... Right now, my priority is to wait a few more days for the water to warm up. Predicting some time to relax and pull in some...
--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)

May 6, 2019 at 9:34 pm

#3636708
Reply To: Are the posted questions getting worse?

Sergiy wrote:
I don't know what's the internet and how to unbreak it, but I could participate mostly on the go, from my Apple mobile devices. previous upgrade made it very...
--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)

May 6, 2019 at 9:32 pm

#3636706
Reply To: Are the posted questions getting worse?

Greg Edwards-268690 wrote:
More like scrambled the internet. Unfortunately the upgrade turned into Whack A Mole. One thing to break external links, and a whole different one to lose internal stuff. Reconfirms...
--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)

May 6, 2019 at 9:29 pm

#3636705
Reply To: Are the posted questions getting worse?

Ed Wagner wrote:
Sean Lange wrote:
Ed Wagner wrote:
Luis Cazares wrote:
Brandie Tarvin wrote:
I don't have a Stack Overflow account, let alone a 50 rep on the site. Since the topic is still open, maybe could someone able...
--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)

May 6, 2019 at 7:53 pm

#3636647
Reply To: SQL Capacity planning

Step 1 would be to determine if you have any capacity problems with your existing system. 😉
--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)

May 6, 2019 at 7:50 pm

#3636646
Reply To: Dos and Don'ts of Dynamic SQL

TomD-982312 wrote:
Like the article. I'd like to point to the fact that "PRINT @sql;" is limited to 4000 characters, therefore I use "SELECT CAST('<root><![CDATA[' + @sql + ']]></root>' AS XML)".
So...
--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)

May 6, 2019 at 7:41 pm

#3636630
Reply To: Status Update 2 May 2019

Thanks Steve.
--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)

May 6, 2019 at 11:30 am

#3636351
Reply To: Fixate the Menu bar

How about we get things like attachments on the articles fixed first? That and continue to "fix the internet". I've come across many links in Google to posts on SSC...
--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)

May 4, 2019 at 12:58 am

#3634887
Reply To: Maintenance Plan

Or create a third job that calls a new proc that calls the stored procedures that you're using in the other two jobs.
--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)

May 4, 2019 at 12:49 am

#3634881
Reply To: Interview question

Phil Parkin wrote:
I agree that this is a horrid idea.
Heh... yeah.. me too. I hate SSIS. 😀 😀 😀

Phil Parkin wrote:
It is, however, pretty easy to solve.
Totally agreed... write a good stored...
--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)

May 4, 2019 at 12:11 am

#3634863
Reply To: Number of Mondays between two dates

Sergiy wrote:
Look at the progress we've got in SQL over the years! what used to be 13 years ago a short inline formula using system functions and integer arithmetic is...
--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)

May 4, 2019 at 12:01 am

#3634855
Reply To: Status Update 2 May 2019

It would be interesting to see what the backlogged items are and the expected fix release date.
--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)

May 3, 2019 at 11:52 pm

#3634851

Viewing 15 posts - 9,376 through 9,390 (of 59,099 total)