Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,016 through 42,030 (of 59,067 total)

RE: Memory pressure when calling a C# assembly

I can't help on the problem you're having, Daniel, but I am curious... what does the CLR do?
--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:37 pm

#1050762
RE: OPTION (Max Recursion)

TheSQLGuru (9/7/2009)
I look forward to learning from your efforts Jeff!!
Heh... me too, Kevin. 😛
Yep... I'm going to PASS this year... learned my lesson by missing it last year.
--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:27 pm

#1050748
RE: OPTION (Max Recursion)

Paul White (9/7/2009)
This is NOT an on-line dating service :laugh:
BWAA-HAA!!!... says the man wearing a blanket over his head. 😀
--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:26 pm

#1050744
RE: Row in a table is out of sequence or not

That's one of the easiest and fastest ways to do it. Any chance you can post the code... two reasons for that... first, it's a two way street...
--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:20 pm

#1050742
RE: What on earth is a Database Administrator Architect

Silverfox (9/8/2009)
I am intrigued to know your Title though. As you have mentioned you are not titled as a DBA. :-P.
Heh... "Sr. Turtle Furlong per Fortnight Counter". 😛
--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:10 pm

#1050735
RE: Will creating more indexes lead to deadlock?

Indexes really don't have much of anything to do with the creation of deadlocks although the addition of an index can sometimes increase performance well enough to eliminate some deadlocks.
My...
--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:03 am

#1050578
RE: Am I the only DBA

Silverfox (9/7/2009)
Just out of curiosity, Am I the only DBA that doesnt have a laptop or a desktop and no sql books, who didnt go to university :-D, doesnt have...
--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 8:57 am

#1050572
RE: What on earth is a Database Administrator Architect

I have to ask... what's in a title and what does it matter? The company I currently work for wasn't allowed to hire another person with the simple title...
--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 8:51 am

#1050568
RE: Unique Index Causing Slow Read Performance

ben.mcintyre (9/8/2009)
I believe there is no other way (please correct me if there is !).
You've just not provided enough information to say one way or another but, 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)

September 8, 2009 at 8:32 am

#1050556
RE: Unique Index Causing Slow Read Performance

ben.mcintyre (9/4/2009)
I realise the temp tables are a viable workaround (and one I have used in places), but this is for reporting and it means rather than simply constructing 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)

September 8, 2009 at 8:25 am

#1050549
RE: Unique Index Causing Slow Read Performance

GilaMonster (9/8/2009)
(Hey, please, I know this site is prettly much dedicated to the hunting down and elimination of dynamic SQL. I know what rbar is and who Jeff Moden...
--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 8:12 am

#1050536
RE: IF condition in CURSOR

Before you do, please read the following article for the best format to present that info in... it'll really help folks concentrate on your problem...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--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 8:05 am

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

Folks, it doesn't need to be ugly (although this won't take care of the double spaces at the end of a sentence) and it doesn't need to be difficult and...
--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 12:02 am

#1050311
RE: Using the Best

Aye... you've hit a sore spot for me. I love new things but only when they actually are the "best" for the job. When 2k5 first came out,...
--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 7, 2009 at 10:39 pm

#1050295
RE: OPTION (Max Recursion)

I'd love to see a performance test between HID's and the Nested Set Model for both up and downline queries as well as the addition and deletion of mid hierarchy...
--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 7, 2009 at 7:06 pm

#1050264

Viewing 15 posts - 42,016 through 42,030 (of 59,067 total)