Jeff Moden

Forum Replies Created

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

RE: Determining whether a Stored Procedure returns a resultset

I don't believe there's an easy way to do that, all though I could certainly be wrong. The fly in the ointment is what happens if a sproc returns...
--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:24 pm

#934341
RE: A stored Proc inside a cursor inside a trigger

ian McCann (1/28/2009)
Thanks Lynn
I don't think I explained my needs very well.
My problem is not in fixing this ( I am actually looking forward to working with a tally table...
--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 3:09 pm

#934257
RE: Consecutive timespan

Christopher,
Andrew is correct... take a look at the link in my signature below to help us help you. Thanks.
--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 3:02 pm

#934251
RE: GUID not unique

timscronin (1/28/2009)
If you were going to convert a guid to a varchar would the conversion not be a varchar(36)?
Probably not... since all GUID's are 36 characters, why not save the...
--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:58 pm

#934246
RE: Manual or auto - growth of datafiles

There's only one thing that ultimately affects fragmentation... that's growth of files. Whether you set it manually or automatically, it's file growth. The best thing to do is...
--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:47 pm

#934235
RE: Manual or auto - growth of datafiles

aali_online (1/28/2009)
Fragmentation will depend on the speed of the disk subsystem
How do you figure that the speed of the disk has anything at all to do with disk fragmentation?
--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:43 pm

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

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