Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,486 through 52,500 (of 59,072 total)

RE: Fill Factor clarification

How does one determine if a page split has occured during an update?
--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)

February 17, 2008 at 8:43 am

#779184
RE: CrossTab Query-URGENT PLEASE!

erdem (2/17/2008)
Thank you very much for your replies...At least, you replied this question 🙂
My final data report should include just six columns:
StockCode
SalesPrice1
SalesPrice2
.
.
SalesPrice5
That's all..
But, you didn't read my previous reply... you've...
--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)

February 17, 2008 at 8:40 am

#779183
RE: Sequential numbering issue

Hassie (2/17/2008)
Thanks alot - this did the job
You bet... Thanks for the feedback.
Just remember...if the count of rows for each group starts to grow, the performance will suffer greatly 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)

February 17, 2008 at 8:32 am

#779181
RE: Check if table exists

Peso (2/17/2008)
Msg 208, Level 16, State 1, Line 1
Invalid object name 'New.AddAnnex'.
Doh!... Thanks for the correction, Peter... that's what I get for late night posting. I'll correct that post...
--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)

February 17, 2008 at 8:24 am

#779180
RE: Show data upto 2 decimal places but with exact values

Yes, I absolutely agree... any type of formatting should be done only in the GUI... if there is one...
But the keyword in the title of the thread is "Show"......
--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)

February 17, 2008 at 8:21 am

#779179
RE: CrossTab Query-URGENT PLEASE!

C'mon... I know you're in a pinch but stop and think about it... we don't know what your SalesDetails detail table looks like, we know nothing about the data 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)

February 17, 2008 at 7:59 am

#779175
RE: Using PATINDEX to find all numeric values

Oh... be careful, now... IsNumeric cannot be equated to IsAllDigits. IsNumeric will allow currency symbols, $, comma, decimal point, spaces, tabs, and a host of other individual characters. ...
--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)

February 16, 2008 at 11:10 pm

#779152
RE: CLR Profiling

This was a pretty interesting question with no responses and I have no idea of what the answer might be... anyone got any idea on this, at all?
--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)

February 16, 2008 at 10:34 pm

#779150
RE: Execution Plans

... and when it comes to % of batch, it can still lie!
--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)

February 16, 2008 at 10:06 pm

#779148
RE: Check if table exists

EDIT:
I originally (incorrectly :blush: ) suggested do something like this... but, as Peso pointed out below, it's going to throw an error if table doesn't actually exist. My appologies...
--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)

February 16, 2008 at 10:02 pm

#779147
RE: How to insert date in to particular table using csv format file

OP has "left the building"... 😛
--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)

February 16, 2008 at 9:51 pm

#779146
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Heh... dang... thanks Kevin! I should'a looked in BOL...
--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)

February 16, 2008 at 9:49 pm

#779145
RE: Help with formating

Matt Miller (2/15/2008)
...It's a shame it took them all of the way until 2005 to hear the clamouring out there, so that they introduced the "include column headers into 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)

February 16, 2008 at 11:38 am

#779119
RE: Help with formating

J (2/15/2008)
Mr. Moden,
I just set the options of the query analyzer as you suggested. Thanks a million for both:
1. a very useful suggestion
2. not laughing at my dumb error.
Regards
Thanks for...
--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)

February 16, 2008 at 11:36 am

#779118
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Matt Miller (2/15/2008)
I suppose you're going to tell me I'm getting to be predictable now.... :hehe:
There's the obvious way, emulating a SQL-style cursor, which seems oh so very obvious. ...
--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)

February 16, 2008 at 11:27 am

#779116

Viewing 15 posts - 52,486 through 52,500 (of 59,072 total)