Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,951 through 25,965 (of 59,102 total)

RE: Concat column values

With the idea of "teaching a man to fish" in full swing, please see the following article.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
For future posts, please see the article at the first link in "Helpful Links"...
--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)

September 15, 2013 at 1:44 pm

#1650288
RE: get only the alphabets from string

Ok, here we go. First, we need some test data. I normally test functions with a million rows of data to ensure scalability so here’s a million row...
--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)

September 15, 2013 at 10:21 am

#1650279
RE: get only the alphabets from string

Sorry... deleted this post. I made a testing error. I'll be back.
--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)

September 14, 2013 at 9:18 pm

#1650258
RE: How to prevent ANY use of xp_CmdShell?

david.alcock (6/18/2013)
I am a big fan of it but I am beginning to think that SSIS is possibly the root of all evil...
Apologies for missing this post, David. Having no...
--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)

September 13, 2013 at 9:15 pm

#1650206
RE: get only the alphabets from string

born2achieve (9/13/2013)
Here is the code i tried and works fine the only minute draback of using this function take few milliseconds delay than using the sql query. but writing function...
--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)

September 13, 2013 at 2:39 pm

#1650177
RE: Function Vs Stored Procedure

Ananth@Sql (9/9/2013)
Hi Every one,
We all Knows that we call function through select and Sp through Exec.My Question is why can't we call the Sp
through Select .is there any hidden...
--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)

September 13, 2013 at 1:41 pm

#1650157
RE: get only the alphabets from string

born2achieve (9/13/2013)
I am done with writing function to remove the special characters and number from string.
Thanks everyone who responded to my question.
Nice. Let's see it, please. Thanks.
--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)

September 13, 2013 at 1:36 pm

#1650154
RE: MAXDOP question

sunny.tjk (9/13/2013)
The computer that i run queries on has 2 processors. Shouldn't query1 execute faster than query2 ? Surprisingly, both executed taking exact time. Also, on OLTP system, should MAXDOP...
--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)

September 13, 2013 at 1:32 pm

#1650152
RE: Import Text File to SQL Database

db2mo (9/12/2013)
What data type do I bring it into the staging table as?
If you use a BCP format file, You can bring it into a staging table as the correct...
--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)

September 12, 2013 at 12:39 pm

#1649839
RE: how to write query

dwain.c (9/11/2013)
BTW. I really like this.
Jeff Moden (8/31/2013)
That's why I teach my Developers to learn the more performant methods... so they can do it in their sleep and won't...
--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)

September 12, 2013 at 6:01 am

#1649658
RE: concatenate with leading zeros

paul.s.lach (9/11/2013)
Jeff, I do not believe my test harness is writing to disk after the initial setup of the temporary table. By using the WHERE clause in each 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)

September 11, 2013 at 7:38 am

#1649305
RE: concatenate with leading zeros

Part of the reason why Paul S. might be seeing some instability is because he didn't trust the @BitBucket variable and took to writing to disk. Depending on what...
--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)

September 10, 2013 at 9:19 pm

#1649087
RE: Complex hierarchy: how to build?

Dennis Post (9/10/2013)
Looks like a job for a recursive query.
Make up some sample data so we can help you out. (Create table + inserts + clean up)
Or you could check...
--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)

September 10, 2013 at 9:15 pm

#1649086
RE: unable to run power shell script from SQL server agen

mhafiez (9/10/2013)
hello,
i created this power shell script to retun SQL server configurationsconfiguration, the script works fine when I run it from Powershell ISE, however it fails when i schedule 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)

September 10, 2013 at 2:23 pm

#1649029
RE: concatenate with leading zeros

paul.s.lach (9/10/2013)
One of the things I thought of was an article I read that said that the compiler optimizes "SELECT @Variable = ..." to just set it to the first...
--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)

September 10, 2013 at 1:55 pm

#1649025

Viewing 15 posts - 25,951 through 25,965 (of 59,102 total)