Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,326 through 17,340 (of 59,102 total)

RE: Improvements in SQL Server Environment

Welcome aboard but...
SQL Programmers (7/6/2016)
•CHECK THE SQL SERVER VERSION
Check for the latest SQL server version, which has the latest version of the SQL query optimizer. This will have enhanced development...
--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 7, 2016 at 12:55 am

#1888848
RE: Justify DBA access to production

jasona.work (7/6/2016)
On the topic of backups, I'd suggest pressing them for information on *HOW* they're going to be doing the backups. We (briefly) were looking at moving our servers (SQL...
--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 9:16 pm

#1888836
RE: How to Put a MAX(Date) from a Table into an SSIS Variable

dirkdirden (7/5/2016)
Holy Crap baskets that is a lot of steps for such a seemingly easy task.
Goes right along with the Holy Snappin' Ducksh!t that you have to fill...
--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:08 pm

#1888833
RE: Finding a substring and extracting a number associated with it

My customized solution would be to hunt down the idiot(s) that are creating the mess in the files and take them to a nice, sit down, pork chop dinner. 😉
--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:01 pm

#1888831
RE: problem converting date on procedure.

Lynn Pettis (7/6/2016)
Sergiy (7/6/2016)
Lynn Pettis (7/6/2016)
How about a page from Mr. Celko's book (none of which I have or will read), because CAST is the ANSI standard and CONVERT isn't.
You...
--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:48 pm

#1888830
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

Viewing 15 posts - 17,326 through 17,340 (of 59,102 total)