Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,161 through 47,175 (of 59,095 total)

RE: Tips for New DBAs

I've got a hell of a lot of comments to make about this article... but, let me summarize, instead...
[font="Arial Black"]"Oh... very well done. Should be required reading for everyone...
--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)

November 18, 2008 at 6:17 am

#899860
RE: Help writing function to get decimal from string

BWAA-HAA! I guess it's because I need more coffee, as well! Maybe that qualifies. 😛
--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)

November 18, 2008 at 6:09 am

#899854
RE: Find out which table columns were inserted from within a trigger

Just remember that you will get an advisory about total row length exceeding 8060 bytes if you use more than a very small handful of columns in the same table...
--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)

November 18, 2008 at 6:07 am

#899853
RE: Help writing function to get decimal from string

Garadin (11/18/2008)
Jeff Moden (11/18/2008)
The really good part about it all is that no matter what goes wrong, I always learn something new even if it's only how to "read minds"...
--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)

November 18, 2008 at 6:02 am

#899847
RE: Select based on Date- How to?

mpdillon (11/18/2008)
But this time I wanted to find a more intuitive method. Some(OK most) of my queries are difficult to read. Having to interpret dates makes them even more so...
--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)

November 18, 2008 at 5:58 am

#899842
RE: Recursive is query is slow

vkundar (11/18/2008)
Jeff thanks for the links.
gborasaniya you are right as this in data warehousing environment mainly in ETL we have constraints on using or creating indexes. we need to deal...
--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)

November 18, 2008 at 5:35 am

#899824
RE: Help writing function to get decimal from string

Chris Morris (11/18/2008)
How often have you spent hours, even days, on a solution for a desperate punter only to find they've not bothered to post all the details of 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)

November 18, 2008 at 5:30 am

#899818
RE: Help writing function to get decimal from string

Dooza (11/18/2008)
... and was setup like this by the developers.
Heh... of that, I have no doubt. Thanks for the feedback, Steve. 🙂
--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)

November 18, 2008 at 5:27 am

#899817
RE: Find out which table columns were inserted from within a trigger

Grant Scanlen (11/18/2008)
It will never be the case that the values in any of these columns will exceed 900 bytes, as the underlying data type is numeric(28,14).
Grant
I guess SQL_Variant will...
--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)

November 18, 2008 at 5:24 am

#899813
RE: Best way to convert a datetime field into a char(8) '20081117' in dataflow

aaa (11/18/2008)
It does have a datetime field but this contains 2008-11-01 00:00:00.000 and so on. So if we have a datetime field with 2008-11-01 12:58:21.000 we cannot use this field...
--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)

November 18, 2008 at 5:19 am

#899809
RE: Help writing function to get decimal from string

Dooza (11/18/2008)
am so glad my server ain't screwed!
Steve
Man, me too! Thanks Chris. Sorry I forgot about the server maybe being case sensitive... that's the good thing 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)

November 18, 2008 at 5:08 am

#899800
RE: Help writing function to get decimal from string

Chris Morris (11/18/2008)
Jeff Moden (11/17/2008)
Chris Morris (11/17/2008)
Jeff, perfick solution as always!
Serious or sarcasm? Can't tell from here.
Aw Jeff you should know me better than that!
This...
WHERE t.N BETWEEN CHARINDEX('(',@String)...
--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)

November 18, 2008 at 5:05 am

#899796
RE: Adding a Total Column with a Pivot Table

Heh... thanks Jason. Maybe I should change my avatar to [font="Arial Black"]þ[/font], huh? 😛
--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)

November 18, 2008 at 4:58 am

#899789
RE: Searching for UDF on this site

Dunno which one you're looking for, but the following article has one of the better ways of doing it...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

November 17, 2008 at 9:37 pm

#899673
RE: Best way to convert a datetime field into a char(8) '20081117' in dataflow

Why does the dimension table have dates that have been converted to varchar to begin with?
--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)

November 17, 2008 at 9:34 pm

#899671

Viewing 15 posts - 47,161 through 47,175 (of 59,095 total)