Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,526 through 54,540 (of 59,089 total)

RE: how to remove numbers from strings?

You didn't wait long enough
Couple of us didn't... I missed that... sorry. :ermm:
--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)

October 20, 2007 at 12:29 am

#743841
RE: how to remove numbers from strings?

vadimt (10/18/2007)
the first solution didnt work. because of the Tally i didnt implement.
i dont need it as a function because i need it only in one place in the whole...
--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)

October 20, 2007 at 12:19 am

#743840
RE: how to remove numbers from strings?

Lowell (10/19/2007)
so...
Your saying CLR's are for people who know sql, or people who don't know sql...I'm confused. 😉
By the way... this note cracked me up this morning... I almost...
--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)

October 20, 2007 at 12:11 am

#743839
RE: Missing c# Assembly

Heh... what'cha gonna do with a CLR that can't be easily done with good performance in T-SQL anyway? 😀 Think of it as an "omen"...;)
--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)

October 20, 2007 at 12:09 am

#743838
RE: Pivot Table Help Needed

Here is a Jeff Moden example I keep in my toolbox
Heh... thank you kindly for the "plug" 😀 Got a present for ya, MrPoleCat...
CREATE PROCEDURE dbo.AutoCrossTab
/**************************************************************************
Purpose:
-------
...
--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)

October 20, 2007 at 12:01 am

#743835
RE: Updating 22,000,000+ row table in DTS

Went to the doctor and said "Doctor, when I hold my arm up like this (deomonstrating strange angle to arm), it hurts like hell". Doctor said, "Don't do 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)

October 19, 2007 at 8:05 pm

#743823
RE: Help in WHERE clause

Not sure why you're trying to do such a simple thing in such a difficult manner... but, using YOUR code...
SELECT * FROM #TestTable
WHERE Title LIKE '%'+@dummy+'%'[/b] or Title is null
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)

October 19, 2007 at 7:49 pm

#743822
RE: Grouping not Grouping

I think you'll find the problem in one of the text columns... you may have some trailing spaces in some of the descriptions. You can check for those by...
--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)

October 19, 2007 at 7:35 pm

#743821
RE: System Performance - High CPU utilization--> SQLSRV.exe

I have checked all possible solutions for these but still get complaints from users about the slowness.
I'm thinking you haven't checked ALL possible solutions if you still have a problem...
--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)

October 19, 2007 at 7:26 pm

#743820
RE: System Performance - High CPU utilization--> SQLSRV.exe

Heh... can't believe you saved that list, Rudy 😀
--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)

October 19, 2007 at 7:05 pm

#743816
RE: Adding workdays

Why not just include all non-working days including weekends and perform one check instead of two?
Larger number of rows? Correlated aggragate sub-query on large number of rows? ...
--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)

October 19, 2007 at 6:46 pm

#743815
RE: Adding workdays

Greg Snidow (10/19/2007)
Secondly, too all of you, I am amazed by how you guys can effictively do in a matter of hours, what it took me days, and sometimes weeks...
--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)

October 19, 2007 at 6:20 pm

#743812
RE: Actual Reason to Use CLR

David.Poole (10/19/2007)
On the subject of delivering solutions I've seen too many solutions that were delivered on-time and on-budget that worked adequately at the time of installation but 6 months on...
--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)

October 19, 2007 at 5:49 pm

#743811
RE: how to remove numbers from strings?

Jack Corbett (10/19/2007)
Just a couple of comments.
I really enjoyed the thread. A lot of good information and no one got personal as I have seen happen when...
--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)

October 19, 2007 at 5:16 pm

#743810
RE: how to remove numbers from strings?

Matt Miller (10/19/2007)
Sergiy - you missed my response to Jeff. Short answer - on the same platform (hardware+table+indexes+data spead) - they tie, or at least are close enough 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)

October 19, 2007 at 9:06 am

#743670

Viewing 15 posts - 54,526 through 54,540 (of 59,089 total)