Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,791 through 44,805 (of 59,095 total)

RE: Storing a counter- take 2 (original post has been hi-jacked)

"CostGuard" is a telephone accounting system. It had similar code to the NEXT_ID example you posted and it was, in fact, called "NEXT_ID".
--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)

March 5, 2009 at 5:58 pm

#954580
RE: Urgent : Sql server db tuning

musheik (3/5/2009)
yes, this is one time process. I will try your advice and get back to you
Heh... that's what the all say... it'll come back.
--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)

March 5, 2009 at 4:41 pm

#954554
RE: How Do I strip the decimal out of a price

Hey Flo! I have to ask... how did you get that picture of me first thing in the morning? 😛
--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)

March 5, 2009 at 4:37 pm

#954552
RE: Simple Recovery Mode, Yet Logfile Very Large?

Another thing to consider is rebuilding indexes, especially wide indexes, will use quite a bit of the Log file and then release it (didn't say shrink). That's another good...
--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)

March 5, 2009 at 4:28 pm

#954545
RE: PIVOT query

I've gotta ask, Ed... why do you need this type of denormalize output? What is that output going to be used on? I'm asking because I like 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)

March 5, 2009 at 4:24 pm

#954541
RE: Need to schedule a job that runs on all databases in an instance

Mohit (3/5/2009)
That trigger is def a good idea :). Another option you have is since the stored procedure is required in each database; why not add it to 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)

March 5, 2009 at 4:21 pm

#954537
RE: Storing a counter- take 2 (original post has been hi-jacked)

florian.reischl (3/5/2009)
BEGIN TRANSACTION
UPDATE #id_tab SET next_id = next_id + 1 WHERE table_name = @table_name
SELECT @id = next_id...
--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)

March 5, 2009 at 4:17 pm

#954532
RE: give me your suggestion

Chris Morris (3/5/2009)
Jeff Moden (3/5/2009)
Bob Hovious (3/5/2009)
I just tested the function from that article ... it is SLOW!!!!
9999 rows converted using that function takes almost 20 seconds!!!
Heh... I absolutely love...
--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)

March 5, 2009 at 4:05 pm

#954521
RE: give me your suggestion

Bob Hovious (3/5/2009)
Thanks Jeff... I take more pride in a compliment like that from you than I would from an MVP.... although unfortunately it doesn't look as good on 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)

March 5, 2009 at 4:02 pm

#954517
RE: Problems sending string parameter to a SP

That's why I'll frequently use a programmable Tally CTE. I've got that bad boy written up in the Tally table article...
Thanks for the test code... I'll try to find...
--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)

March 5, 2009 at 3:58 pm

#954515
RE: "Answered" Posts

I absolutely agree... right now, there's a "Rate Topic" button in the upper right quadrant of the screen... if you look at the topics in any given week, you might...
--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)

March 5, 2009 at 3:55 pm

#954513
RE: give me your suggestion

Bob Hovious (3/5/2009)
I just tested the function from that article ... it is SLOW!!!!
9999 rows converted using that function takes almost 20 seconds!!!
Heh... I absolutely love it... let me officially...
--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)

March 5, 2009 at 3:07 pm

#954475
RE: "Answered" Posts

Heh... well said, Bob... my opinion is, "We don' need no stinkin' ratin' system." RTFP instead. 😀
--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)

March 5, 2009 at 2:38 pm

#954444
RE: "Answered" Posts

GSquared (3/5/2009)
Number of posts doesn't assert anything, but it's a better metric than anything subjective.
Heh... Yeah... especially where I'm concerned... everyone knows I do nothing but write a couple "hunert"...
--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)

March 5, 2009 at 2:35 pm

#954436
RE: how can i avoid cartesian join?

Perfect... thanks... here's how to do it...
;WITH
cteTableA AS
(
SELECT ROW_NUMBER() OVER (ORDER BY Phone_No) AS RowNumber,
Phone_No
FROM dbo.TableA
...
--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)

March 5, 2009 at 2:00 pm

#954389

Viewing 15 posts - 44,791 through 44,805 (of 59,095 total)