Always wanted to use ERWin ... and as far as i'm aware, it IS one of very few version control systems for DB's on the market. Another option is Visio...

Remi .... u just on a mission to get ur "posts" up to Steve and Frank's scores or summat???

Is the DHCP on the Router or ur domain controller?? ... i'll assume for now that u'll be using the DC for the DNS!

If u dont have the DC controlling...

changing the Port the SQL Server is listening on is pretty much standard practice now, in the aftermath of Code red and slammer! Highly recommended! Not entirely convinced having a...

ur question is a bit too vague ... There isn't any way you can "guestimate" how many transactions a particular server can do! It depends ALOT on the transactions u...

foreign Key fields are also a good bet for an non-cluc indexes as well!

If u do this, u would just get an permissions error if u tried to do a "SELECT *" !!

You'll need to specify the fields you want when doing the...

yes, but it needs its OWN set of Cluster Disk resources, ie one for the shared files (master, temdb etc), and the other for the Log and DB files. Apart from...

Check ur indexes ... u see this kind of behaviour when u try to index a calculated column. Theres a very specific set of rules to be able to do...

another thing to note here is that u can only do this when the "Recovery Mode" on the database is set to "full" ... otherwise, it just wont let u...

as an additional note to what steve said, u'll have to setup and "Alias" for the server on the client machines after changing the port. This can be done with...

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.asp

The document on this page is the "guru's guide to SQL Licensing" ... but as the guys have already said, if u have an internet facing application that's using...

it's already done ... and is quite easy really! each webserver (x3) has a front end NIC team and they're then just load-balanced with the Windows Network Load Balancing (with...

... and i thought OUR system had redundancy!?

Yes, this will work fine ... SQL will just see the team as a single...

this statement or the LIKE version thereof would both work fine. However, given the number of records, creating a new, calculated column based on the last 4 digits and then indexing...