Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,101 through 11,115 (of 59,095 total)

RE: Max size file in BCP process

Just a word of caution... I've found that parallel loads are frequently not worth it. Your target doesn't have more read/write heads than it does with a serial load. Because...
--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 2, 2018 at 7:07 am

#2007669
RE: Give Up on Natural Primary Keys

sqlvogel - Tuesday, October 2, 2018 12:10 AM
I find it strange that we still see articles like this discussing "primary" keys. 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 2, 2018 at 5:56 am

#2007657
RE: SQL Server 2008 R2 SP3 intermittent can't connect to server

I'm thinking that the TCPIP address changed. Try connecting using the instance name instead of the TCPIP address.
--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 1, 2018 at 7:02 pm

#2007627
RE: Windows user has SELECT and DB_DATAREADER writes still gets: "The SELECT permission was denied on the object"

Who owns the non-dbo schema?
--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 1, 2018 at 6:57 pm

#2007626
RE: Give Up on Natural Primary Keys

RonKyle - Monday, October 1, 2018 1:17 PM
...
--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 1, 2018 at 6:19 pm

#2007625
RE: Give Up on Natural Primary Keys

Lynn Pettis - Monday, October 1, 2018 3:11 PM
Part of the logical design of tables is identifying the Candidate Keys, those...
--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 1, 2018 at 6:13 pm

#2007624
RE: Give Up on Natural Primary Keys

RonKyle - Monday, October 1, 2018 11:12 AM
Sorry, but you're wrong. The first duty of a DBA, or data steward if...
--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 1, 2018 at 12:41 pm

#2007574
RE: Give Up on Natural Primary Keys

RonKyle - Monday, October 1, 2018 10:41 AM
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)

October 1, 2018 at 11:07 am

#2007550
RE: Give Up on Natural Primary Keys

Victor Kirkpatrick - Monday, October 1, 2018 7:59 AM
--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 1, 2018 at 9:12 am

#2007524
RE: insert the records in Table 2 whenever the records delete in Table 1.

Jonathan AC Roberts - Monday, October 1, 2018 8:38 AM
below86 - Monday, October 1, 2018 8:28 AM
--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 1, 2018 at 9:02 am

#2007523
RE: insert the records in Table 2 whenever the records delete in Table 1.

below86 - Monday, October 1, 2018 8:28 AM
Jeff Moden - Monday, October 1, 2018 8:04 AM
--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 1, 2018 at 8:47 am

#2007518
RE: insert the records in Table 2 whenever the records delete in Table 1.

That'll work but, if you ever need to disable that particular functionality (especially temporarily), you'll need to do a code change rather than just disabling (or dropping) a trigger.
--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 1, 2018 at 8:04 am

#2007506
RE: Can i sort a cross tab horizontally?

More seriously, if you want some coded help, you need to provide a bit more information and it would really be nice if you could help us help you by...
--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 1, 2018 at 8:00 am

#2007503
RE: Can i sort a cross tab horizontally?

jeffshelix - Monday, October 1, 2018 7:17 AM
i have a report that shows top 20 sales each month for the past 12...
--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 1, 2018 at 7:59 am

#2007500
RE: insert the records in Table 2 whenever the records delete in Table 1.

adisql - Monday, October 1, 2018 7:46 AM
Hi,
I would like to insert the records in Table 2 whenever the records delete in 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 1, 2018 at 7:56 am

#2007499

Viewing 15 posts - 11,101 through 11,115 (of 59,095 total)