Jeff Moden

Forum Replies Created

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

RE: Best solution to test as a trial

meridius10 (2/13/2014)
Basically I'd like to test a cloud based database but don't want to have to hand over my credit card details in order to be able to do so.
Ah......
--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 16, 2014 at 8:14 am

#1689334
RE: Are the posted questions getting worse?

Jack Corbett (2/13/2014)
Now onto the reason I had time to catch-up today. I was informed that due to financial problems at my now former employer, my position...
--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 14, 2014 at 9:07 am

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

kishorefeb28 (2/13/2014)
Thank you.
You bet. Thanks for the reply. Just to be sure, do you understand how 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)

February 14, 2014 at 8:50 am

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

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