Jeff Moden

Forum Replies Created

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

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
RE: Delete statement hangs

wzline - Saturday, September 8, 2018 3:00 PM
restored the database and now can see the code for deleting:
DELETE dbo.<table_name1> WITH (READPAST)
FROM dbo.<table_name1>...
--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:15 pm

#2004968
RE: Delete statement hangs

How many total rows are you deleting?
--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 1:09 pm

#2004963
RE: Are the posted questions getting worse?

Sean Lange - Friday, September 7, 2018 2:39 PM
Oh goodness...I was just finishing up an application and ran into even more fun....
--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 1:04 pm

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

ZZartin - Friday, September 7, 2018 12:21 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 8, 2018 at 12:40 pm

#2004961

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