configure the min value to be a sensible value other than zero but not higher than max

in the interests of database\referential integrity don't re use them. As stated, if you're needing to re use the column it probably shouldnt be a PK.

you sure its not dis appearing ink LOL

backup and save your system databases first if you have already created logins, databases, etc

as Ken stated x86 is the version you require

Barkingdog (12/5/2008)

---

We are getting our first SAN (yeah!) and I think a good disk approach for an OLTP sql 2008 server is this:

drive C: OS, pagefile

drive D: tempdb

drive E: log...

begs the question, what other apps are running on these sql servers?

nick harris (12/5/2008)

---

Thank you for your replys.

So to list out the current spns I should use

SETSPN -L against what server? My domain controler or my database server? If...

32 bit or 64 bit?

dva2007 (12/6/2008)

---

Hi friends,

i have got sql server developer edition which is having different types.

SQL Server Itanium

SQL Server x64

SQL Server x86

I have got Windows Vista Home on my machine. Which...

there do seem to be problems with services running under domain accounts not registering their SPN's, local system works fine.

SETSPN -L

should list all registered SPN's (not just for sql server)

use...

a warm server should show very different memory usage

if you've only just started it, monitor for a week or so

how big is the database?

you could use SQLExpress 2005 if its under 4GB

from BOL

Logical and Physical File Names

SQL Server 2005 files have two names:

logical_file_name

The logical_file_name is the name used to refer to the physical file in all Transact-SQL statements. The...

the logical filename is generally used internally by SQL server, changing it to something different after copying the database is something i would defintiely do.