Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,201 through 10,215 (of 59,093 total)

RE: Cloning SQL Server Instances with Containers

Great introduction to containers. Thanks for taking the time to post it.
The thing that I don't understand is, considering that it starts out with a restore of 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)

December 31, 2018 at 6:13 am

#2017642
RE: trigger blues no primary key

jcelko212 32090 - Sunday, December 30, 2018 3:59 PM
fizzleme - Thursday, December 27, 2018 11:12 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)

December 31, 2018 at 5:35 am

#2017639
RE: Primary keys for an OLTP database

Eirikur Eiriksson - Sunday, December 30, 2018 10:53 AM
Jeff Moden - Sunday, December 30, 2018 9:45 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)

December 30, 2018 at 1:03 pm

#2017619
RE: Primary keys for an OLTP database

Eirikur Eiriksson - Saturday, December 29, 2018 8:08 AM
My i5-4310U 4 Logical Cores @ 2.00GHz system, 512GB SSD, Microsoft SQL Server...
--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)

December 30, 2018 at 9:45 am

#2017616
RE: Primary keys for an OLTP database

xsevensinzx - Saturday, December 29, 2018 7:11 AM
Jeff Moden - Friday, December 28, 2018 9:24 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)

December 30, 2018 at 9:33 am

#2017615
RE: Primary keys for an OLTP database

Lynn Pettis - Friday, December 28, 2018 2:52 PM
Jeff Moden - Friday, December 28, 2018 9:41 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)

December 28, 2018 at 4:05 pm

#2017568
RE: Suggestions on How to Improve Delete

RGP - Friday, December 28, 2018 8:49 AM
Jeff Moden - Friday, December 28, 2018 7:17 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)

December 28, 2018 at 3:32 pm

#2017564
RE: Primary keys for an OLTP database

steve.homer@gmail.com - Friday, December 28, 2018 6:30 AM
Jeff Moden - Thursday, December 27, 2018 8:50 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)

December 28, 2018 at 9:41 am

#2017533
RE: Primary keys for an OLTP database

xsevensinzx - Friday, December 28, 2018 8:08 AM
Jeff Moden - Friday, December 28, 2018 7:54 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)

December 28, 2018 at 9:24 am

#2017528
RE: Primary keys for an OLTP database

Eirikur Eiriksson - Thursday, December 27, 2018 4:25 AM
Thanks for the write up Evgeny!
😎
One thought on the test setup, the loop...
--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)

December 28, 2018 at 8:59 am

#2017522
RE: Primary keys for an OLTP database

RonKyle - Friday, December 28, 2018 7:37 AM
I would assign an integer, which would ideally server as the Employee Number. We...
--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)

December 28, 2018 at 8:02 am

#2017506
RE: Primary keys for an OLTP database

xsevensinzx - Friday, December 28, 2018 7:47 AM
I've said it in other threads, did not like the performance of a clustered GUID...
--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)

December 28, 2018 at 7:54 am

#2017504
RE: Primary keys for an OLTP database

RonKyle - Thursday, December 27, 2018 12:00 PM
Slow may be a relative term. A GUID to GUID join is going to...
--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)

December 28, 2018 at 7:41 am

#2017502
RE: Primary keys for an OLTP database

sqlvogel - Friday, December 28, 2018 2:27 AM
Jeff Moden - Thursday, December 27, 2018 5:42 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)

December 28, 2018 at 7:29 am

#2017500
RE: Suggestions on How to Improve Delete

RGP - Friday, December 28, 2018 6:45 AM
Jeff Moden - Thursday, December 27, 2018 4:49 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)

December 28, 2018 at 7:17 am

#2017499

Viewing 15 posts - 10,201 through 10,215 (of 59,093 total)