Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,486 through 10,500 (of 59,099 total)

RE: Need index suggestion

Jonathan AC Roberts - Thursday, November 29, 2018 7:51 AM
samantha.sqldba - Thursday, November 29, 2018 7:08 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)

November 30, 2018 at 8:02 am

#2015124
RE: Need index suggestion

John Mitchell-245523 - Thursday, November 29, 2018 7:16 AM
Sam
Looks like you need to do a bit of normalising first - you shouldn't...
--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)

November 30, 2018 at 8:00 am

#2015122
RE: Small negative numbers

Solomon Rutzky - Wednesday, November 28, 2018 2:14 PM
It's mostly a matter of scale. When dealing with up to a few...
--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)

November 29, 2018 at 9:50 pm

#2015045
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

Y.B. - Thursday, November 29, 2018 11:44 AM
Just seeing this post pop up again reminded me I needed to thank you Jeff...
--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)

November 29, 2018 at 9:27 pm

#2015043
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

s.duvernay 71743 - Thursday, November 29, 2018 11:36 AM
Hi Jeff,
Thank you very much for this brilliant article which brings me some light...
--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)

November 29, 2018 at 8:31 pm

#2015040
RE: Entity-Attribute-Value is evil ? how to avoid...

Jason A. Long - Wednesday, November 28, 2018 11:40 PM
Jeff Moden - Wednesday, November 28, 2018 8:59...
--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)

November 29, 2018 at 5:48 pm

#2015029
RE: Entity-Attribute-Value is evil ? how to avoid...

Lynn Pettis - Wednesday, November 28, 2018 6:41 PM
They are a tool. They may be of limited value depending on what...
--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)

November 28, 2018 at 8:59 pm

#2014896
RE: Entity-Attribute-Value is evil ? how to avoid...

Those don't appear to be EAV tables.
Your overuse of NVARCHAR(MAX) is going to end up being a problem, though... especially since I don't see anything that...
--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)

November 28, 2018 at 5:20 pm

#2014893
RE: Inserting a new row into a table using a cursor

jcelko212 32090 - Tuesday, November 27, 2018 7:44 AM
But for a posting, I want people to learn that an identifier is on...
--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)

November 28, 2018 at 11:24 am

#2014860
RE: Inserting a new row into a table using a cursor

Lynn Pettis - Wednesday, November 28, 2018 8:32 AM
jcelko212 32090 - Wednesday, November 28, 2018 8:26 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)

November 28, 2018 at 11:22 am

#2014858
RE: High memory utilization on SQL Server

sqlguy80 - Wednesday, November 28, 2018 10:30 AM
Just so every one knows , the sql server error log was the culprit which...
--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)

November 28, 2018 at 11:20 am

#2014857
RE: one sec vs 40 minutes

goher2000 - Wednesday, November 28, 2018 7:34 AM
Thank you all for your input, the stored procedure is working as expected with trace...
--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)

November 28, 2018 at 9:20 am

#2014824
RE: Rebuilding Indexes

Johnson Welch - Wednesday, November 28, 2018 2:39 AM
You should rebuild indexes often enough so that production is not detrimentally affected 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)

November 28, 2018 at 9:16 am

#2014822
RE: one sec vs 40 minutes

goher2000 - Tuesday, November 27, 2018 10:03 AM
I copied database from prod (sql 2008) to test (sql 2014) , changed compatibility mode...
--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)

November 28, 2018 at 6:39 am

#2014786
RE: Stats update

sizal0234 - Tuesday, November 20, 2018 11:13 AM
can I ENABLE auto create or update stats for each user db's anytime on prod?...
--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)

November 28, 2018 at 6:34 am

#2014785

Viewing 15 posts - 10,486 through 10,500 (of 59,099 total)