Viewing 15 posts - 58,741 through 58,755 (of 58,872 total)
I guess "Books on Line" is out of the question for you...
If you want a "live" example, perhaps you'd be kind enough to provide some live data and a description...
August 22, 2004 at 9:37 pm
Ilan,
Not trying to be difficult here but I guess I don't understand the problem... please describe what you are trying to do instead of trying to write code for it... ...
August 22, 2004 at 9:32 pm
The following example is straight out of "Books On Line"... modify it to handle your 5 nullable input parameters...
The parameter...
August 22, 2004 at 4:50 pm
Sometimes, you have to add to subtract...
WHERE DateOrder >= DATEADD(mm,-6,GETDATE())
Notice that we added a NEGATIVE six months to the current date. Will also handle jumps across years, centuries, leap years,...
August 22, 2004 at 4:39 pm
My suggestions in "bold" typeface...
Step One:
DECLARE A VARIABLE AS AN "INT"
SELECT THE MAX ID FROM THE SOURCE TABLE INTO THE VARIABLE
BEGIN...
August 22, 2004 at 4:29 pm
Ilan,
You can use Case on the right side of the "=" sign in SET statments... something like this (could understand exactly what you were trying to do in your example...
August 22, 2004 at 4:07 pm
Have you tried using the "Index Tuning Wizard" in Query Ananlyzer? It does do some remarkable things if you let it. And you would be surprised how much a single...
August 22, 2004 at 3:57 pm
Ilan,
Open "Books on Line" (comes free with SQL Server) and look up the BCP Utility. It has examples...
It may help you to know that BCP.EXE runs from the "DOS" or...
August 22, 2004 at 3:49 pm
Lot's of good ideas by lots of good folks... still, I think the clustered index is eating your insert time alive. Try removing all clustered indexes and adding non-clustered indexes...
August 20, 2004 at 12:34 am
One more thing... again, I don't remember the exact number but if you end up with over something like 254 columns in a table, IT CANNOT BE REPLICATED if replication...
August 16, 2004 at 11:07 pm
Unless you have TEXT or BINARY fields, you're also limited to (if I remember correctly) only 8096 bytes per row no matter how many VARCHAR(8000) fields you have. So, my...
August 16, 2004 at 11:06 pm
Henk,
The problem with CLUSTERED indexes is that they live in the data and should just not be used for transactional tables. Inserting into the "middle" of a 4 million record...
August 16, 2004 at 10:59 pm
I'll probably get a huge number of arguments from this but you're really opening yourself up to a world of hurt if you move into the TEXT datatype. They're difficult...
August 16, 2004 at 10:46 pm
Colin,
First, if you are not using the Enterprise Edition, adding memory over 2 Gig is fruitless because the Standard Edition is limited.
If this is something like a daily, weekly or...
August 16, 2004 at 10:39 pm
Oh crud... I just checked some of the switches for the scptsfr.exe routine I told you about and I don't think it'll work because the login is always "SA". If...
August 16, 2004 at 10:11 pm
Viewing 15 posts - 58,741 through 58,755 (of 58,872 total)