Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,856 through 33,870 (of 59,099 total)

RE: Looking for reasons...

Gianluca Sartori (5/25/2011)
~~Maybe~~ Probably I'm short-sighted and I don't understand exactly what you mean.
Can you give us a small example?
Yes, I believe I can. And I believe 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)

May 25, 2011 at 6:41 am

#1329623
RE: From Great Idea to End Result

aphillippe (5/25/2011)
But the advantage is it takes you less time to realise things aren't going right and you have the flexibilty to make changes to get things back on course....
--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)

May 25, 2011 at 6:34 am

#1329621
RE: What should be a simple query needed

Jeff Moden (5/24/2011)
This can be done quite simply using REPLACE, a single concatenation, and a WHERE clause with a LIKE. Give it a try. 😉
How embarrassing. I "missed"...
--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)

May 25, 2011 at 5:59 am

#1329611
RE: Importing very large flat file throws truncation errors

Lowell (5/25/2011)
Jeff Moden (5/24/2011)
Gosh, folks. I've not tried to import the data (yet) but the "Read Me" pointed out in the original posts seems to identify column requirements quite...
--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)

May 25, 2011 at 5:55 am

#1329608
RE: Looking for reasons...

I do it more often than not. Peter Larsson calls the process "pre-aggregation". You've seen me refer to it as "Divide'n'Conquer" methods. I do it for 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)

May 25, 2011 at 12:24 am

#1329491
RE: From Great Idea to End Result

Gosh... I've seen this type of conversation come up over and over and people still haven't sussed it.
[font="Arial Black"]From the article[/font]
...but it's more important to get something done and 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)

May 25, 2011 at 12:08 am

#1329488
RE: What should be a simple query needed

vradul (5/24/2011)
I have a table named “table” containing a few hundred rows with a field named "teaser" that contains various text strings, among which are 50 rows with “teaser” containing...
--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)

May 24, 2011 at 11:09 pm

#1329484
RE: Importing very large flat file throws truncation errors

Gosh, folks. I've not tried to import the data (yet) but the "Read Me" pointed out in the original posts seems to identify column requirements quite nicely. I've...
--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)

May 24, 2011 at 11:02 pm

#1329483
RE: Identity Table vs Identity Column

You CAN use a sequence table but not quite the way you have it. You don't need to do an insert/delete... you can do an UPDATE using the well...
--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)

May 24, 2011 at 10:52 pm

#1329479
RE: Two questions in mind (for genralized approach)

sqlnaive (5/24/2011)
Unfortunately that brings me to the same point where I started. In a complex stored procedure, what should be the thumb rule for implementing temporary data [records upto 800].
That's...
--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)

May 24, 2011 at 10:21 am

#1329217
RE: Hints Are Not Always Better

Nadrek (5/23/2011)
Jeff Moden (5/22/2011)
I wish more people would understand what "tuning" is all about. It's not about getting SQL Server to do what you want... Rather, it's about LETTING 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)

May 23, 2011 at 9:12 am

#1328504
RE: TRigger problem, again Multible rows with update

mister.magoo (5/23/2011)
Jeff Moden (5/23/2011)
Almost forgot... I've had people report the problem on all versions except 2008, so far. I don't believe they "fixed" it because it's actually not 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)

May 23, 2011 at 2:59 am

#1328350
RE: TRigger problem, again Multible rows with update

nigel. (5/23/2011)
Jeff,
Love the phrase:
... slam all the CPU's into the wall for hours ...
🙂
Just trying to visualize it now...
Bits of silicon smeared all over the server room walls... nice!
Heh... actually,...
--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)

May 23, 2011 at 2:56 am

#1328348
RE: TRigger problem, again Multible rows with update

Almost forgot... I've had people report the problem on all versions except 2008, so far. I don't believe they "fixed" it because it's actually not a bug. 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)

May 23, 2011 at 2:50 am

#1328344
RE: TRigger problem, again Multible rows with update

mister.magoo (5/22/2011)
Jeff Moden (5/22/2011)
Wayne is absolutely spot on about the possible performance problem associated with joined UPDATEs. The "target" of the UPDATE MUST be somewhere in the FROM clause...
--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)

May 23, 2011 at 2:44 am

#1328341

Viewing 15 posts - 33,856 through 33,870 (of 59,099 total)