Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,511 through 42,525 (of 59,102 total)

RE: Optimiser estimating wrong number of actual rows.

Rahul N (8/6/2009)
Those are not estimated rows. When you open a query plan and hover over the arrows it actually shows you Actul and Estimated row contribution of every branch.
Heh......
--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)

August 6, 2009 at 12:32 pm

#1035591
RE: Date Range within a Date Range

jcrawf02 (8/6/2009)
aktikt (8/6/2009)
Jeff,
I have listed the results of running your query against existing Claims data containing
35923 records, below. I have added a WHERE clause to restrict the values...
--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)

August 6, 2009 at 12:27 pm

#1035587
RE: Date Range within a Date Range

aktikt (8/6/2009)
Jeff,
I have listed the results of running your query against existing Claims data containing
35923 records, below. I have added a WHERE clause to restrict the values 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)

August 6, 2009 at 12:24 pm

#1035586
RE: Date Range within a Date Range

jcrawf02 (8/6/2009)
Jeff, condolences to you and your friend's family.
Thanks. I very much appreciate that. I don't normally air my personal stuff but this one really got to me...
--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)

August 6, 2009 at 12:21 pm

#1035585
RE: Date Range within a Date Range

nigel (8/6/2009)
Jeff Moden (8/5/2009)
Nigel will probably beat me to it, though.
Not a chance, I was sleeping while you were working on this.
Nice solution Jeff, I think I just about get...
--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)

August 6, 2009 at 12:19 pm

#1035581
RE: Gain Space Using XML data type

Paul White (8/5/2009)
Jeff Moden (8/5/2009)
As a side bar... There is a rumor (and I STRESS the word RUMOR!) I heard and I can't confirm it or deny it. 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)

August 6, 2009 at 12:15 pm

#1035576
RE: Disable and enabling index frequently

GilaMonster (8/6/2009)
Jeff Moden (8/2/2009)
Even if you could, I wouldn't do that. What would happen to the index if you were inserting rows with the index turned off? They...
--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)

August 6, 2009 at 12:03 pm

#1035569
RE: Are the posted questions getting worse?

jcrawf02 (8/6/2009)
Bob Hovious (8/5/2009)
But I dare you to find anyone who finds me the least bit intimidating, except from across a chessboard, or in a game of Trivial Pursuit. [Smile]
(2)...
--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)

August 6, 2009 at 11:58 am

#1035566
RE: Are the posted questions getting worse?

Grant Fritchey (8/6/2009)
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
http://www.sqlservercentral.com/Forums/Topic765935-8-1.aspx
I recognize that mood....
--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)

August 6, 2009 at 11:57 am

#1035563
RE: Are the posted questions getting worse?

GilaMonster (8/6/2009)
Paul White (8/6/2009)
I wonder if it is the same guy? He certainly seems spookily similar in posting style...?
Don't think it is. The PhD candidate has complained in 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)

August 6, 2009 at 11:56 am

#1035561
RE: Are the posted questions getting worse?

GilaMonster (8/6/2009)
Jeff Moden (8/5/2009)
He's mine, please... all mine... pork chops in progress. I don't want to start a dog pile on him, but he's mine.
http://www.sqlservercentral.com/Forums/Topic765935-8-1.aspx
You have noticed that 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)

August 6, 2009 at 11:55 am

#1035560
RE: The query output should be

Quick question... are you the same Karthikeyan that is a "Senior Software Engineer" working on a PHD or are you someone else?
--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)

August 6, 2009 at 11:53 am

#1035558
RE: How to split the batch wise id in commaseparatedly?

David Burrows (8/6/2009)
Not wanting to incure Jeff's wrath (let alone pork chop) but I wanted to get his opinion on my solution 😀
Heh... ok, David. Do you want BBQ...
--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)

August 6, 2009 at 10:58 am

#1035530
RE: How to split the batch wise id in commaseparatedly?

Heh... if I knew the reason, we'd be done by now. It is a 2 way street, y'know. Anyway, I don't have the time to wait... it's 2: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)

August 6, 2009 at 12:26 am

#1035201
RE: How to split the batch wise id in commaseparatedly?

I know what you want to do. I want to know WHY you want to do it. I'd give you the answer up front except no one ever...
--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)

August 6, 2009 at 12:23 am

#1035200

Viewing 15 posts - 42,511 through 42,525 (of 59,102 total)