Viewing 15 posts - 38,536 through 38,550 (of 39,804 total)
I think the IDEA of .NET is great. However, I am skeptical of the security and programming of the MS people as THE END ALL tool. They have a poor...
January 28, 2002 at 10:52 am
Interesting article. I like your point of view and tend to agree. The DBA is often responsible for the data as well as the system, and that is not the...
January 28, 2002 at 10:48 am
Haven't really worked with multiple instances, but I'd be inclined to let SQL manage memory.
Unless you ahve a good reason not to.
Steve Jones
January 28, 2002 at 10:46 am
Just my 2 cents.
I hate NULLs. I do allow them in places, but mostly for backwards compatibility. My personal feeling is that a value should always be known. Knowing it...
January 28, 2002 at 10:45 am
If there is caching, it is your app doing something funky within iteself or in ADO.
I've written a number of apps and this does not happen. When SQL Server caches...
January 28, 2002 at 10:41 am
I like to reduce Round Trips. Andy Warren has a few articles on this subject. I'd make one sp with 40 parameters. Not that the network overhead is big, but...
January 28, 2002 at 10:38 am
I agree with Brian. Give us your thoughts and we'll point you in the right direction, but we should not be answering questions for you about the test.
Steve Jones
January 28, 2002 at 10:36 am
I'd do a replace after the BCP. Look for "," and replace it with ,.
This is the simplest way.
Steve Jones
January 28, 2002 at 10:35 am
How is the server configured to startup? I think I ran into this when the server was running under local system, or perhaps a non-administrative account.
Try setting the server to...
January 28, 2002 at 10:33 am
Upgrade to SQL 2000 (you can run in sql 65 compatability mode until you upgrade the app).
However, this will not get the change you need. In SQL 6.5, you have...
January 28, 2002 at 10:32 am
January 28, 2002 at 10:29 am
January 28, 2002 at 10:28 am
January 28, 2002 at 10:22 am
Is this the same server begin upgraded? If so, then you should be able to upgrade through setup. Otherwise, use Brian's suggestion.
Steve Jones
January 28, 2002 at 10:21 am
I do not think so. Can you provide more information (text of errors, etc.)?
Steve Jones
January 28, 2002 at 10:16 am
Viewing 15 posts - 38,536 through 38,550 (of 39,804 total)