Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,236 through 11,250 (of 59,099 total)

RE: Coming down on bad users - WWYD ?

JaybeeSQL - Monday, September 10, 2018 1:12 PM
I'm highlighting incompetence that's harming my organisation, and MY actions are being questioned??!?!? 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)

September 10, 2018 at 5:51 pm

#2005170
RE: Best Practice Help - Table Structures

amy26 - Monday, September 10, 2018 3:56 PM
So, thank you everyone for all the insightful help. I am appalled that I...
--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)

September 10, 2018 at 4:38 pm

#2005163
RE: Best Practice Help - Table Structures

Sean Lange - Monday, September 10, 2018 3:35 PM
Joe Torre - Monday, September 10, 2018 3:13 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)

September 10, 2018 at 4:14 pm

#2005162
RE: Best Practice Help - Table Structures

Couple o' more thoughts. If your demonstrable code for the normalized methodology beats the XML, and I have no doubt that it will, and they play the "Well, can you...
--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)

September 10, 2018 at 10:34 am

#2005111
RE: Best Practice Help - Table Structures

p.p.s Also remember that dates with times stored in XML will take quite a bit more space than an 8 byte datetime and that just a date will take more...
--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)

September 10, 2018 at 10:04 am

#2005107
RE: Best Practice Help - Table Structures

p.s. When you do the comparison, don't forget to measure disk space, which will also translate to memory usage. Once you have an example of their XML data and you've...
--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)

September 10, 2018 at 9:43 am

#2005104
RE: Best Practice Help - Table Structures

amy26 - Friday, September 7, 2018 4:17 PM
Hi there, I am being asked to provide a list of all the reasons 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)

September 10, 2018 at 9:28 am

#2005103
RE: How do I write a record for each day in a date range???

Jonathan AC Roberts - Monday, September 10, 2018 8:15 AM
Thom A - Monday, September 10, 2018 8:13...
--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)

September 10, 2018 at 8:56 am

#2005096
RE: Coming down on bad users - WWYD ?

Steve Jones - SSC Editor - Monday, September 10, 2018 7:22 AM
I agree with Grant. Education is important, but when users are...
--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)

September 10, 2018 at 8:19 am

#2005087
RE: Delete Old Tables

unas_sasing - Thursday, September 6, 2018 9:01 PM
Kindly help me, I want to make a syntax that compares if the number 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)

September 10, 2018 at 8:04 am

#2005077
RE: CPU time > Elapsed time

msimone - Monday, September 10, 2018 7:33 AM
I will follow yours recommendations, wait stats in extended event and to rewrite de code.
--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)

September 10, 2018 at 7:51 am

#2005069
RE: Slower performance in Prod, Plan has Index Spool Eager Spool

steve.gambale - Thursday, September 6, 2018 2:29 PM
Same sql in prod runs in 23 min and in QA/test it is 11 min.
Since...
--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)

September 10, 2018 at 7:45 am

#2005065
RE: Ideas for setting Azure SQLmanaged instance for transaction and reporting

Grant Fritchey - Monday, September 10, 2018 7:21 AM
No. You pay X amount for X amount of DTU/vCore. How you use...
--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)

September 10, 2018 at 7:28 am

#2005055
RE: How do I write a record for each day in a date range???

Steve Jones - SSC Editor - Monday, September 10, 2018 7:18 AM
Jonathan AC Roberts - Sunday, September...
--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)

September 10, 2018 at 7:26 am

#2005053
RE: CPU time > Elapsed time

Grant Fritchey - Monday, September 10, 2018 7:16 AM
msimone - Monday, September 10, 2018 6:13 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)

September 10, 2018 at 7:23 am

#2005051

Viewing 15 posts - 11,236 through 11,250 (of 59,099 total)