Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,656 through 47,670 (of 59,099 total)

RE: Shrinkfile and log backup

victor_bosc (10/23/2008)
As your previous posts you do not recommend recommend rebuilding indexes and shrinking. I agree with that periodically shrinking is not a good idea, but should I NEVER 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)

October 23, 2008 at 7:51 pm

#888986
RE: OSQL

Technically, yes. But it's against the license agreement.
--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)

October 23, 2008 at 7:44 pm

#888985
RE: importing txt files to sql tables

Yeah... but do you need to use DTS or SSIS or is doing it all in T-SQL without the use of xp_CmdShell ok?
--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)

October 23, 2008 at 7:42 pm

#888984
RE: Calculating Work Days

Heh... dang managers all need to take a course in how to effectively plan and schedule a software project for success. 😉
Anyway, glad it does what you want 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)

October 23, 2008 at 7:17 pm

#888983
RE: Calculating Work Days

Heh... cool! But, you don't really hate RBAR... or you wouldn't be using 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)

October 22, 2008 at 9:33 pm

#888449
RE: Calculating Work Days

Yes... short answer would be to use a calendar table to get the smallest non-holiday, non-weekend date that is >= 15 days 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)

October 22, 2008 at 4:32 pm

#888398
RE: Need help on performance and integrity

I swear I've done this problem on this forum before... :hehe:
Dan, in the GIF file example, please tell me why RowID 10 is NOT considered to be a dupe of...
--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)

October 21, 2008 at 8:28 pm

#887913
RE: SQL Server 2000

Oh yeah... I forgot to mention that, Matt. Thanks for the reminder,
Shifting gears a bit here... What a PITA.... I hate it when they do stuff like that... 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)

October 21, 2008 at 7:02 pm

#887899
RE: user tables and data types

You're welcome and thanks for the feedback. Just to be clear, it's a view... not a 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)

October 21, 2008 at 6:42 pm

#887894
RE: Query Analyzer sends 'Results to File'

I think it's because you've not identified the database where the table is at in your query. Try using a 3 part name for the table in th Query.
--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)

October 21, 2008 at 6:39 pm

#887893
RE: SQL Server 2000

Dunno if it 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)

October 21, 2008 at 6:24 pm

#887891
RE: Cannot insert duplicate key row in object 'sysmergeschemachange' with unique index 'schemachangeversion'.

marcos jose (10/18/2008)
... and, why not change to sql server 2000?
Heh... Why not change to 2k5 or 2k8?
--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)

October 21, 2008 at 11:10 am

#887739
RE: Extreme long UPDATE action, advice needed.

FreeHansje (10/21/2008)
Something funny is going on, I have to go deeper into this.
Jeff, the statement is as given in my first post. I get about 13000 1-row-effected messages in 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)

October 21, 2008 at 5:10 am

#887515
RE: Who Wants to Be Rich?

See? What a rich man I am to have such good friends as Barry. We've had more darned fun on these forums.
Thanks for the laugh, Barry. 🙂
--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)

October 20, 2008 at 11:45 pm

#887426
RE: Who Wants to Be Rich?

rbarryyoung (10/20/2008)
Jeff Moden (10/20/2008)
Heh... which definition of "diatribe" do you mean here? 😛
1 archaic : a prolonged discourse
2: a bitter and abusive speech or writing
3: ironic or satirical criticism
... ...
--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)

October 20, 2008 at 11:12 pm

#887419

Viewing 15 posts - 47,656 through 47,670 (of 59,099 total)