Jeff Moden

Forum Replies Created

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

RE: give me your suggestion

Bob Hovious (3/5/2009)
You and Steve and Gail and Grant and the other Gurus should start a SQL Server Central Certification Committee to promote higher standards.
Ya know.... someone was kidding about...
--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 10:44 pm

#954649
RE: "Answered" Posts

Bob Hovious (3/5/2009)
Just some thoughts here.
Any number of times I've seen the substantially the same question appear, just with different data and column names. Concatenation...
--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 10:36 pm

#954647
RE: "Answered" Posts

Michael Valentine Jones (3/5/2009)
Just padding my posts here, but I really don't see how answer ratings would contribute much. This is a discussion board, so all the meat 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)

March 5, 2009 at 10:30 pm

#954645
RE: Keep it up!

You absolutely deserve 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)

March 5, 2009 at 6:16 pm

#954584
RE: give me your suggestion

Bob Hovious (3/5/2009)
You DID get the compliment from an MVP
I heard you were an MVP. What I meant to say was that I took more pride in...
--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 6:08 pm

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

florian.reischl (3/5/2009)
Jeff Moden (3/5/2009)
Hey Flo! I have to ask... how did you get that picture of me first thing in the morning? 😛
Picture of you?? Maybe we are...
--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 6:00 pm

#954581
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

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