Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,391 through 24,405 (of 59,099 total)

RE: Copy files from one directory to another using code

Steve Jones - SSC Editor (2/12/2014)
Personally I'd suggest you use Powershell and call that from xp_cmdshell.
BWAAA-HAAA!!!! Between the two of us, we're going to give Allen White a coronary!!!!:-)
--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)

February 13, 2014 at 11:59 am

#1688891
RE: How to reject parallelism in a query ?

I was going to suggest disabling bit 29 on DBCC TIMEWARP which suppresses the availability of parallel universes.
--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)

February 13, 2014 at 11:49 am

#1688888
RE: Are the posted questions getting worse?

Sean Lange (2/13/2014)
Luis Cazares (2/13/2014)
Sean Lange (2/13/2014)
So the little one decided to share the flu with both mommy and daddy. I am so glad we teach our children to share....
--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)

February 13, 2014 at 11:42 am

#1688882
RE: Extract text which is between 1st and 2nd comma

pruthvi116 (2/13/2014)
Thanks for both the functions!! Both of them were extremely useful.
My recommendation would be to avoid any and all functions, especially split functions, that contain the words "WHILE" or...
--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)

February 13, 2014 at 11:36 am

#1688878
RE: Can you dynamically create a temp table?

Richard Warr (2/13/2014)
If you did want to do it (and I agree that the normalised solution is better) you'd need to go with a Global Temp table rather than just...
--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)

February 13, 2014 at 11:33 am

#1688876
RE: Does the order of a CASE statement improve performance

Evil Kraig F (2/13/2014)
Grant,
My understanding was the short circuit capabilities of the CASE statement would improve performance, but in a limited variety.
Instead of a simple data change on the table...
--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)

February 13, 2014 at 11:30 am

#1688875
RE: How to make T-SQL query SARGable?

imran.adam (2/13/2014)
Hi Jeff
Thanks for the reply
I like your PERSISTED column idea.
Do you mean add another column to my cards table that is populated with a 1 if all those conditions...
--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)

February 13, 2014 at 11:27 am

#1688873
RE: How to make T-SQL query SARGable?

Yes.
I'm assuming that the card number is stored as a VARCHAR. Since credit card numbers cannot begin with zeros, I'd first recommend that column be changed to a BIGINT...
--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)

February 13, 2014 at 7:45 am

#1688739
RE: Best solution to test as a trial

meridius10 (2/13/2014)
I've got SQL Server 2008R2 Developer edition. I am ultimately looking for a cloud based database solution with full front end and BI options.
I absolutely won't give my card...
--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)

February 13, 2014 at 7:08 am

#1688720
RE: Subtotal when vendorcode changed.

Luis Cazares (2/6/2014)
There's a simple reason of why would I do this on the front end. Formatting totals and subtotals is a lot simpler that way.
If the front-end code has...
--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)

February 13, 2014 at 7:04 am

#1688717
RE: adding one more column for SubTotal in Select statement

This is really easy thanks to some (Windowing) functionality born in 2005.
I looked at your query (after I ran it through a reformatter) and the following will be similar. ...
--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)

February 13, 2014 at 6:41 am

#1688704
RE: Oddball Interview Questions

mtucker-732014 (2/12/2014)
L' Eomot Inversé (2/11/2014)
Miles Neale (2/11/2014)
A wield question can cause a candidate to think and speak out of the box.
If it takes a weird question to get 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)

February 12, 2014 at 5:40 pm

#1688582
RE: New DBA + Bankruptcy = Career Doom?..

David1425 (2/8/2014)
So I recently decided to make a career change and recently acquired a masters of science in database administration.
I'd like to see the curriculum summary for that. I...
--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)

February 12, 2014 at 4:20 pm

#1688577
RE: Cursor and update

phineas629 (2/12/2014)
I wanted to thank you guys for the suggestions. It's been a while since I've logged on. In the end I using a cursor as we only use 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)

February 12, 2014 at 12:28 pm

#1688541
RE: high cpu

pmadhavapeddi22 (2/12/2014)
Jeff,
I am sorry if I have confused you.
I still stand on the same point that there are set of update statements in a stored procedure.Due to these updates, CPU...
--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)

February 12, 2014 at 8:41 am

#1688402

Viewing 15 posts - 24,391 through 24,405 (of 59,099 total)