Jeff Moden

Forum Replies Created

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

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
RE: Chinese Characters on report

rinu philip - Tuesday, November 27, 2018 11:33 AM
SQL_Surfer - Sunday, November 4, 2018 1:14 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)

November 28, 2018 at 6:12 am

#2014783
RE: Chinese Characters on report

SQL_Surfer - Sunday, November 4, 2018 1:14 PM
Some of the records that Business Objects pulls are garbage and chinese characters like below.
When...
--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:11 am

#2014782
RE: poor performing report query against table without a PK

polkadot - Monday, November 26, 2018 12:39 PM
Answers to Qs:
Grant Fritchey: (1) I added parenthesis around Date. (2) using parameters. Attached query.
ChrisM: (1) table...
--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:05 am

#2014780
RE: View that sums payments by person over a period of years

ScottPletcher - Tuesday, November 27, 2018 2:46 PM
Since you've very likely to (almost) always query by trans date, you should change 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)

November 28, 2018 at 5:56 am

#2014779

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