Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,176 through 20,190 (of 59,072 total)

RE: Are the posted questions getting worse?

Luis Cazares (7/2/2015)
jasona.work (7/2/2015)
Today is the kind of day (and it's only been an hour and a half since I got to work) that you clock watch...
OTOH, got plenty to...
--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)

July 2, 2015 at 7:46 am

#1809885
RE: Are the posted questions getting worse?

jasona.work (7/1/2015)
QUICK! Look over there!! It's a dinosaur!!
Dude... I'm standing right here...
Sorry you missed seeing the dinosaur though, it was really cool...
:hehe:
Yes, we 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)

July 1, 2015 at 4:14 pm

#1809699
RE: The New DBA

Ed Wagner (6/30/2015)
Alvin Ramard (6/30/2015)
Jeff Moden (6/30/2015)
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...
--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)

July 1, 2015 at 12:21 am

#1809370
RE: Possible to find the parameters passed to an SP for performance tuning?

jasona.work (6/30/2015)
Ran into an issue with a stored procedure earlier today. The SP was taking a *long* time to return results which was causing it to block some other...
--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:55 pm

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

Viewing 15 posts - 20,176 through 20,190 (of 59,072 total)