Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,516 through 25,530 (of 59,102 total)

RE: Improving SSIS Update Performance

RonKyle (10/31/2013)
Great article. Lots to think about. Any thought to testing deleting the rows to be updated so that everything is then an insert. I'm not necessarily...
--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)

October 31, 2013 at 9:11 am

#1663118
RE: Improving SSIS Update Performance

Oh... I almost forgot. Check the desination table for triggers. If it has one of those bloody "generic audit triggers" (GAT) on it, then that can cause huge...
--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)

October 31, 2013 at 9:08 am

#1663116
RE: Improving SSIS Update Performance

Gosh... still more than 2 minutes using the "fastest" option. How many rows were in the source?
Heh... and I have to admit this is the first time I've ever...
--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)

October 31, 2013 at 9:01 am

#1663111
RE: Are the posted questions getting worse?

GilaMonster (10/31/2013)
Last day of freedom. Starting dev job tomorrow. Hopefully will go well...
I'm unlikely to be around much during the week from now on (at least for a while), so...
--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)

October 31, 2013 at 8:29 am

#1663078
RE: how do i find 5th working day in a month.

If you only need compatibility back to 2005, then I guess you could call the following a "simplification".
DECLARE @pMonth INT
,@pYear...
--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)

October 30, 2013 at 9:05 pm

#1662906
RE: how do i find 5th working day in a month.

As much as I love Tally Tables and as high performing as they can be, I find that pure math will frequently beat it (although I've not tested it 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)

October 30, 2013 at 8:37 pm

#1662904
RE: table with more than 1.5 Lakh record simplet query taking too much time

Keith Tate (10/30/2013)
kapil_kk (10/30/2013)
janki0430 (10/30/2013)
AssembleTrn is table with about 170157 records
when i run this query it will take about more than 1.30 minute
plesae help me in getting...
--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)

October 30, 2013 at 7:05 pm

#1662896
RE: table with more than 1.5 Lakh record simplet query taking too much time

janki0430 (10/30/2013)
AssembleTrn is table with about 170157 records
when i run this query it will take about more than 1.30 minute
plesae help me in getting recoeds in faster...
--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)

October 30, 2013 at 7:03 pm

#1662895
RE: backup file with datetime stamp

Sqlsavy (10/28/2013)
How to create backup files with datatime stamps this is to retain 2 days backups on the disk
BACKUP DATABASE [DBNAME] TO
DISK = N'D:\BACKUPs\DBNAME\DBNAME_1.bak',
DISK = N'D:\BACKUPs\DBNAME\DBNAME_2.bak',
DISK = N'D:\BACKUPs\DBNAME\DBNAME_3.bak',
DISK...
--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)

October 30, 2013 at 6:59 pm

#1662894
RE: Concatenate Rows (PowerPivot)

Please see the following article for one pretty easy method.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--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)

October 30, 2013 at 6:30 pm

#1662891
RE: Query spills to tempdb with correct cardinality estimates

martin catherall (10/30/2013)
fair point Jeff, I used the term "spill to disk" to mean "spill to tempdb" - that was an error on my part.
Let me re-phrase again 🙂
Why can't...
--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)

October 30, 2013 at 6:18 pm

#1662890
RE: longtext

LOVER OF SQL (10/30/2013)
Jeff, my problem is maximum size 8... I was tried using SSIS, but it's the same problem... I have a 180 columns and 1 million rows [font="Arial...
--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)

October 30, 2013 at 6:09 pm

#1662889
RE: Display More Than 8000 Characters (SQL Spackle)

Sorry... post deleted... I had already addressed the issue I was posting about.
--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)

October 30, 2013 at 6:02 pm

#1662888
RE: Risky Backups

From the article:
I know that some people like having the same filename every day as it makes restores simpler, especially if they've scripted things.
I realize this is a 4 year...
--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)

October 30, 2013 at 5:03 pm

#1662883
RE: Risky Backups

Miles Neale (10/30/2013)
In the old days the Ancients use to say Kiss = Keep it Simple Stupid.
BWAAA-HAAAAA!!!! Since you're a fellow "Ancient", I strongly suspect you preserve the original...
--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)

October 30, 2013 at 4:50 pm

#1662882

Viewing 15 posts - 25,516 through 25,530 (of 59,102 total)