Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,001 through 12,015 (of 59,095 total)

RE: Are the posted questions getting worse?

jasona.work - Tuesday, June 26, 2018 11:59 AM
Jeff Moden - Tuesday, June 26, 2018 11:46 AM
--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)

June 26, 2018 at 12:32 pm

#1995350
RE: When it comes to salaries, I'm not average

Eric M Russell - Tuesday, June 26, 2018 12:09 PM
Jeff Moden - Tuesday, June 26, 2018...
--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)

June 26, 2018 at 12:30 pm

#1995349
RE: Are the posted questions getting worse?

jonathan.crawford - Tuesday, June 26, 2018 11:34 AM
We have a trip planned for 4th of July which has been planned for 9...
--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)

June 26, 2018 at 11:46 am

#1995337
RE: Help in writing query for update

KGNH - Tuesday, June 26, 2018 6:04 AM
Thank you all for your responses. I got my result from your suggestions.
Hopefully, it doesn't...
--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)

June 26, 2018 at 11:31 am

#1995334
RE: TempDB

Just to add my 2 cents...
If you need a relatively large TEMPDB (regardless of the number of files that it may be configured as), you may have 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)

June 26, 2018 at 11:25 am

#1995333
RE: When it comes to salaries, I'm not average

xsevensinzx - Tuesday, June 26, 2018 10:19 AM
If you disqualify them for the job over it, then you are saying they are...
--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)

June 26, 2018 at 11:00 am

#1995330
RE: When it comes to salaries, I'm not average

Sean Lange - Tuesday, June 26, 2018 9:51 AM
Eric M Russell - Tuesday, June 26, 2018 8:11...
--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)

June 26, 2018 at 10:15 am

#1995320
RE: When it comes to salaries, I'm not average

Andy Warren - Tuesday, June 26, 2018 9:42 AM
Jeff, following up a little, my view is that if everyone started using this...
--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)

June 26, 2018 at 9:58 am

#1995316
RE: When it comes to salaries, I'm not average

Eric M Russell - Tuesday, June 26, 2018 8:11 AM
Sean Lange - Monday, June 25, 2018 7:26...
--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)

June 26, 2018 at 9:56 am

#1995315
RE: Warning: No Join Predicate (Nested Loop)

Chris Harshman - Monday, June 25, 2018 9:53 AM
alex.sqldba - Friday, June 22, 2018 4:57 PM
--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)

June 26, 2018 at 8:53 am

#1995307
RE: Restored database from 2012 to 2017 - a table was slow as a snail to query, until I recreated it with another name - what gives?

Since things worked fine after rebuilding the table, in this case, I'm thinking that it has nothing to do with the change in the cardinality estimator.
--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)

June 26, 2018 at 7:37 am

#1995287
RE: How to read list of files in folder using T-SQL?

Sergiy - Monday, June 25, 2018 6:35 PM
May be awesome, but still adding no value to the product.
It's may appear useful...
--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)

June 25, 2018 at 10:12 pm

#1995225
RE: Warning: No Join Predicate (Nested Loop)

heb1014 - Monday, June 25, 2018 7:34 AM
It's a recruiting/staffing application. I know the schema 😉
Got it. Thanks.
--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)

June 25, 2018 at 8:32 am

#1995163
RE: When it comes to salaries, I'm not average

Sean Lange - Monday, June 25, 2018 7:26 AM
We require our developers to do almost all of their own t-sql. The...
--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)

June 25, 2018 at 8:27 am

#1995161
Reply To: How to read list of files in folder using T-SQL?

ThomasRushton - Monday, June 25, 2018 7:20 AM
I know this was a followup to an old SQL2008 question, but, if you're running SQL 2017, check...
--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)

June 25, 2018 at 8:08 am

#1995157

Viewing 15 posts - 12,001 through 12,015 (of 59,095 total)