Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,416 through 17,430 (of 59,067 total)

RE: A SQL Server Date Handling Issue

trboyden (6/20/2016)
SQL Server expects the date to be passed in as "2016-06-20 00:00:00"
That's not true at all. SQL Server will take a couple dozen date/time formats in stride with...
--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 20, 2016 at 7:00 pm

#1885940
RE: SSIS Refuses to capture a single row result set as a variable.

fizzleme (6/20/2016)
We are receiving daily backup files. I need to select the correct one from a folder and automate the restore process. It makes sense 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)

June 20, 2016 at 6:20 pm

#1885939
RE: SSIS Refuses to capture a single row result set as a variable.

Heh... why not cut out the middle man and just use T-SQL? 😉
--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 20, 2016 at 5:29 pm

#1885934
RE: Are the posted questions getting worse?

Any of you heavy hitters looking for a DBA (they need a good one) in San Diego? It's for one of our sister companies.
--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 20, 2016 at 5:26 pm

#1885933
RE: Hunting down bad code/ETL

Eric M Russell (6/20/2016)
Jeff Moden (6/17/2016)
As a bit of a sidebar and like anything else in SQL Server, saying something like the use of SELECT * always being bad 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)

June 20, 2016 at 9:43 am

#1885881
RE: Tables, Primary Keys and Clustered Indexes

andymay-496937 (6/19/2016)
I always thought that good design was a basic requirement for good performance? Your comments suggest that good performance is not necessarily dependent on good design, if 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 20, 2016 at 6:52 am

#1885828
RE: Insert Same rows Multiple times

durga.palepu (6/18/2016)
You need to define a tally table
create dbo.numbers(n int);
Load the numbers table using standard logic available.
Now to load the data into #insert table,
INSERT INTO #INSERT(txt)
SELECT txt
FROM #TEMP t
CROSS JOIN...
--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 18, 2016 at 2:11 pm

#1885755
RE: Temp DB filling on simple update statement?

patrickmcginnis59 10839 (6/14/2016)
Jeff Moden (6/13/2016)
patrickmcginnis59 10839 (6/13/2016)
Jeff Moden (5/25/2016)
krypto69 (5/25/2016)
Hi,
I have a pretty simple update statement:
UPDATE eligibility
SET primary_plan = 0
FROM temp_eligibility e
WHERE eligibility.eligibility_id = e.eligibility_id
This statement is updating around 7...
--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 18, 2016 at 2:07 pm

#1885754
RE: QotD need an out

Steve Jones - SSC Editor (6/14/2016)
Yep, click the discuss link on the main page for the question. Or check the author's forum.
No need to answer to discuss. I rarely answer...
--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 18, 2016 at 1:45 pm

#1885751
RE: Function to convert a datetime value into a harvest season year

GSquared (6/15/2016)
Jeff Moden (6/15/2016)
GSquared (6/14/2016)
I just tested a Calendar table version against the UDFs defined here.
Calendar table was consistently about 10X faster.
Can you post your test code?
Nope. The Post...
--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 18, 2016 at 1:36 pm

#1885749
RE: DBA career advice

patrickmcginnis59 10839 (6/13/2016)
Jeff Moden (6/10/2016)
patrickmcginnis59 10839 (6/10/2016)
RonKyle (6/9/2016)
Besides, if you have to prepare for an interview, then you're not ready for the job.
Disagree. It never hurts to review 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 18, 2016 at 1:31 pm

#1885748
RE: Interview Questions

Sergiy (6/17/2016)
Jeff, if you're after a senior one then don't ask junior level questions.
My remark was about this statement from you:
the candidate probably shouldn't over-engineer the answer, especially in...
--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 17, 2016 at 5:31 pm

#1885729
RE: Insert Same rows Multiple times

djacob 65569 (6/17/2016)
THANK YOU!!! That helped me out immensely!
The question now is, do you understand how and why it works?
--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 17, 2016 at 9:14 am

#1885649
RE: Hunting down bad code/ETL

As a bit of a sidebar and like anything else in SQL Server, saying something like the use of SELECT * always being bad is the wrong thing to say....
--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 17, 2016 at 8:55 am

#1885645
RE: Simple CLR request

Luis Cazares (6/17/2016)
Just curious on why you want to use CLR for this.
+1000
--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 17, 2016 at 8:49 am

#1885642

Viewing 15 posts - 17,416 through 17,430 (of 59,067 total)