Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,046 through 42,060 (of 59,102 total)

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
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

Viewing 15 posts - 42,046 through 42,060 (of 59,102 total)