Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,476 through 17,490 (of 59,069 total)

RE: CTE Replacement for Bi-Directional Recursion

michael.french 172 (6/13/2016)
Phil,
I totally agree with points 3 & 4. With points 1 & 5, they are crucial to handle the recursion efficiently as coded. As for point 2, since...
--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 13, 2016 at 4:40 pm

#1884792
RE: Function to get Number from word

It will ultimately be a whole lot easier and a whole lot less expensive both upfront and over time if you simply purchased some "CASS Certification" software, which will do...
--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 13, 2016 at 4:28 pm

#1884790
RE: Another sysjobhistory query

Dave Daiker (6/13/2016)
I use the FORMAT command so this is ...
First, thanks for the code. I'll suggest that you should write an article about it and submit it. ...
--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 13, 2016 at 4:25 pm

#1884789
RE: Remove newline in CSV field

By any chance, is the ultimate goal to import the data into a table in SQL Server?
--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 13, 2016 at 4:19 pm

#1884788
RE: Hierarchical data

@Drew,
The first link in your signature line takes us to an MSDN site for "ORDER 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 13, 2016 at 3:47 pm

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

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 million rows. Problem 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 13, 2016 at 3:06 pm

#1884784
RE: Using IronPython to talk to SQL Server

You may have finally wet my appetite for a language other than T-SQL. I can see me liking this a whole lot more than PowerShell. Thanks, Gerald.
--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 13, 2016 at 7:41 am

#1884649
RE: Interview Questions

Sergiy (6/12/2016)
Jeff Moden (6/10/2016)
And, remember, the first question is always "How do you get the current date and time using T-SQL?" whether it's for a DBA or an...
--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 12, 2016 at 10:34 pm

#1884555
RE: Calculate Working days based on Holidaymaster table

ganapathy.arvindan (6/12/2016)
Any updates reg to Nightshift tables
You have an example for the day shift that works. Put your shoulder to the wheel and give it a try for 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 12, 2016 at 12:09 pm

#1884545
RE: Changing the table names in view definition for multiple views

~~Wouldn't it be a whole lot easier to leave the view definitions alone and use a synonym instead?~~
Edit... sorry. Too quick a look. :blush: Looking again.
--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 12, 2016 at 11:46 am

#1884544
RE: import from CSV/EXCEL and insert/update into SQL which is backend for payroll software

Shifting gears to more of a direct focus on your problem...
You say you have an Excel spreadsheet and then you talk about a ".CSV". Which is it?
--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 12, 2016 at 11:38 am

#1884543
RE: import from CSV/EXCEL and insert/update into SQL which is backend for payroll software

Learner44 (6/10/2016)
Can you PLEASE help me on following?
We have payroll software that runs on SQL Server. I have to update certain payroll category from the SQL Server so that it...
--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 12, 2016 at 11:33 am

#1884541
RE: DBA career advice

RonKyle (6/11/2016)
But, if you got caught flat footed and had to submit to being interviewed in the next 10 minutes, would you fail the interview just because you didn't have...
--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 12, 2016 at 11:29 am

#1884540
RE: Commonly used DMVS in sql server

naveenareddy.dba (6/11/2016)
hi everyone,
what are the most commonly used DMV's
in sqlserver as a DBA.
Why do you ask? Knowing that might help us answer better.
And, you've presumed to include...
--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 11, 2016 at 1:23 pm

#1884513
RE: DBA career advice

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 basics even though 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 10, 2016 at 9:24 pm

#1884495

Viewing 15 posts - 17,476 through 17,490 (of 59,069 total)