Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,841 through 12,855 (of 59,099 total)

RE: Today's Random Word!

ManicStar - Thursday, February 22, 2018 11:15 AM
Ed Wagner - Thursday, February 22, 2018 5:58 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)

February 22, 2018 at 11:26 am

#1980818
RE: How would you lock down a SQL DBA to have local admin on the SQL box

ffarouqi - Thursday, February 22, 2018 10:59 AM
Steve Jones - SSC Editor - Thursday, February 22, 2018...
--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)

February 22, 2018 at 11:25 am

#1980816
RE: Is db_datareader and db_datawriter *typically* all that's needed?

Lynn Pettis - Thursday, February 22, 2018 10:54 AM
Yes, db_datareader and db_datawriter could be considered the minimum. The others are not typically...
--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)

February 22, 2018 at 11:22 am

#1980814
RE: Is db_datareader and db_datawriter *typically* all that's needed?

IMHO, the "Gold Standard" would be to not allow any privs to user or apps other than "PUBLIC" and privs to run certain stored procedures.
--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)

February 22, 2018 at 10:26 am

#1980799
RE: Performance Comparison Between SQL Server 2014 and 2016

In high contrast to what's in this good article, the change in the Cardinality Estimator for the upgrade from 2012 to 2016 crushed performance on several rather complicated queries 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)

February 22, 2018 at 7:39 am

#1980770
RE: Need to get consecutive duplicate rows

jcelko212 32090 - Wednesday, February 21, 2018 7:30 PM
Jeff Moden - Wednesday, February 21, 2018 3:59 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)

February 22, 2018 at 7:01 am

#1980765
RE: Importing Loads of Fixedwidth flatfiles

stiej1977 - Thursday, February 22, 2018 2:31 AM
Thanks all. So a sample from the supplier documentation re the schema of one 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)

February 22, 2018 at 6:46 am

#1980760
RE: Need to get consecutive duplicate rows

jcelko212 32090 - Wednesday, February 21, 2018 3:23 PM
Jeff Moden - Wednesday, February 21, 2018 2:34 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)

February 21, 2018 at 3:59 pm

#1980709
RE: Triggers or best option

jcelko212 32090 - Wednesday, February 21, 2018 3:37 PM
(2) triggers are procedural code and this is a declarative language
--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)

February 21, 2018 at 3:52 pm

#1980707
RE: Need to get consecutive duplicate rows

jcelko212 32090 - Wednesday, February 21, 2018 2:06 PM
since rows have no ordering whatsoever in RDBMS, the whole concept of â€œconsecutiveâ€ has...
--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)

February 21, 2018 at 2:34 pm

#1980692
RE: Need to get consecutive duplicate rows

jcelko212 32090 - Wednesday, February 21, 2018 2:05 PM
pfefferl - Friday, February 16, 2018 1:57 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)

February 21, 2018 at 2:31 pm

#1980691
RE: Importing Loads of Fixedwidth flatfiles

ZZartin - Wednesday, February 21, 2018 12:49 PM
stiej1977 - Wednesday, February 21, 2018 8:44 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)

February 21, 2018 at 2:29 pm

#1980690
RE: Transaction Log Growth

Mike Scalise - Wednesday, February 21, 2018 9:01 AM
Jeff, great information about all of the indexes. I never knew there were so...
--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)

February 21, 2018 at 12:44 pm

#1980671
RE: Importing Loads of Fixedwidth flatfiles

stiej1977 - Wednesday, February 21, 2018 8:44 AM
hi
i've got a big bundle of fixedwidth flatfiles to import.
i have the supplier documentation 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)

February 21, 2018 at 12:29 pm

#1980669
RE: Help/Advise - Setting up a Dev Platform, on the Prod Platform, same one Server, Some Shared Instances

quinn.jay - Wednesday, February 21, 2018 9:28 AM
In this one box setup I have, if I added one more DB for Dev...
--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)

February 21, 2018 at 10:55 am

#1980660

Viewing 15 posts - 12,841 through 12,855 (of 59,099 total)

Jeff Moden

Forum Replies Created

RE: Today's Random Word!

RE: How would you lock down a SQL DBA to have local admin on the SQL box

RE: Is db_datareader and db_datawriter typically all that's needed?

RE: Is db_datareader and db_datawriter typically all that's needed?

RE: Performance Comparison Between SQL Server 2014 and 2016

RE: Need to get consecutive duplicate rows

RE: Importing Loads of Fixedwidth flatfiles

RE: Need to get consecutive duplicate rows

RE: Triggers or best option

RE: Need to get consecutive duplicate rows

RE: Need to get consecutive duplicate rows

RE: Importing Loads of Fixedwidth flatfiles

RE: Transaction Log Growth

RE: Importing Loads of Fixedwidth flatfiles

RE: Help/Advise - Setting up a Dev Platform, on the Prod Platform, same one Server, Some Shared Instances