Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,361 through 48,375 (of 59,095 total)

RE: Local Temporary Tables and Table Variables

Ummm... high IO and CPU isn't necessarily caused by either Table Variables or Temp Tables. It's HOW they are used. I think what you're going to find is...
--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, 2008 at 10:23 am

#871432
RE: Patindex

S'ok... just proves one thing... memory is one of the best things you can do to speed up a machine. Thanks for the feedback, Remi.
--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, 2008 at 10:19 am

#871431
RE: Patindex

Ninja's_RGR'us (9/12/2008)
Holly shit... is the only way to describe those results!!!
Heh... your surprise, Remi, is that your particular computer sucks at handling strings... the results you provided are WAY out...
--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, 2008 at 9:01 am

#871427
RE: I AM HAVING THIS UNIQUE AND STUPID SITUATION IN SSIS FROM MAINFRAME

gyanendra.khadka (9/12/2008)
Lynn, FInally Got IT. But for one FTP process I don't thing they would like to do it. ALso, on my side I only have one ssis packages 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)

September 13, 2008 at 8:21 am

#871425
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Thanks for the great feedback, Carla. If you want a bit more on splitting things, take a peek at the followup article below...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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, 2008 at 7:33 pm

#871400
RE: Patindex

By the way... if you actually take the time to run the code above, I think you'll be very surprised as some of the outcome.
--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, 2008 at 7:26 pm

#871399
RE: Patindex

"LIKE" has gotten a pretty bad reputation just by word of mouth. Might be left overs from the early days of SQL. Glad to see some folks testing...
--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, 2008 at 7:21 pm

#871398
RE: killing old spids

Fraggle (9/12/2008)
Sorry to scare you there Jeff. 😀
Dang... as luck would have it, I found a reason to actually nuke old spids... connection leaks. I recently started a...
--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, 2008 at 5:01 pm

#871390
RE: I AM HAVING THIS UNIQUE AND STUPID SITUATION IN SSIS FROM MAINFRAME

No extensions on the file names?
--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, 2008 at 9:39 pm

#870734
RE: Off IF...ELSE Behavior

Here you go, Jody...
--===== If the temp table already exists, drop it.
-- This should be commented out in a production environment
...
--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, 2008 at 7:54 pm

#870727
RE: Patindex

Manie, great primer on PatIndex!
There is hundreds of other ways to use these functions and the way I used here is most probably not the best way so, if anyone...
--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, 2008 at 7:35 pm

#870726
RE: Working part-time

One of the folks on this very forum said it best... "The extraordinary DBA is the first person someone goes to when they need help, not the last." Sounds...
--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, 2008 at 7:13 pm

#870722
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Thanks for the awesome feedback, Hans. You made my day. Just remember, the Tally table is not a panacea... it cannot be used for all things that loop....
--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, 2008 at 7:09 pm

#870720
RE: String function

On the other hand, look at the bright side... 🙂 They have such a crappy DB that they need someone like you to wade through it and fix things....
--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, 2008 at 7:02 pm

#870719
RE: Off IF...ELSE Behavior

Jody Claggett (9/11/2008)
...but it looks like your code sample is suming the data based on the fiscal quarter.
What I am looking for is to sum the YTD quota up...
--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, 2008 at 6:54 pm

#870716

Viewing 15 posts - 48,361 through 48,375 (of 59,095 total)