Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,371 through 38,385 (of 59,072 total)

RE: Reduce the time spent on cross process communication

neelsmail (5/15/2010)
Hi-
I am being probably over-expecting here but anyway..
I run a stored procedure from my C# app. I want to be able to run that stored procedure for 10000 times...
--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)

May 15, 2010 at 5:50 pm

#1167971
RE: How to give Rowterminator manually in BCP?

Saravanan_tvr (5/15/2010)
Hi,
I need to extract the Data pipeline as Column Terminator and : colon as
Row terminator...
My Query IS
declare @sql varchar(8000)
declare @path varchar(8000)
set @path ='D:\STOCK_12_05_2010.txt'
select...
--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)

May 15, 2010 at 5:48 pm

#1167970
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Better yet... I'm going to bow out of this thread. I swore to myself that I wasn't going to show any of my new methods until PASS... and I'm...
--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)

May 15, 2010 at 5:30 pm

#1167968
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Paul White NZ (5/15/2010)
Jeff Moden (5/15/2010)
Don't be too sure... First, as good as it is (well done, Paul), Paul's code didn't convert the Adjacency List to the Hierarchical Path that...
--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)

May 15, 2010 at 5:26 pm

#1167967
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

mahbub422 (5/12/2010)
Dear Paul,
Your technique is better. So, I am interested to use your technique. Peter also suggested me to follow your method. I already inserted around 1200 data in database...
--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)

May 15, 2010 at 5:21 pm

#1167965
RE: How to insert these dates in database

WayneS (5/15/2010)
Instead of passing all those dates to the database to be added in one at a time, why don't you make a stored procedure and pass just the starting...
--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)

May 15, 2010 at 11:51 am

#1167946
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Peter Brinkhaus (3/20/2010)
Unfortunately we don't have a realistic testset (and I'm too lazy now to generate one), but I'm almost certain that Paul's solution outperforms my solution by a factor...
--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)

May 15, 2010 at 11:41 am

#1167945
RE: Need a date between what MIN and MAX returns

ninel (5/14/2010)
Normally I would use MIN function to pick up the earliest date I need processed. Lately i've been finding at least one date is out of the norm....
--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)

May 15, 2010 at 11:00 am

#1167941
RE: Need a date between what MIN and MAX returns

vijay.s (5/15/2010)
WHERE MIN(GETDATE()) = GETDATE()--So its a next day date from your minimum date
I Hope this what you wanted! If you want to a batter solution then try to post...
--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)

May 15, 2010 at 10:56 am

#1167940
RE: Difference between Inline view and Derived table

Paul White NZ (5/15/2010)
tarun.jaggi (5/14/2010)
Can anyone of you please tell me the difference between Inline view and Derived table?
In general, the way the terminology is commonly used, I would say...
--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)

May 15, 2010 at 10:54 am

#1167939
RE: CTE performance

kazim.raza (5/14/2010)
Certainly not; or else; what will our friend do 😛
By brainstorming I meant just to take a high level review or opinion...
~ Kazim Raza
You should know me by now......
--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)

May 15, 2010 at 10:20 am

#1167937
RE: SQL to manipulate rows of data

krenshau (5/14/2010)
Jeff, I have been thinking about whether or not to reply to your post. First, thank you for informing me of the rules. However, I find it interesting that...
--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)

May 15, 2010 at 10:11 am

#1167936
RE: More, More, More

GilaMonster (5/14/2010)
What bugs me is when people resurrect an old thread to post an answer that's less accurate/useful than an answer already posted in the thread.
Heh... absolutely agreed. 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)

May 15, 2010 at 7:35 am

#1167918
RE: Adding Header and Trailer

Paul White NZ (5/15/2010)
I've had to do this a number of times from within SQL Server. The neatest way I have found is to create a T-SQL object (procedure...
--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)

May 15, 2010 at 7:29 am

#1167917
RE: Comparing two rows in one table for changes in column

BWAA-HAAA!!! Thanks for the feedback, Dobermann. I do have one more trick up my sleeve if all else fails. I've been trying to keep this in 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)

May 14, 2010 at 9:46 pm

#1167863

Viewing 15 posts - 38,371 through 38,385 (of 59,072 total)