Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,541 through 54,555 (of 59,098 total)

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
RE: Adding workdays

And, here's my "weekdays between dates" original post... just for reference 😀
http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/
Part of what's so good about it is that it doesn't need to use a function... makes it very...
--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 2:12 am

#743451
RE: how to remove numbers from strings?

Ok everyone... pay very close attention... I'm going to say it again until you get it...
[font="Arial Black"]CLR's are for people who don't know T-SQL[/font]
First, Matt... thank you, Sir, for providing...
--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 1:24 am

#743434
RE: Adding workdays

Ok... just ran Matt's code against the million row table... Ladies and Gentlemen, we have a tie! :w00t: Matt's function took the same amount of time as mine.
One thing...
--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 18, 2007 at 11:34 pm

#743410
RE: Adding workdays

First, nicely done, Matt! Yeah, if you don't include the start date as a Week Day, then you're correct... adding 30 Weekdays to '20070514' would, in fact, be 6/25...
--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 18, 2007 at 11:31 pm

#743409
RE: Adding workdays

Heh... now you've made a real mess of the formatting... :hehe:
Ooops... never mind... dunno what happened but it went back to a good format when I posted this message...
--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 18, 2007 at 10:47 pm

#743402
RE: Adding workdays

Matt Miller (10/18/2007)
Now it just got personal :). Amazing how some good ol' fashion testing seems to work better (I keep trying with not quite enough data to see...
--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 18, 2007 at 9:31 pm

#743394

Viewing 15 posts - 54,541 through 54,555 (of 59,098 total)