Viewing 15 posts - 38,176 through 38,190 (of 39,456 total)
I'd do the backup if you don't have the time.
If you do, try the detach, attach
Steve Jones
January 29, 2002 at 11:30 am
I think the consensus is to let SLQ manage the memory. If one server is not getting what it needs, I'd add memory before messing with the settings.
Steve Jones
January 29, 2002 at 10:55 am
It should work, but I'm always a little nrevous about moving between versions with something like this.
Steve Jones
January 28, 2002 at 5:08 pm
I personally disklike the cascading deletes. Maybe I'm cautious, but I prefer that the rows be explicitly deleted.
Steve Jones
January 28, 2002 at 5:07 pm
January 28, 2002 at 1:31 pm
Excellent article Brian. It is one of the best written articles I have seen on stored procedure execution on the server.
One issue I was wondering if you'd look at...
January 28, 2002 at 1:30 pm
Shouldn't be any different. Still need to add a reference to the COM component for DTS or DMO.
Steve Jones
January 28, 2002 at 1:20 pm
Common Language Runtime. This is the platofrm on which the compiled applications (in C#, c++, VB, Perl, etc) run. This is an abstraction from Win32 so it can be written...
January 28, 2002 at 12:33 pm
I agree with your points. I'd consider encyption for non-key fields, like salary. However, I'd want to place the key management in someone else's hands. After all if I hold...
January 28, 2002 at 12:32 pm
January 28, 2002 at 12:30 pm
Rather than the machine name, rigorously enforce user names that are unique to each user and apss this in.
Steve Jones
January 28, 2002 at 12:28 pm
I agree with Brian, but you need a couple boxes to test the failover and then how you fail back. Keep in mind that replication will fail once the primary...
January 28, 2002 at 10:53 am
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
Viewing 15 posts - 38,176 through 38,190 (of 39,456 total)