Jeff Moden

Forum Replies Created

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

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
RE: Compression estimates

OnePunchDBA - Wednesday, February 21, 2018 7:13 AM
Good work but looks like you have reinvented the wheel, which does happen very often...
--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 7:31 am

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

ffarouqi - Tuesday, February 20, 2018 1:53 PM
I would like to know if we can create a separate group or what permissions...
--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 6:55 am

#1980608
RE: Auditing

This is not a trivial task. Start here.
https://www.red-gate.com/simple-talk/sql/database-administration/auditing-ddl-changes-in-sql-server-databases/
If that is insufficient for some reason, then buy a product such as Apex.
--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 6:40 am

#1980606
RE: Triggers or best option

Now, I told you that story to tell you this one. Consider the links that Evgeny Garaev provided above. The cool part about the Temporal Tables is that they auto-magically...
--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 20, 2018 at 9:10 pm

#1980579

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