Viewing 15 posts - 8,971 through 8,985 (of 9,248 total)
you could use IPSec to secure communication between the 2 machines
August 25, 2008 at 3:56 am
are these packages stored in the MSDB database?
August 25, 2008 at 3:54 am
sql 2005 enterprise can only be installed to appropriate server operating system. For Vista\XP you will need developer or express edition
August 25, 2008 at 3:53 am
marius.draganescu (8/22/2008)
Duck ...
August 23, 2008 at 6:08 am
hengert (8/20/2008)
I used "1/1/1900", maybe it only accepts single quotes then. I'll give it a try. Thanks.
yes you need to use single quotes
August 22, 2008 at 9:52 am
unikhath (8/22/2008)
Yes, I'm installing Developer edition on my machine for development and using Enterprise edition on the clients site during production.Thanks for the help.
should be just fine
August 22, 2008 at 9:50 am
probably need to clarify a little further what you are intending to do
August 22, 2008 at 9:49 am
Thayal Muhunthan (8/22/2008)
FOr SQL data, logs, tempDB, I have SAN disk.
if the RAID 10 storage for all this is SAN based then thats a different situation all together. 146...
August 22, 2008 at 9:43 am
Ray Herring (8/21/2008)
and your growth is small then you can end up with a very large, very fragmented file.
shrinking and growing files can cause fragmentation at the file level too
August 21, 2008 at 4:41 pm
DBCC LOGINFO should show the status of the log file.
August 21, 2008 at 4:24 pm
what is min memory set to on the instances?
August 21, 2008 at 4:22 pm
theres no point in RAID 10 for the OS thats just a waste of disks (these would be local disks anyway presumably).
Use RAID 1 for OS
all depends on how...
August 21, 2008 at 4:09 pm
Developer edition offers all the features of enterprise, as a developer you would want to use this edition (hence its name 😉 )
if you need a server installation to eventually...
August 21, 2008 at 1:12 pm
Thayal Muhunthan (8/21/2008)
We have 2XQUAD processors. Do we go for SQL 2005 standard or Enterprise ?
do you plan to use the Enterprise features or not, in most cases SQL2005...
August 21, 2008 at 10:02 am
GilaMonster (8/21/2008)I thought it was worth repeating and expanding on.
for sure, considering he still mentioned using it 😉
August 21, 2008 at 8:52 am
Viewing 15 posts - 8,971 through 8,985 (of 9,248 total)