Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,206 through 20,220 (of 59,098 total)

RE: The New DBA

Steve Jones - SSC Editor (6/30/2015)
GoofyGuy (6/30/2015)
None of the following are technical questions, they're just simple and conversational, but they reveal a lot.
One question I often ask is, 'What 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 30, 2015 at 3:45 pm

#1809328
RE: free tempdb

Add more disk.
--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 30, 2015 at 3:37 pm

#1809324
RE: Query with linked server works until where clause added

Shot in the dark but I'm pretty sure that anything having to do with Oracle parts of the query must all be in upper case.
--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 30, 2015 at 3:35 pm

#1809322
RE: How to make actual execution plan better?

GilaMonster (6/30/2015)
Jeff Moden (6/30/2015)
It seems like a lot of folks don't understand that a non-clustered index is a duplication of data that not only affects queries and space on disk...
--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 30, 2015 at 1:18 pm

#1809276
RE: The Importance of Our Work

Heh... You post such an editorial quite frequently, Steve. Are you reminding us... or you? 🙂
--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 30, 2015 at 12:32 pm

#1809265
RE: Count of consecutive years of participation (islands and gaps)

OLSONEJ (6/30/2015)
My apologies, I was not aware of the business rules previously as it had to be decided upon since we are rebuilding something that previously existed. Same reason...
--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 30, 2015 at 11:45 am

#1809248
RE: The New DBA

Eric M Russell (6/30/2015)
Jeff Moden (6/30/2015)
Eric M Russell (6/30/2015)
Jeff Moden (6/29/2015)
...
As some of you may know, I've interviewed a lot of folks for the position of "Sr. Developer" and "Sr....
--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 30, 2015 at 11:38 am

#1809245
RE: How to make actual execution plan better?

GilaMonster (6/30/2015)
The index Jason suggests essentially duplicates the table, it has all columns in either key or include. Since for the query in question, the key lookup is fine, there's...
--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 30, 2015 at 11:27 am

#1809239
RE: The New DBA

Eric M Russell (6/30/2015)
Jeff Moden (6/29/2015)
...
As some of you may know, I've interviewed a lot of folks for the position of "Sr. Developer" and "Sr. Database Administrator" over the last...
--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 30, 2015 at 8:04 am

#1809142
RE: Need Ammunition for Developers Doing Select *'s

paul.knibbs (6/26/2015)
Your Name Here (6/25/2015)
Lesson: Dynamic SQL is dangerous, stupid and just bad form.
Using dynamic SQL without parameterising it is dangerous, stupid and bad form. If the developer in your...
--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 30, 2015 at 7:50 am

#1809130
RE: Table with 789.6 million records taking 5 mins to execute the select stmt

harris32 (6/25/2015)
I'm inserting the data into the temp table and how does the index matter on the table to which the data is loading ?
Thanks for your reply though...
--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 30, 2015 at 7:43 am

#1809124
RE: need help on Scalar value Function

ScottPletcher (6/25/2015)
sgmunson (6/25/2015)
ScottPletcher (6/25/2015)
GilaMonster (6/25/2015)
Nolock hints, do you know what they do? (hint, they don't make queries faster)
Why does everyone keep repeating that? Of course NOLOCK hints make queries...
--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 30, 2015 at 7:41 am

#1809122
RE: Building a Tree Structure in an efficient and faster way.

a4apple (6/25/2015)
Hmmm... MLM. If that's true, are you using a "uni-level" payout system?
Yes, absolutely... I saw your article Jeff.. My only question is if one account changes its...
--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 30, 2015 at 7:37 am

#1809120
RE: Count of consecutive years of participation (islands and gaps)

OLSONEJ (6/30/2015)
Whoops, that is my fault. 4 should have three upon looking at it again. My apologies.
Still, what do you want to do for the scenario in my...
--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 30, 2015 at 7:31 am

#1809116
RE: Using a Recursive CTE to Generate a List

ChrisM@Work (6/30/2015)
Paul White (6/28/2015)
...All this frequently confuses DBAs and developers who are used to tuning performance based solely on logical reads (not a school of thought I subscribe to by...
--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 30, 2015 at 7:30 am

#1809115

Viewing 15 posts - 20,206 through 20,220 (of 59,098 total)