TBH i'm surprised it's only the apps that crashed.

Matt Miller (9/30/2008)

---

As to the clustered index - rebuilding a clustered index = rewriting an entire table, so it's not out of the question that the file would be just...

remove the /3GB switch from the boot.ini and reboot the server.

This switch is not required and indeed shouldn't be used for machines with 12GB RAM or more

wow, sounds like it should do the job!

what disk config you going for?

how many\large databases do you anticipate?

how many user connections?

how many instances?

Why have you specified

exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'

twice

its ok but i think he just wanted a quick and dirty guide on the usage of the...

roger this is the clue 😉

can you post the...

SanjayAttray (9/29/2008)

---

If I were you, then I would create a temp table in database and move all records of last 30 days into it and then drop original table and...

that's exactly what you do

BOL is a good start

as a side make sure you change the account details via SQL configuration manager 😎

the datareader role should grant select to all tables

you should be able to patch both instances at once, did you select both detected instances?

Have you checked the patch log file to find out why it failed?

wow as little as that. 20GB will just about home the OS,...

stick it on the moon then its got all the space it needs.