Jeff Moden

Forum Replies Created

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

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

Maxer - Tuesday, October 2, 2018 8:22 AM
OK this is more strange:
We took a NEW user, should be the same as 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)

October 2, 2018 at 8:27 am

#2007707
RE: Give Up on Natural Primary Keys

DinoRS - Tuesday, October 2, 2018 6:32 AM
I would go even further to not just avoid Natural Primary Keys but aswell PKs...
--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 8:24 am

#2007704
RE: Wrong estimate when inserting in multiple sessions

Bouke Bruinsma - Tuesday, October 2, 2018 7:39 AM
Jeff Moden - Tuesday, October 2, 2018 7:32 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 2, 2018 at 8:11 am

#2007697
RE: Wrong estimate when inserting in multiple sessions

I'm not sure how you're running your test. If I run the first session without the rollback, the second session doesn't run because of the blocking transaction. When I rollback...
--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:32 am

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

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