Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,911 through 47,925 (of 59,099 total)

RE: The South African SQL Server Usergroup is Back

Have the time? Heh, what did you do? Make a clone? 🙂
--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 7, 2008 at 4:41 am

#881534
RE: The South African SQL Server Usergroup is Back

I saw the title of this one and immediately thought "Hmmm... I'll just bet Gail is at the heart of this announcement."
--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, 2008 at 9:38 pm

#881419
RE: Organizations With No DBAs

Dang! I'm not sure how it happened, but I missed the whole gambit of 9/22 posts! Very well stated, folks. Well done.
And, you, Mr. Burrows, have never...
--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, 2008 at 9:32 pm

#881418
RE: Date range to also compute previous date per no. of days

clint_pow (10/6/2008)
Hi,
Its really amazing how it goes, I really appreciated it at last I can incorporated it with some of my query. How I wish I have a knowledge 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, 2008 at 9:26 pm

#881416
RE: Slow SQL Calls

Might not be a mistake on your part... seems to me that, way back when, what you say used to be the truth and they fixed 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)

October 6, 2008 at 9:22 pm

#881415
RE: Cross Tab query

You may also want to try using multiple Selects separated by UNION ALL.
--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, 2008 at 9:15 pm

#881414
RE: The Weekly News for Oct 6, 2008 (Database Weekly)

Oh... I almost forgot... I ran Phil's tests without modifying his code. I was so engaged in why he was getting his "reverse" findings, that I actually forgot 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)

October 6, 2008 at 9:12 pm

#881413
RE: The Weekly News for Oct 6, 2008 (Database Weekly)

Thought I'd give a little feedback here... Phil reran his tests on his machine several times... same result... the While loop on a super string beat the tar out 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, 2008 at 9:10 pm

#881412
RE: Difference between SQLServer 2005 and SQLServer 7.0 Queries

chileu17 (10/6/2008)
eventhough the table has a primary key? and a non-clustered index?
non-clustered indexes are supposed to be inserted in a specific order right? :ermm: please correct me if I 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, 2008 at 8:57 pm

#881407
RE: combining multiple rows into one

zypsy (10/6/2008)
Based on some criteria, I have reduced the number of orders in the dataset
from about 42000 to about 6000.
Then, methinks that something is drastically wrong... you just said (and...
--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, 2008 at 8:52 pm

#881405
RE: Date range to also compute previous date per no. of days

T-SQL isn't just "Declares"... it also includes all those really handy date functions. 🙂 And, yes... everything is possible...
SELECT CONVERT(CHAR(8),d1.StartDate,1) + ' thru ' + CONVERT(CHAR(8),d1.EndDate,1) ...
--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, 2008 at 8:37 pm

#881402
RE: Avoiding Curosr - Yet Another Situation

J (10/6/2008)
Thanks for the help.
Still, the thought process of whoever came up with this one remain baffling. Same as for the guy who figured out that nitroglycerin, an unstable explosive,...
--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, 2008 at 6:53 pm

#881397
RE: Updating table based on coalesce reults in where clause?

bobhovious (10/6/2008)
Somewhat embarassing to get caught in typos that increase volumes :w00t:, or quick reads that miss the point being made. But I'll survive.
You never answered 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)

October 6, 2008 at 6:46 pm

#881395
RE: Updating table based on coalesce reults in where clause?

bobhovious (10/6/2008)
Dangit... every time I see a Moden-comment I get befuzzled.
Is that good or bad? 🙂
--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, 2008 at 4:03 pm

#881373
RE: Avoiding Curosr - Yet Another Situation

Very well done, Matt. 🙂
J... your "agressive curiosity" is what I call "intellectual curiosity". I believe you won't find yourself alone in that area.
I've not been able to keep...
--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, 2008 at 3:51 pm

#881368

Viewing 15 posts - 47,911 through 47,925 (of 59,099 total)