Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,496 through 45,510 (of 59,095 total)

RE: CLR Running in Mirrored Environment

Heh... and we still don't know what the CLR does, do we? 😉
--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)

January 28, 2009 at 5:59 am

#933723
RE: Hierarchies in SQL

Nicely done, Gus. And, considering that the article is about a fix you made for an actual problem having to do with Adjacency and Nested Set methods, 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)

January 28, 2009 at 5:33 am

#933711
RE: Get 2nd Occurence

Trigger (1/27/2009)
Jeff,
There will only be 2 spaces and no periods.
In that case... I'm not sure it's any faster (haven't done the ol' million row test on this one), but it...
--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)

January 28, 2009 at 5:13 am

#933704
RE: CLR Running in Mirrored Environment

I was hoping the op would tell me... but Ok... what does the CLR actually do? Remember, I'm not much into GUI's or WebServices.
--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)

January 28, 2009 at 12:04 am

#933643
RE: Trying to rewrite RBAR Function

...and Jean-François came up with one of the very few places where a memory-only While Loop actually squeaks past the Tally table (at least on my machine, it does). ...
--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)

January 27, 2009 at 11:08 pm

#933634
RE: Trying to rewrite RBAR Function

p.s. Wrapping the problem up in a couple of "Free Pizza" coupons and wrapping that in a cold case of beer would give me better incentive to look 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)

January 27, 2009 at 9:16 pm

#933613
RE: Trying to rewrite RBAR Function

Jean-François Bergeron (1/27/2009)
I'm surprised to see Jeff did not throw in something, I thought RBAR was the trigger for an answer! 😉
Heh... what... you think I do a search 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)

January 27, 2009 at 9:07 pm

#933611
RE: Trying to rewrite RBAR Function

noeld (1/27/2009)
I have found that the best solution for this is to use persisted calculated columns!
Haven't tried those yet, Noel... can you give us a quick "how to" 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)

January 27, 2009 at 9:05 pm

#933609
RE: CLR Running in Mirrored Environment

What would be even more interesting is finding out what the CLR actually does.
--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)

January 27, 2009 at 8:48 pm

#933604
RE: Earning Credit

Writing can be hard.
Heh... I'd have to say it's a real bugger for me. I don't know how you do it everyday. My hat's off to you.
--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)

January 27, 2009 at 8:47 pm

#933603
RE: Execution Plans

phoqueme (1/27/2009)
When giving examples, there is no need to blunder through every possible case of Table Scans before "realizing" MS SQL will only use the index scan on the column...
--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)

January 27, 2009 at 8:30 pm

#933599
RE: help me in improving my server performance

Stop using SSIS for ETL. Use BULK INSERT and some good T-SQL programming, instead.
--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)

January 27, 2009 at 8:17 pm

#933597
RE: HELP WITH QUERY

JROCK (1/27/2009)
Thanks Lynn for the quick response. I was thinking that we could do an update query to select all records that was less than 9 characters long. ...
--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)

January 27, 2009 at 8:11 pm

#933595
RE: Get 2nd Occurence

What is the maximum number of spaces that could occur and are periods ever going to appear in the data?
--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)

January 27, 2009 at 8:09 pm

#933594
RE: SQL 2005 Ad-hoc reporting

Oh, yea... almost forgot. If you're going to allow end users to build their own queries through and ad hoc reporting tool, even if it's something as sophisticated as...
--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)

January 27, 2009 at 8:06 pm

#933593

Viewing 15 posts - 45,496 through 45,510 (of 59,095 total)