Viewing 15 posts - 36,406 through 36,420 (of 39,903 total)
Not sure you need to change anything. Was this a same server upgrade? AFAIK if Windows sees 2 CPUs, then SQL will.
Steve Jones
June 11, 2003 at 10:48 am
I used to reboot quarterly, apply patches, etc at that time.
However with W2K, it's not that much of an issue. We have been getting enough reboots lately with the patches...
June 11, 2003 at 10:47 am
Not easy to do in this version of Snitz, but something that we've taken note of.
Steve Jones
June 11, 2003 at 10:36 am
I'd like to add as well that %Disk Idle time is a great and more informative counter for how busy the disk is. The %Disk Time suffers from some issues...
June 10, 2003 at 12:26 pm
June 9, 2003 at 2:59 pm
Be sure you don't have any interactive elements in the package. If so, it will stall waiting for input. Usually this is either a message box or an error with...
June 9, 2003 at 8:44 am
This is probably the best way. Simple and easy. I do something similar, but have DTS to migrate a bunch of this data to one server for a daily report....
June 9, 2003 at 8:40 am
I don't think so, but you'd have to try it. Not sure if there is anything in the multi-server code that would stop this.
Steve Jones
June 9, 2003 at 8:35 am
We have hundreds of servers (600+) here, over 100 SQL Servers, who knows how many dbs. In Operations we manage about 55 servers (about because we only do backups on...
June 6, 2003 at 11:43 am
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
also parts 2 and 3
Steve Jones
June 4, 2003 at 9:49 am
don't remove the pk. delete the rows and reimport them without set identity_insert to give them new values.
if that's not possible, you can remove the identity (Requires a table...
June 4, 2003 at 9:39 am
Someone else needs to verify, but as far as I remember, if you use PAE, you do not use AWE.
sorry, i missed the 3gb in your first post.
Steve Jones
June 4, 2003 at 9:28 am
search sp_help_revlogin on technet. use this to script out the logins. Then change pwds and if you want, delete 1 a week after trying to find where they are used....
June 4, 2003 at 9:25 am
Excellent list of lessons learned that everyone should follow. Whether you are a PM or a developer. My wife follows these as a consultant, often having PMs that don't, and...
June 4, 2003 at 9:22 am
they have a low end version that just reads for around US$400. The higher end version will undo transactions by generating a script to undo the action.
I thought lockwood was...
June 3, 2003 at 3:52 pm
Viewing 15 posts - 36,406 through 36,420 (of 39,903 total)