Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,451 through 45,465 (of 59,095 total)

RE: Manual or auto - growth of datafiles

ian McCann (1/28/2009)
My understanding is that manually growing the files can also contribute to physical file fragmentation.
Look to the link for more information.
http://www.mssqltips.com/tip.asp?tip=1481
Actually, manual and automatic growth will both contribute...
--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 2:41 pm

#934228
RE: Creating a veiw with a sum

Cool... do you have a question?
--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 2:38 pm

#934222
RE: My company decided not to upgrade any software this year!!

Loner (1/28/2009)
I am worried my skills set will be out dated soon.
Heh... everyone that asks that question/makes that statement, simply needs to start answering some on this forum. Your...
--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 2:37 pm

#934221
RE: Can I reseed an identity column with data still in the column/table

Pat_B (1/28/2009)
Say I have a tableA with the following columns:
ID (PK, int, identity, not null)
name (varchar(50), not null)
address (varchar(50), not null)
I originally had the identity seed set at 0, 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)

January 28, 2009 at 2:32 pm

#934210
RE: The best way to identify matching records in a single table

I wonder if anyone realizes just how many MANNY COSTA's there are in Bristol, RI. 2 out of 3 on the date of birth just isn't going to get...
--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 2:28 pm

#934204
RE: Trying to rewrite RBAR Function

Not sure which one of those include the Tally table function that I wrote. Did you test that, as well?
--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 1:39 pm

#934148
RE: Are the posted questions getting worse?

Lynn Pettis (1/28/2009)
ARRRRGGGGGG!!!
And the man keeps running even further into the desert.....
Heh... whad'ya do there, Lynn? Pull a nose hair? Or dislodge a pork chop? 😛
--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 1:36 pm

#934142
RE: Are the posted questions getting worse?

That's a heck of a compliment. Posts like that make it all worthwhile. Thanks for taking the time to post 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 1:33 pm

#934137
RE: What are the Party Plans?

John Dempsey (1/28/2009)
Jeff Moden (1/28/2009)
Ok, Steve... to celebrate, you start loading us up with cookies? What's the deal with the ScreenCast.com session cookies that have suddenly started showing up?
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)

January 28, 2009 at 12:46 pm

#934095
RE: What are the Party Plans?

Heh... tell that to Rog Pike (aka Steve Dussin). 😛
--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:24 pm

#934083
RE: SQL or Oracle

Well said. Thanks for taking the time.
Yeah... I use that one, alot...
"okay, how do I return a result set from a stored procedure?" I just love building...
--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:23 pm

#934082
RE: What are the Party Plans?

Ok, Steve... to celebrate, you start loading us up with cookies? What's the deal with the ScreenCast.com session cookies that have suddenly started showing up?
--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:11 pm

#934078
RE: What are the Party Plans?

John Dempsey (1/28/2009)
... first, I'd love a copy, so click on my name to the left and send me an email. I'll respond and then you can send me...
--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:10 pm

#934075
RE: Hidden RBAR: Triangular Joins

David.Poole (1/28/2009)
Why do the Britts always say 'Ten minutes Time'? Are there any other kind of Minutes?"
A minute amount of time might be defined as ten minutes according to...
--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:08 pm

#934072
RE: Table Variables and performance

Peso (1/28/2009)
Jeff Moden (1/28/2009)
Increase performance of queries that use deterministic computed columns.
Persisted computed columns can also be indexed 🙂
http://msdn.microsoft.com/en-us/library/ms189292(SQL.90).aspx
Yep... found that out at the same time. That's because they're...
--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:06 pm

#934069

Viewing 15 posts - 45,451 through 45,465 (of 59,095 total)