Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,161 through 14,175 (of 59,095 total)

RE: The Achilles Heel

Heh... I won't mention the name of the company that I think you're talking about but its initials are "Equifax" 😛
I can't believe that the CEO of...
--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 6, 2017 at 9:48 pm

#1962717
RE: Data Modelers - Alternatives to Erwin

Grant Fritchey - Wednesday, June 18, 2014 6:52 AM
Clay Bowen (6/17/2014)
You fail to mention the price of Embarkadero is actually higher than...
--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 6, 2017 at 9:37 pm

#1962716
RE: Data Modelers - Alternatives to Erwin

halil.lacevic - Friday, October 6, 2017 5:30 PM
So far, I have tried many online tools. However, I will list you some of...
--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 6, 2017 at 9:32 pm

#1962715
RE: Data Modelers - Alternatives to Erwin

Brandie Tarvin - Tuesday, January 29, 2008 11:45 AM
I just downloaded a trial version of this and it won't open any of...
--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 6, 2017 at 9:31 pm

#1962714
RE: Why SQL Server is Better Than Oracle

First of all, you say that the partitioning was so that you could achieve parallelism in your ETL loads to the staging table. You also state that the partitioned was...
--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 6, 2017 at 9:06 pm

#1962713
RE: Using Date in Where Condition

aloshya - Friday, October 6, 2017 8:03 AM
John Mitchell-245523 - Friday, October 6, 2017 7: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)

October 6, 2017 at 5:42 pm

#1962712
RE: Rewrite Your Code Tomorrow

I came across this article after about 50 views, according the stats on the website. At that time, this article only had about 3 stars. Considering all the great comments...
--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 6, 2017 at 5:11 pm

#1962708
RE: Teaching Quickly

When writing articles or even presentations, I've found that demonstrating a "bad" way saves on a huge number of questions (and, contrary to popular belief, there is such a thing as...
--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 6, 2017 at 4:59 pm

#1962707
RE: Comparing 2 functions for any differences in the result set.

TheCTEGuy - Friday, October 6, 2017 6:50 AM
Phil Parkin - Friday, October 6, 2017 6:43 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)

October 6, 2017 at 3:03 pm

#1962703
RE: Are the posted questions getting worse?

p.s. Kick the slats off that DBA. (S)he should bloody well know better not to develop in production and that code should be thoroughly tested prior to deployment to production.
--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 5, 2017 at 2:30 pm

#1962561
RE: Are the posted questions getting worse?

Phil Parkin - Thursday, October 5, 2017 8:00 AM
ZZartin - Thursday, October 5, 2017 7:51 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)

October 5, 2017 at 2:28 pm

#1962559
RE: Comparing 2 functions for any differences in the result set.

BTW... please post the 2 functions. I'm always interested in reporting functions and have some old "Black Arts" tricks that might provide additional performance benefits.
--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 5, 2017 at 2:23 pm

#1962558
RE: XP_cmdshell DIR

Jeff Moden - Thursday, April 23, 2015 4:12 PM
SQL-DBA-01 (4/23/2015)
Can you please suggest all the files from one location to another using...
--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 5, 2017 at 2:17 pm

#1962556
RE: Comparing 2 functions for any differences in the result set.

My take on it is that "It Depends". If it was an optimization made by the DBAs, then the DBAs are responsible for proving identical functionality and results. As a...
--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 5, 2017 at 10:26 am

#1962515
RE: Since looping is bad, how should I accomplish what I am trying to do?

TheCTEGuy - Thursday, October 5, 2017 4:33 AM
Here is a better solution i guess

create function dbo.split(@str varchar(100),@delimeter varchar(1)) returns...
--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 5, 2017 at 8:41 am

#1962493

Viewing 15 posts - 14,161 through 14,175 (of 59,095 total)