Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,451 through 42,465 (of 59,102 total)

RE: Formatting issue with a calculated value

No need for rounding if you're going to cast the answer...
SELECT CAST(100.0/ABS(VALUE) AS DECIMAL(9,3))
For example...
SELECT CAST(100.0/ABS(6) AS DECIMAL(9,3))
--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 9, 2009 at 8:49 am

#1036483
RE: A script I was working on. Your thoughts and opinions?

Heh... Like I said, it's best to mostly forget about loops. 🙂 If you're not actually using SQL Server 2005 and you have SQL Server 2000, there's still 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)

August 9, 2009 at 8:09 am

#1036478
RE: A script I was working on. Your thoughts and opinions?

It would have really been handy if you did like I said and read the article at the first link in my signature below so that you would have provided...
--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 9, 2009 at 7:19 am

#1036475
RE: A script I was working on. Your thoughts and opinions?

shannonjk (8/8/2009)
I don't use them often, but inevitably I find myself using them on a rare occasion 😀
I have a batch of code that updates a record sequence based on...
--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 8, 2009 at 10:50 pm

#1036452
RE: A script I was working on. Your thoughts and opinions?

shannonjk (8/7/2009)
Ah sweet thank mr or mrs 500 😀
I completely forgot about cross joins!
Heh... it would be better if you forgot how to make While Loops. 😉
--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 8, 2009 at 2:57 pm

#1036434
RE: Joining on view with a group by or distinct causes slow query

Divide'n'Conquer... it seems like you're trying to do everything in a single query and that can really make a mess of things. Write a proc that will get 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 8, 2009 at 2:54 pm

#1036433
RE: How to wrap a Recursive CTE in a view?

Ummmm... be careful... aggregated views (views with things like SUM) in them, aren't necessarily going to be faster if you use a criteria against their result set. For example,...
--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 8, 2009 at 1:51 pm

#1036431
RE: Huge amount of data

Ok... just to set your mind at ease, here's what I see 1 year's worth of storage taking for the data as a worst case rough ESTIMATE...
SchemeCode ...
--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 8, 2009 at 1:38 pm

#1036430
RE: Copying & Tracking Data

Heh... I really do have to install the DevEd of 2k8. Thanks for the reminder.
--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 8, 2009 at 1:08 pm

#1036427
RE: 'Add' to a character.

saivko (8/8/2009)
Thanks, yeah, an int would definitely be nicer. I inherited this setup. This text/number is even the record ID. The user who made a new record...
--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 8, 2009 at 1:03 pm

#1036425
RE: date function

smknox (8/7/2009)
thanks so much. This works.
Sam
You bet and my pleasure. I am confused a bit, though... why do you need to do this? It's not often I see...
--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 7, 2009 at 8:51 pm

#1036372
RE: How to wrap a Recursive CTE in a view?

ta.bu.shi.da.yu (8/7/2009)
Hey Jeff... I don't suppose you know how to wrap a CTE in a view? 🙂
Sure... it's easy... you've just gotta follow one of the main rules. Every...
--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 7, 2009 at 8:28 pm

#1036370
RE: date function

The following formula will do it... convert to handle columns from a table instead of variables for a set based solution... this is just for demo...
--I would like to add...
--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 7, 2009 at 8:16 pm

#1036365
RE: find current CPU usage

Mad-Dog (8/6/2009)
Hi,
my goal here is to capture all the queries that run now that cause the CPU to become over 90%.
my CPU get to 90-100 a lot of time.
so i...
--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 7, 2009 at 8:05 pm

#1036360
RE: Determine Row Size on a Table

ps (8/6/2009)
Rows_Per_Page = 8096 / (Row_Size + 2)
I've always been confused abt this part of the overall equation. How exactly adding 2 to the number of rows helps in finding...
--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 7, 2009 at 7:59 pm

#1036358

Viewing 15 posts - 42,451 through 42,465 (of 59,102 total)