Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,986 through 33,000 (of 59,099 total)

RE: Help getting rid of another cursor based query

Damn. Tom, I'm sorry. I totally lost tract of this thread. Are you all set or do you still need some help?
--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)

August 5, 2011 at 7:31 pm

#1364726
RE: xp's in SQL2000

I suffer from massive amounts of CRS and appreciate it when every forum question has an answer to I can look it up instead of having to remember 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)

August 5, 2011 at 7:24 pm

#1364723
RE: Tuning a view to avoid pageIO_Latch_SH locks

Biz (8/4/2011)
Thank you for your reply. But i didnt get your "get"part. Can you explain a bit more.
thanks.
When a GUI retrieves data from a database, it's sometime referred to as...
--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)

August 5, 2011 at 7:20 pm

#1364719
RE: No Parallelism When using Row level function

Leo.Miller (8/2/2011)
Jeff Moden (8/2/2011)
Leo.Miller (8/1/2011)
I can't see any real benefit of using an iTVF, since as far as I can see, [font="Arial Black"]you can still only pass it a single...
--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)

August 5, 2011 at 7:07 pm

#1364718
RE: How do we solve this issue without using a CURSOR or WHILE loop?

C.K.Shaiju (8/4/2011)
I have a doubt here. What cde_NetAmount = CAST(NULL AS DECIMAL(22,6)) will do? What is the difference if it is without CAST like the following? cde_NetAmount = NULL.
It's 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)

August 5, 2011 at 6:31 pm

#1364712
RE: Are the posted questions getting worse?

Gianluca Sartori (8/5/2011)
I'm officially out.
I'll never, ever be an employee again.
I'll punch my timecard for the last time in 1 minute.
Congratulations and I wish you nothing but success. If...
--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)

August 5, 2011 at 6:11 pm

#1364711
RE: xp's in SQL2000

Considering the original post was never answered, I'm cool with an answer 10 years later. 🙂
--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)

August 5, 2011 at 2:16 pm

#1364622
RE: recursive cte question

sqlpadawan_1 (8/5/2011)
Thanks all for the input and direction. I think I'm going to try and do it both ways to see what the difference is in the execution plans.
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)

August 5, 2011 at 2:05 pm

#1364617
RE: Is there a smarter way of fixing transposition errors?

drew.georgopulos (8/4/2011)
Is there a smart way to do this?
No. There isn't for this particular type of thing. If your "smart" program, whatever it is, makes a bad guess,...
--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)

August 4, 2011 at 11:57 pm

#1364092
RE: Need help on BCP

You might be able to get away without any format files if using BCP. Views work [font="Arial Black"]very [/font]nicely for such a thing in most cases. Of course,...
--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)

August 4, 2011 at 11:54 pm

#1364091
RE: recursive cte question

R.P.Rozema (8/4/2011)
Recursion is not the way to go about on this one, though. You'll run into the first signs of problems when one of your date range goes beyond 100...
--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)

August 4, 2011 at 11:48 pm

#1364090
RE: Splitting City and State with variable formats

Here's my take on it. I don't know for sure if I have all the bases covered but I've avoided the very expense REVERSE function altogether thanks to my...
--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)

August 4, 2011 at 11:28 pm

#1364085
RE: Splitting City and State with variable formats

trstringer (8/4/2011)
So it ended up being even worse than originally thought of. The data was even messier than that. In some entries, the zip code was appended to...
--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)

August 4, 2011 at 10:48 pm

#1364077
RE: How to write the output of "print" messages to a file - path (c:\test.txt) ??

thundersplash845 (8/4/2011)
Hmmmm... i just want to print the output in a text file 🙁 ....any alternative way u could suggest??
BWAA-HAA!!! Understood and very much appreciated. 🙂
SQL Server (T-SQL, really) isn'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)

August 4, 2011 at 10:35 pm

#1364075
RE: Tuning a view to avoid pageIO_Latch_SH locks

I don't believe you're going to be able to do much with that view. The query is too big and the reason why it has a DISTINCT in 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)

August 3, 2011 at 10:21 pm

#1363436

Viewing 15 posts - 32,986 through 33,000 (of 59,099 total)