Viewing 15 posts - 16 through 30 (of 106 total)
Only when my waitfor was buggy and it went into a loop with no wait
December 17, 2003 at 10:27 am
When I said two tier would be out of the question I meant within the perspective of this topic - two teir meaning the data is downloaded and processed on...
December 17, 2003 at 9:56 am
quote:
the reason we want to switch to SQL Server is the amount of data we have - the application is getting slower...
December 17, 2003 at 9:54 am
Could also replicate the table that the FK would be referencing?
Unless the replication will not occur fast enough for any usability at all, this would at least allow you to...
December 17, 2003 at 9:27 am
Hrm.. actually though I have had to rebuild indexes on a 6.5 server a couple times. I forgot about that. I think it was telling me that the...
December 17, 2003 at 9:21 am
In my experience, statistics may need updating, indexes can become fragmented, and there is the rare (I think im aware of 2, both of which have had patches for a...
December 17, 2003 at 9:18 am
You could test these also against your data (assuming you have a good set to test against) for speed.
I tend to try to not use functions in filtering unless absolutely...
December 15, 2003 at 4:50 pm
quote:
You can use a powerful but little-known technique, namely a running update with variables:
I agree...
December 11, 2003 at 9:20 am
quote:
For a great discussion of your options, that can be done without iterating through each row, look at:http://www.sqlteam.com/item.asp?ItemID=3856
December 11, 2003 at 9:07 am
quote:
And worse yet, if someone goes back and edits an NAV from several weeks ago - I need to change ALL the...
December 11, 2003 at 8:38 am
quote:
The reason for the 4000 character limit within SQL Server is the limit for an nvarchar variable, the parameter for EXECUTE() or...
December 10, 2003 at 8:39 am
While I reproduced your issue below to make sure I understood, the only way I know of to fix it would be to reload as you said.
This shouldn't take a...
December 9, 2003 at 8:11 am
Sounds like it. Thanks jonathan you saved me some exploration time.
December 8, 2003 at 3:14 pm
You can use an update statement to achieve this... but Steve's way may be better. Have to test it i reckon.
You need a clustered index to use the update...
December 8, 2003 at 3:03 pm
You mean the problem field isn't part of an index itself? I noticed in later versions of SQL it will allow bit fields to be indexed, but seem to...
December 8, 2003 at 2:56 pm
Viewing 15 posts - 16 through 30 (of 106 total)