Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,266 through 11,280 (of 59,102 total)

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
RE: Allowing developers ability to administer SQL Agent jobs in production

ZZartin - Friday, September 7, 2018 8:07 AM
Jeff Moden - Friday, September 7, 2018 7:46 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 7, 2018 at 10:44 am

#2004919
RE: Export and Import 214 tables

jbecker 27503 - Friday, September 7, 2018 9:55 AM
Hi guys I inherited a process in which extracts changes from 214 tables in...
--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 7, 2018 at 10:38 am

#2004917
RE: Are the posted questions getting worse?

Grant Fritchey - Friday, September 7, 2018 8:50 AM
There are two tiers to the certs. Those who have them because they...
--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 7, 2018 at 10:18 am

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

ZZartin - Friday, September 7, 2018 7:39 AM
It really depends on your organization and just how often these kind of situations arise,...
--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 7, 2018 at 7:46 am

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

doodlingdba - Friday, September 7, 2018 3:39 AM
Hi all
Trying to get an idea of what people are doing out in the industry...
--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 7, 2018 at 7:34 am

#2004859
RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, September 7, 2018 5:07 AM
xsevensinzx - Friday, September 7, 2018 4:59 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 7, 2018 at 6:35 am

#2004840
RE: script to set all user database to simple recovery model

It would appear that the purpose of all this scripts is to shrink the log file for any database not in the SIMPLE recovery model. I see several shortcomings in...
--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 7, 2018 at 6:22 am

#2004837
RE: Are the posted questions getting worse?

TomThomson - Thursday, September 6, 2018 3:32 PM
What set me off, Sean, was blaming the academics and not pointing out...
--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 6, 2018 at 5:32 pm

#2004782

Viewing 15 posts - 11,266 through 11,280 (of 59,102 total)