Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,296 through 17,310 (of 59,067 total)

RE: CAST as numeric rounding issue

For these reasons, I don't use implicit rounding caused by datatype scale reduction. I always use the ROUND() function to do the rounding and then stuff it into the...
--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)

July 6, 2016 at 7:11 pm

#1888828
RE: Maintaining Sequence of OUTPUT rows during INSERT

This is the ol' batch Invoice/Invoice detail problem. I've tried many different renditions, including the very one that you've just tried and I'm here to tell you that it...
--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)

July 6, 2016 at 6:58 pm

#1888827
RE: Justify DBA access to production

The GOOD part about them taking away all privs from prod is that you could actually justify turning off the phone at night. 😉
--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)

July 6, 2016 at 6:13 pm

#1888826
RE: Unstructured data sources into a structured DW

Steve Jones - SSC Editor (7/6/2016)
Jeff Moden (7/6/2016)
Steve Jones - SSC Editor (7/6/2016)
If it's low volume, do what's easiest. It won't matter enough.
Heh... unless the low volume data also happens...
--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)

July 6, 2016 at 5:28 pm

#1888823
RE: Unstructured data sources into a structured DW

Steve Jones - SSC Editor (7/6/2016)
If it's low volume, do what's easiest. It won't matter enough.
Heh... unless the low volume data also happens to be the most critical.
--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)

July 6, 2016 at 10:21 am

#1888738
RE: Justify DBA access to production

tezsb (7/6/2016)
This is where it got a bit tricky. I am not a development DBA by any stretch of the imagination. my role is to do the backups, refreshes, performance...
--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)

July 6, 2016 at 10:17 am

#1888737
RE: Justify DBA access to production

tezsb (7/6/2016)
Yes, the CIO finally agreed with me that I could not do my job without sysadmin... although for some strange reason the 3rd Party company might still insist on...
--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)

July 6, 2016 at 10:12 am

#1888735
RE: Date Range overlaps

Nomvula (7/5/2016)
How do I go about doing that?
I'm thinking that you didn't actually read the link that JLS provided so that you could actually support the code yourself.
--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)

July 6, 2016 at 10:07 am

#1888732
RE: Justify DBA access to production

tezsb (7/6/2016)
thanks to all for your replies, I appreciate the additional insight and view from an alternative perspective. Rightly or wrongly, I assumed the CIO knows what a DBA does...
--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)

July 6, 2016 at 8:20 am

#1888703
RE: Populate Data -- Loop

Cawie (7/5/2016)
Luis Cazares (6/30/2016)
This is equivalent to your code. Both are not guaranteed to get the same results each time as there's nothing to order. Pietlinden gave you the other...
--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)

July 5, 2016 at 6:02 pm

#1888598
RE: not able to find why/where this error is comming.

rajemessage 14195 (7/5/2016)
i known begin tran and try cache , what i am asking is, which stmt might be the reason of generating this error.
your sincerley
BEGIN TRAN and TRY/CATCH are...
--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)

July 5, 2016 at 2:02 pm

#1888562
RE: CTE Script Needed for delete statement

Sree Divya (6/29/2016)
Hi,
we are using below script for delete records.but it is taking time
USE AdventureWorks2008R2;
GO
DELETE * FROM Purchasing.PurchaseOrderDetail
WHERE DueDate = '20020701';
GO
is there any possibility of chance to delete the rows...
--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)

July 5, 2016 at 1:15 pm

#1888548
RE: Reclaiming space after data type change

david.fundakowski (7/5/2016)
I would like to do a write up on table size increase after changing column data types and how to reclaim the empty space.
Topics included would be:
Changing...
--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)

July 5, 2016 at 11:50 am

#1888527
RE: Decreasing a value across multiple rows until 0

greg.senne (7/5/2016)
Hey, I'm still here! It was a holiday weekend! Guess I should've checked in over the weekend...
So, this procedure is being used for payment deductions. The base table holds...
--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)

July 5, 2016 at 8:10 am

#1888460
RE: Unstructured data sources into a structured DW

You bet and thanks for the feedback. Sorry I don't know of a better answer. These types of problems are really tough. Heh... how can you find...
--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)

July 5, 2016 at 8:01 am

#1888458

Viewing 15 posts - 17,296 through 17,310 (of 59,067 total)