Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,826 through 27,840 (of 59,101 total)

RE: Loading change data from AS400 (or other source systems)

shannonjk (12/18/2012)
Yes I believe OPENQUERY in this case is limited to the capabilities of the connection to the AS400 (which is hosted off-site from the sql server and we 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)

December 18, 2012 at 9:07 pm

#1569851
RE: ORDER BY Should be same as my input in IN()

CELKO (12/18/2012)
People used to say the same thing about FORTRAN (IBM, Univac, DEC, DG, Burroughs, NCR, CDC, Honeywell, et al). We just kept writing portable code and built hundreds of...
--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)

December 18, 2012 at 8:18 pm

#1569842
RE: Missing Indexes on Temp tables

I'll second what GSquared just said.
Sometimes, the optimizer needs a little help. Sometimes that help is to just very quickly isolate a much smaller subset in a temp 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)

December 18, 2012 at 7:31 am

#1569566
RE: Stripping out all non-numerical characters

@sachin,
I agree that the CLR Regex method should be the fastest although I've not seen any performance testing on it.
The questions I have for you is...
1. Can you use CLR...
--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)

December 18, 2012 at 7:08 am

#1569558
RE: Create Table and Bulk Insert

urso47 (12/16/2012)
Great Jeff!!!
Thanks a lot! I saw it and it seems very, very complex for me to understand rigth away. I will take sometime later on to test the code...
--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)

December 18, 2012 at 6:24 am

#1569528
RE: Get list of months, monthname and Year

Jason-299789 (12/18/2012)
ColdCoffee,
I like your solution.
I pushed it to run over the largest dataset I could think of with every month between 1753 and 9999 and it returned in about...
--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)

December 18, 2012 at 6:16 am

#1569522
RE: Get list of months, monthname and Year

sandeepmittal11 (12/17/2012)
Refer this link
Yowch! Nasty web site. It want's to build a half dozen trusted frames and download temporary fonts. I don't allow that on my machine....
--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)

December 18, 2012 at 6:13 am

#1569521
RE: how to find ASCII characters in a table?

mkarthikeyyan 89837 (12/17/2012)
Hi,
Please help to solve this !!!
i need to create tables and insert values in following tables, the scenario is
create table tbl1(tbl1_col1 int primary key ,tbl1_col2 int)
create table tbl2(tbl2_col1...
--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)

December 17, 2012 at 6:27 pm

#1569340
RE: How to use raiserror in UDF's

And from someone brand-spanking-new to the forum, no less. Nice trick, Mitch. Thanks for posting 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)

December 17, 2012 at 6:16 pm

#1569338
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

Thanks, Boriskey :blush: I really appreciate the feedback. I aim to please... I sometimes miss but I'm always aiming. 😀
--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)

December 17, 2012 at 6:13 pm

#1569337
RE: Loading change data from AS400 (or other source systems)

shannonjk (12/12/2012)
Ok so finally getting the testing done on this.
So far I am finding OPENQUERY to be a slower method. Are there particular things I should be utilizing 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)

December 17, 2012 at 6:06 pm

#1569335
RE: how to find ASCII characters in a table?

mkarthikeyyan 89837 (12/17/2012)
If so how how can i create tables with this criteria and insert values in single statement?
Thanks in advance !!!
Read up on the subject of "Instead-of...
--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)

December 17, 2012 at 6:00 pm

#1569333
RE: Value of column dependent on the values of others. How can I do it . Please help !

Yeah... you're right. I forgot the OP wanted 'u' and 'U'. Your good code is spot on now. Thanks for the feedback, Magoo.
And, I'll say it 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)

December 16, 2012 at 9:24 pm

#1569003
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

Here's another way... same idea, though.
DROP TABLE #MyHead;
SELECT TOP (1000)
ID =...
--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)

December 16, 2012 at 9:13 pm

#1569001
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

No... not from a sub-query. At least I haven't figured out a way to do it with a TOP 1/ORDER BY like that.
You could do it using a 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)

December 16, 2012 at 9:09 pm

#1568998

Viewing 15 posts - 27,826 through 27,840 (of 59,101 total)