Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,691 through 54,705 (of 59,072 total)

RE: preventing sql server from sorting results

30 Gig? Can you even buy a harddisk that small anymore? Go buy a 300 GB disk or two from ABC Warehouse or something... shoot, I think even...
--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, 2007 at 8:49 pm

#739838
RE: Process Has Flat File Locked

I'm no expert in this area, but I don't think that just setting the shell to nothing will do it... don't you also have to drop or close the shell...
--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, 2007 at 8:44 pm

#739837
RE: Smallest Datatype Applies...

I've heard a lot of folks gripe that using SMALLINT and SMALLDATETIME actually slowed things down because of the datatype byte mismatch with computer "word" size on PC's. So,...
--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, 2007 at 8:41 pm

#739836
RE: How come no one post any job?

What wrong with DICE, Monster, and all the other job sites? You get a better selection and in more places than I ever saw on this forum...
--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, 2007 at 8:12 pm

#739835
RE: How to model credit card transaction process?

If you have to tract all that other stuff about a card, why worry about how many rows you have... it's gonna have to be stored somewhere. Perhaps 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 6, 2007 at 8:10 pm

#739834
RE: Determine if field has multiple spaces

When in doubt, simple tests will keep you from barking up the wrong tree or missing a perfectly good fire hydrant 😛
--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, 2007 at 8:04 pm

#739833
RE: Optimizing SQL System Stored Procedures - What's in a SELECT?

3. SELECT indentity(int,1,1) as ID, * into #tab from T are very common.
Shoot, that's one of my favorites. If the boys in Redmond ever get rid of Select...
--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, 2007 at 8:01 pm

#739832
RE: Putting image files in sql server 2005

It's probably a good thing you don't know how because my recommendation is not to store images in SQL... store them in files and store the file names in 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)

October 6, 2007 at 7:55 pm

#739831
RE: Annoyance - Spell check

Heh... when are you going to get to all the things I sent you, Steve?
--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, 2007 at 7:53 pm

#739830
RE: Current Order Date and Average Count of Orders for Three Prior Days

... and, if there are any questions about possible performance, lets use the good ol' million row test table I keep around...
--===========================================================================================
-- Build a million rows of test data. THIS...
--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, 2007 at 7:47 pm

#739828
RE: Current Order Date and Average Count of Orders for Three Prior Days

Original thread seemed pretty darned clear... but I could be wrong...
This should do it...
--===== If the temp table exists, drop it
IF OBJECT_ID('TempDB..#SandBox') IS NOT NULL
...
--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, 2007 at 7:21 pm

#739827
RE: Optimizing data calculation inside SP

Actually WreckageTime is added to date part of AnnounceDateTime to generate a smalldatetime value to be used particularly in this query
But, that's what I'm talking about... I wasn't talking about...
--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, 2007 at 6:53 pm

#739826
RE: Better way to write?

Or, just...
SELECT @bLookForChangedCUSIPs = SIGN(COUNT(*))
FROM Performance.dbo.gChangedCUSIPs
WHERE CUSIPKey = @vchVAGK + @vchPAC
--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, 2007 at 3:07 pm

#739819
RE: Table valued functions

So, do table valued functions create temp tables in tempdb?
Yes, they do... Please refer to Q4/A4 at the following URL...
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
--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, 2007 at 2:59 pm

#739818
RE: Standardizing Primary keys

No... I wouldn't make an alpha-numeric primary key... they're slow and difficult to maintain.
Why don't you just use an INDENTITY column and a Country column?
--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, 2007 at 2:56 pm

#739817

Viewing 15 posts - 54,691 through 54,705 (of 59,072 total)