Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,001 through 42,015 (of 59,067 total)

RE: Am I the only DBA

Perhaps you should also 😉
--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)

September 9, 2009 at 9:01 am

#1051197
RE: Performance issue with tally solution

budi.bong (9/9/2009)
How can I perform SQL SELECT FROM or given a SqlXml object?
Just a suggestion to get the right kind of help... rather than posting this on a thread having...
--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)

September 9, 2009 at 8:52 am

#1051184
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

Heh... oh, be careful, David. While it's true that sometimes the "Squeaky wheel gets the grease", it's also true that sometimes the "Squeaky wheel gets greased" if you understand...
--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)

September 9, 2009 at 8:41 am

#1051171
RE: Using the Best

jonathan allen (9/8/2009)
Buck Woody's blog is quoted as saying 'the best' depends on circumstances. Some of us are in that predicament when it comes to training, knowledge, time and resources.
Thanks...
--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)

September 9, 2009 at 1:31 am

#1050938
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

Heh... of course, the proper way to fix this would be to correctly normalize the data with a separate company name column. But, I suspect that's not currently an...
--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)

September 9, 2009 at 1:05 am

#1050925
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

David Lester (9/8/2009)
Thanks, I had also reached the conclusion I would have to have a way to know the entry was a person vs not a person. It occured...
--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)

September 9, 2009 at 1:03 am

#1050923
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

Jack Corbett (9/8/2009)
Darn it Jeff, I know I have seen that solution somewhere before, don't know if it was by you or not, but I wish I would have remembered...
--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)

September 9, 2009 at 12:44 am

#1050917
RE: Deadlocking while running constant inserts/updates against tables

Clint (9/8/2009)
However, the stored procedure that moves them from the staging to the main tables is always the point of deadlock.
Post that code right away...
--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)

September 9, 2009 at 12:30 am

#1050909
RE: Can I use a cursor Inside of a Function

Oh my, no....
You don't need the slothfulness nor resource usage of a cursor here. I don't have access to an SQL Server this week but consider the following code...
DECLARE...
--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)

September 9, 2009 at 12:17 am

#1050908
RE: equivalent for rownum

PaulB (9/8/2009)
newbieuser (9/8/2009)
I do 'select rownum from table' in oracle to select rows ordered by rownum.
:w00t: No, you don't.
In the Oracle world rownum is a pseudo-column, Oracle assigns -to rownum-...
--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)

September 8, 2009 at 11:48 pm

#1050906
RE: OPTION (Max Recursion)

It'll take quite a while, Fraggle. I won't even be near a computer with SQL Server on it for another week.
--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)

September 8, 2009 at 9:27 pm

#1050890
RE: Am I the only DBA

Silverfox (9/8/2009)
Roy Ernest (9/8/2009)
Hey Fox, That was a low blow...:hehe:
😛 Go jeff 😛
It's ok... you can stand up now. 😉
--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)

September 8, 2009 at 9:24 pm

#1050888
RE: CLR initialization permanently failed

Tim Peters (9/3/2009)
I've already agreed with the developers to recode this skipping the CLR as it's a simple date calculation. I'm not sure why they went CLR in the first...
--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)

September 8, 2009 at 9:08 pm

#1050887
RE: Am I the only DBA

Silverfox (9/8/2009)
Do you know that your surname also spells Demon, not trying to say anything here. but your comment gives me cause for worry...
Damn... I've been found out... let that...
--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)

September 8, 2009 at 2:11 pm

#1050785
RE: Strange group by requirement!

nick (9/8/2009)
Thanks for the example, but I think you have missed the point that my date isnt one standard datetime field, its actually made up
of two columns, date and time.
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)

September 8, 2009 at 1:47 pm

#1050774

Viewing 15 posts - 42,001 through 42,015 (of 59,067 total)