Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,956 through 50,970 (of 59,091 total)

RE: Restrict DBO user

Lynn (4/24/2008)
I can't put these tables in a separate db because the application will break.
Oh, yes you can... put the tables in a different DB and either make "surrogate views"...
--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)

April 26, 2008 at 11:31 am

#807513
RE: Updating the rows with Identity values

Just alter the table to add the ID column making sure that it has the IDENTITY property included.
--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)

April 26, 2008 at 11:28 am

#807512
RE: Performance Problem

The first 3 things I'd do is...
1. Update to sp2 and apply the latest cumulitive update (#7, I believe).
2. Turn off autoshrink. If it keeps growing, 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)

April 26, 2008 at 11:27 am

#807511
RE: DTS - loading mixed data types from text file.

Thanks for the feedback, Gene, and good luck on your efforts! Let us know if anything comes up... maybe give us some feedback on what you ended up doing....
--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)

April 26, 2008 at 11:08 am

#807510
RE: The Exceptional DBA: Soft Skills

You've summarized the soft skills very nicely, Tony. And, I absolutely agree, David Poole's well thought out statement of "if people will voluntarily use you as the first point...
--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)

April 26, 2008 at 10:49 am

#807508
RE: DTS - loading mixed data types from text file.

intvfan (4/26/2008)
I still would love to have the log not grow!!! I am loading millions of rows in several tables.
I would love to BULK load. Do you bulk...
--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)

April 26, 2008 at 9:12 am

#807505
RE: Date String

You don't need to worry about DateFirst with the following...
[font="Courier New"] SELECT LEFT(DATENAME(dw,GETDATE()),3)
+ ', ' + CONVERT(VARCHAR,GETDATE(),106)[/font]
--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)

April 25, 2008 at 8:41 pm

#807475
RE: Cursor ends when I don't want it too

Have you got a server called "FindUsers"??? That's where the error is on my machine...
--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)

April 25, 2008 at 8:36 pm

#807474
RE: Can't see owned tables

Sounds like someone changed a role or reassigned a role. Maybe even changed to Windows Authentication without doing the necessary work to keep privs.
--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)

April 25, 2008 at 8:25 pm

#807471
RE: DTS - loading mixed data types from text file.

I import all columns as VARCHAR and evaluate from there. You should only import to a staging table... there you can make such decisions before transferring to the final...
--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)

April 25, 2008 at 8:22 pm

#807470
RE: Extracting Rows from Delimited Strings

Matt Miller (4/25/2008)
Jeff - that last code nulls out the 0's in the 3rd column - is it supposed to?
Nah... I screwed up.
The real key to this whole thing 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)

April 25, 2008 at 8:17 pm

#807468
RE: CTE's are useless

Seggerman (4/25/2008)
There are times (not too often) where speed at any cost is unwise
I may be a newbie at SQL Server but in computer programming for over 3 decades
my current...
--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)

April 25, 2008 at 8:00 pm

#807466
RE: User Defined Function - Passing and Processing a Table

rbarryyoung (4/16/2008)
I am confused. Why isn't robert's answer sufficient?
I agree... why is everyone still looking for an aggegate function and passing columns of data when Robert's very simple formula...
--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)

April 25, 2008 at 7:42 pm

#807464
RE: BCP Trigger Hangs up Insert Statement

Another problem other than the ones already stated is that even if all of this worked correctly, BCP destroys existing files and overwrites them.
I may have a work-around for this,...
--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)

April 25, 2008 at 7:28 pm

#807463
RE: DELETE DUPLICATE RECORDS

Ariel Dimapilis (4/23/2008)
Hi All
Anyone can help me how to delete a duplication records retain one value in one table
Can anyone give a script for deleting duplicates records.
Please help me, I'm...
--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)

April 25, 2008 at 5:29 pm

#807446

Viewing 15 posts - 50,956 through 50,970 (of 59,091 total)