Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,251 through 11,265 (of 59,099 total)

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
RE: How do I write a record for each day in a date range???

Jonathan AC Roberts - Sunday, September 9, 2018 12:32 PM
Thanks Jeff, I thought it would be quite a useful function 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 6:08 am

#2005027
RE: Delete statement hangs

wzline - Sunday, September 9, 2018 10:28 PM
Jeff Moden - Sunday, September 9, 2018 10:54 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 6:06 am

#2005026
RE: Delete statement hangs

wzline - Saturday, September 8, 2018 3:41 PM
Jeff Moden - Saturday, September 8, 2018 3:15 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 9, 2018 at 10:54 am

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

Grant Fritchey - Saturday, September 8, 2018 11:30 PM
ebooklub - Friday, September 7, 2018 12:54 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 9, 2018 at 10:19 am

#2004990
RE: Allowing developers ability to administer SQL Agent jobs in production

TomThomson - Saturday, September 8, 2018 7:07 PM
Jeff Moden - Friday, September 7, 2018 10: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)

September 9, 2018 at 10:03 am

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

Jonathan AC Roberts - Saturday, September 8, 2018 7:04 PM
Jeff Moden - Saturday, September 8, 2018 3:49...
--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 9, 2018 at 9:10 am

#2004988
RE: Report runs faster after Backup and Restore

Grant Fritchey - Friday, September 7, 2018 2:46 AM
Nothing in the backup and restore would make the query run faster. However, 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)

September 8, 2018 at 4:30 pm

#2004977
RE: need help on Derived table

saptek9 - Friday, September 7, 2018 11:05 AM
I have table named family with familyid,totalcount,adultcount,childcount
now i need to create derive table with following...
--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 8, 2018 at 4:22 pm

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

DATEDIFF_BIG is the bad joke that MS came up with because they royally screwed up when they created the relatively new DATETIME2, DATE, and TIME datatypes, which can no longer...
--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 8, 2018 at 3:49 pm

#2004974
RE: Fast Database Clone

info 58414 - Saturday, September 8, 2018 7:17 AM
Hi,
What is the fastest way to clone a database of 50 GB every day...
--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 8, 2018 at 3:35 pm

#2004970
RE: Delete statement hangs

Shifting gears a bit, I've done rather large deletes on rather large tables before. Since such deletes (you're deleted about 15% of the table) normally require a rebuild of the Clustered...
--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 8, 2018 at 3:21 pm

#2004969

Viewing 15 posts - 11,251 through 11,265 (of 59,099 total)