Jeff Moden

Forum Replies Created

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

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
RE: Index on a computed column

Sean Lange - Thursday, September 6, 2018 1:41 PM
Jeff Moden - Thursday, September 6, 2018 1:07 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 6, 2018 at 5:17 pm

#2004779
RE: Index on a computed column

Sean Lange - Thursday, September 6, 2018 10:35 AM
Jeff Moden - Thursday, September 6, 2018 9:22 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 6, 2018 at 1:07 pm

#2004762
RE: SQL jobs interfering with eachother

TJDBA - Thursday, September 6, 2018 3:59 AM
mark.humphreys - Thursday, September 6, 2018 3:38 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 6, 2018 at 9:29 am

#2004733

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