Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,241 through 39,255 (of 59,072 total)

RE: TempDB doing my nut in

Mr J (3/17/2010)
Hi Jeff,
It's hard to say just how big it wants to get, because it always runs out of HD, but i can tell you it gobbles up 40...
--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)

March 18, 2010 at 4:37 pm

#1136369
RE: Are the posted questions getting worse?

David Burrows (3/18/2010)
BWAAAHAAA....
TWANG......
Hmmmmm... the possible makings of new T-Shirt.:-P
--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)

March 18, 2010 at 3:30 pm

#1136348
RE: TSQL using parameters does not use the index

BWAA-HAAA!!! "It depends". 😉
--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)

March 18, 2010 at 2:15 pm

#1136303
RE: Are the posted questions getting worse?

john.arnott (3/18/2010)
Lynn Pettis (3/17/2010)
Like clustered indexes are better than nonclustered indexes?
Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could...
--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)

March 18, 2010 at 2:03 pm

#1136287
RE: Representing a hierarchy from comma separated values

pYak (3/17/2010)
Can I do this with a set based solution?
The answer is... kind of. In SQL Server 2005 and below, you need some form of looping for Hierarchy resolution...
--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)

March 18, 2010 at 7:34 am

#1135940
RE: How to pass a Microsoft certification [70-432]

I can certainly understand not having any access to the internet during an exam... but not having access to BOL doesn't seem right to me. It's a tool (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)

March 17, 2010 at 11:48 pm

#1135744
RE: Querying reserved words?

There's a list of reserved words in Books Online and it's not limited to just T-SQL.
--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)

March 17, 2010 at 11:41 pm

#1135739
RE: Should We Lead or Follow?

Heh... and sometimes you have to PUSH! 😛
--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)

March 17, 2010 at 11:36 pm

#1135736
RE: Statement referencing column that doesn't exist yet

Not trying to be a smart guy here...
It's normally a very bad idea to programatically add a column as a matter of course and it's usually really bad if it's...
--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)

March 17, 2010 at 11:32 pm

#1135734
RE: Date format no matter the server settings

Digs (3/17/2010)
Any ideas
Yes... NONE of these problems would exist if the dates and times were properly stored as DATETIME data instead of VARCHAR 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)

March 17, 2010 at 11:27 pm

#1135730
RE: Should We Lead or Follow?

Heh... feedback... it was "feedback" that was supposedly responsible for that bloody "ribbon" in Office 2007.
I've found the same thing even on some of the MVP sites. ...
--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)

March 17, 2010 at 11:19 pm

#1135726
RE: Are the posted questions getting worse?

Alvin Ramard (3/17/2010)
CirquedeSQLeil (3/17/2010)
A thought just occurred to me.
We see several people complaining about the English in the QOD. What if we responded to all QOD comments for 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)

March 17, 2010 at 11:00 pm

#1135718
RE: An Urgent Ad Hoc Report

I very much appreciate this article as we've all had a similar problem at one time or another and they always seem to pop up when you have an after...
--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)

March 17, 2010 at 9:44 pm

#1135695
RE: Are the posted questions getting worse?

Lynn Pettis (3/17/2010)
[font="Comic Sans MS"]Looks like the TitD (Tent in the Desert) will be hosting another party fairly soon!![/font]
Jeff only needs 83 more posts to break the 20,000 posts mark!
Heh......
--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)

March 17, 2010 at 7:01 pm

#1135665
RE: Nested Loop Joins on Temp Tables

ryan.hart (3/17/2010)
I don't know why statistics are disabled. I'm afraid it's not a temporary condition, though... unless I can convince them to rethink it! The one person 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)

March 17, 2010 at 6:55 pm

#1135661

Viewing 15 posts - 39,241 through 39,255 (of 59,072 total)