Viewing 15 posts - 39,511 through 39,525 (of 39,717 total)
Thanks for the complements.
Nice solution. I wish I'd included this one :).
Steve Jones
October 5, 2001 at 1:57 pm
You could also do an spDropserver <servername> then an sp_addserver <newname>, local .
Steve Jones
October 5, 2001 at 10:09 am
They used to have them here:
http://msdn.microsoft.com/msdnnews/archive.asp
You might email the MSDN folks and ask. (and post back here).
Steve Jones
October 5, 2001 at 10:07 am
This is a good document:
I have my web servers dual homed (actually triple). It looks something like this:
...
October 3, 2001 at 10:15 am
October 3, 2001 at 9:59 am
Can you try starting with minimal config (-m I think) and check your sp_configure settings?
Steve Jones
October 3, 2001 at 9:57 am
I understand trying to remove connections if there are licensing issues, but otherwise, I agree with Andy. Why kill an idle connection. They use tens of kb of memory and...
October 3, 2001 at 9:53 am
OK, OK, I'm awake. BTW, I'm not that lazy, I just live in Denver.
OK, I think that a UDf would be great for calculations. they really make things easier to...
October 3, 2001 at 9:49 am
October 2, 2001 at 10:23 am
This is an interesting thread. My 2cents:
I think the production dba will continue to exist in larger shops. Even with the advances and ease of administering SQL Server 2000, quality...
October 2, 2001 at 10:18 am
there are a bunch of ways. is this a scheduled job? Add a step before that uses a CommandExec and a "del filename". you could also add a step to...
October 2, 2001 at 9:46 am
This is corect. All the changes in SQL are considered a single transaction if this is one statement. This would be an implicit transaction.
Steve Jones
October 1, 2001 at 10:15 pm
October 1, 2001 at 10:13 pm
September 28, 2001 at 9:05 pm
Here are a few links:
http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/tips/storagen.asp
http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/tips/storagen.asp
Steve Jones
September 28, 2001 at 8:35 am
Viewing 15 posts - 39,511 through 39,525 (of 39,717 total)