Viewing 15 posts - 8,971 through 8,985 (of 9,244 total)
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2008 at 9:50 am
probably need to clarify a little further what you are intending to do
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:41 pm
DBCC LOGINFO should show the status of the log file.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 4:24 pm
what is min memory set to on the instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 8:52 am
Wilfred van Dijk (8/21/2008)
AFAIK, you need to restart SQL in order to make these changes for @@SERVERNAME
yes that is correct
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 8:50 am
GilaMonster (8/20/2008)
You can't do Raid 10 (striped and mirrored) with only two drives. It requires a minimum of 4.
Gail i pointed this out already but he still plans to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 5:51 am
SQL Noob (8/20/2008)
this applies only to 32 bit versions
according to the MS features the only memory caveats are for 64GB RAM and above
SQL2005 Std however will support OS max RAM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 5:47 am
windows authentication is a default, when you rebuilt did you script off any login info before hand? like sql logins, windows logins have to be added to the server too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 5:38 am
Viewing 15 posts - 8,971 through 8,985 (of 9,244 total)