Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,936 through 40,950 (of 59,069 total)

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
RE: Newbie Frustration - SQL Server 2000

They finally have the code windows so close to being right that I don't want them to touch them for fear of them mucking them up like they have 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 9:29 pm

#1084433
RE: A welcome message to all Forum Newbies

Steve Jones - Editor (11/25/2009)
You can't force people to read or pay attention.
Heh... you can if there're some tight ropes and high velocity pork involved. 😉
--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:26 pm

#1084432
RE: tempdb - understanding unallocated space

Irish Flyer (11/25/2009)
I have never seen any tempdb growth that could be called abnormal, it just is what it is
Heh... man, I have. Developer ran some code that had...
--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:20 pm

#1084431

Viewing 15 posts - 40,936 through 40,950 (of 59,069 total)