Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

I've never been to Columbus, OH before. Any recommendations for a hotel near the SQL Saturday there?
Never mind. I've booked the Hilton Polaris for Friday and Saturday...
--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:18 pm

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

ZZartin - Tuesday, June 26, 2018 3:56 PM
xsevensinzx - Tuesday, June 26, 2018 3:28 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 7:02 pm

#1995400
RE: Are the posted questions getting worse?

Michael L John - Tuesday, June 26, 2018 6:12 PM
jasona.work - Tuesday, June 26, 2018 12:47 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 6:58 pm

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

By the same token, if someone claims that they have "10 years of experience developing stored procedures, functions, and triggers in SQL Server" and they can't answer the super simple...
--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 2:06 pm

#1995370
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

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