Jeff Moden

Forum Replies Created

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

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
RE: Ideas for setting Azure SQLmanaged instance for transaction and reporting

Grant Fritchey - Monday, September 10, 2018 7:11 AM
Yeah, absolutely. But you don't pay for each CPU call. You pay for...
--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:16 am

#2005045
RE: Fast Database Clone

Grant Fritchey - Monday, September 10, 2018 5:44 AM
Jeff is dead on accurate. That is the fastest and safest way I know...
--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:15 am

#2005044
RE: CPU time > Elapsed time

msimone - Monday, September 10, 2018 6:13 AM
Hello Grant.
I use a extended event sqlserver.rpc_completed and the DMV sys.dm_exec_procedure_stats because the application executes procs, never...
--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 6:42 am

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

Grant Fritchey - Monday, September 10, 2018 5:02 AM
You can literally calculate cost savings as you tune queries. WHOOP!!
However, I stand...
--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 6:27 am

#2005032

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