Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,966 through 40,980 (of 59,102 total)

RE: UPDATE question

I agree with Jack. Having RBAR triggers will eventually cause you a huge problem.
As a casual observation, all the XML and CLR stuff you're talking about will...
--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)

November 26, 2009 at 11:17 am

#1084672
RE: Help with BCP format error

THAT, good Sir, is some of the best feedback I've ever gotten... glad to help especially since it means more time with family for you. And, welcome aboard!
--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)

November 25, 2009 at 11:11 pm

#1084455
RE: Index on Table with 2 Columns Millions of Rows

Rowan-283474 (11/25/2009)
steveb. (11/25/2009)
Do you have a clustered index on this table/heap ?
As stated above the problem with speed would most likely be due to the fact that 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)

November 25, 2009 at 10:55 pm

#1084450
RE: Lengthy procedure vs Split procedure

Unfortunately, that's not been my particular experience. I usually experience the ol' "too many cooks spoil the broth" syndrome.
--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)

November 25, 2009 at 10:51 pm

#1084449
RE: Autogrowth

I never use percentage for many of the reasons stated.
I also never leave the defaults. It's takes and makes 73 disk fragments to grow a database from 1MB to...
--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)

November 25, 2009 at 10:48 pm

#1084448
RE: Networking One Tweet at a Time

Steve Jones - Editor (11/25/2009)
Apparently not doing much networking with this one.
About the only social networking I do is on LinkedIn and then only when required. I use 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)

November 25, 2009 at 10:42 pm

#1084447
RE: Locating Groups of Data with Missing Value

Yes... write an exclusive self join or a union between two queries on the same table using EXCEPT.
Since you're new to the forum, take a look at the article 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)

November 25, 2009 at 10:33 pm

#1084445
RE: need better way than row_number()

shanghaigirl-1125377 (11/25/2009)
I need to order 2 columns on a 10m+ row table with no indexes, and the query I have runs about 8 mins, how can I speed...
--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)

November 25, 2009 at 10:28 pm

#1084444
RE: Concentrating in a noisy office environment

Mostly, conditioning for me. It just takes time to learn to ignore and be as one with the computer. It's a real PITA that's not easily overcome...
--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)

November 25, 2009 at 10:24 pm

#1084443
RE: Anything other than Trigger ?

Even the best written triggers can cause an application to crash because of just one thing... the returned rows counts generated in the triggers are interpreted as "error messages". ...
--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)

November 25, 2009 at 10:21 pm

#1084442
RE: Data Flow Task vs Stored Procedures

I'm not sure if my luck will run out or not but, so far, every time I've rewritten a DTS package to be done all in T-SQL, I've beaten 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)

November 25, 2009 at 10:19 pm

#1084441
RE: Totals for each month in a date range query

stewsterl (11/25/2009)
Jan Feb Mar April May Jun JUL YEAR
$23,000 $36,236.00 $36,236.00 $36,236.00 $36,236.00 $36,236.00 $2,008.00 2008
$23,000 $36,236.00 $36,236.00 $36,236.00 $36,236.00 $36,236.00 $2,008.00 2009
Great post and thanks for all the data...
--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)

November 25, 2009 at 10:12 pm

#1084439
RE: Return most recent of a sub group of records

Sergiy (11/25/2009)
Jeff, a small correction.
It should be:
...
join sysdba.history h on h.accountid = maxdate.accountid AND h.startdate = maxdate.MaxStartDate
...
🙂
Heh... now you know why I like to test my stuff......
--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)

November 25, 2009 at 9:54 pm

#1084436
RE: UPDATE question

Jack Corbett (11/25/2009)
Jeff Moden (11/25/2009)
I have to tell you that writing a trigger like that is a form of "Death-by-SQL" because it will only correctly process the first row 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)

November 25, 2009 at 9:47 pm

#1084435
RE: Reclaiming unused space in a table

Agreed.... if everything were absolutely perfect. The problem is that clustered indexes can do page splits and non-clustered indexes do "extent splits". Guess what happens when you do...
--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)

November 25, 2009 at 9:33 pm

#1084434

Viewing 15 posts - 40,966 through 40,980 (of 59,102 total)