just popped into my head. Pretty sure it was an original...

CirquedeSQLeil (3/8/2010)

---

george sibbald (3/8/2010)

---

You know, I was just thinking,

It really frustrates me when people post replies and repeat almost exactly what I said minutes or hours earlier

does anyone else feel...

You know, I was just thinking,

It really frustrates me when people post replies and repeat almost exactly what I said minutes or hours earlier

does anyone else feel that way?

😀

you can start logshipping going whilst db is in use.

all you are actually doing is taking log backups so it will have no affect on the application.

exactly what...

Oh, OK, I misunderstood, so shared memory wasn't disabled on the SQL server itself?

Lynn,

is shared memory still disabled, that doesn't sound like a good idea for any local connections.

CirquedeSQLeil (3/6/2010)

---

Jeff Moden (3/5/2010)

---

Grant Fritchey (3/3/2010)

---

I think this really comes to down to personal preference and/or experience. Here's my 1.5 cents:

I am not certified. Based on my current job, salary,...

BCP, bulk insert or DTS.

sys.dm_io_virtual_file_stats is really only telling how the io is spread between the database files so is not really a help here.

To see if you have an improvement you need to...

Read only mode is exactly what it suggests, the database can only be read, no updates are allowed. SQL does not use locking algorithms when a databases is readonly so...

Enterprise edition is more scalable so its a question of whether you can leverage the extra power enterprise can give you, i.e. support for more processors and more RAM.

see

http://www.microsoft.com/windowsserver2008/en/us/2008-ent.aspx

if you want to bring a database online use 'restore database dbname with recovery'

the only way to put a database in norecovery is to run a restore with that option.

hello again.

yes it will

yes, but logs are sequential write so unless you have run out of space on disk no...