Creating an index will usually require additional space in the mdf...could be down to autogrowth?

Or have you set the database to simple recovery model while you're building up the index,...

May be worth reviewing this;

http://support.microsoft.com/kb/922527

If there's any chance that there was a console log off (compare to the security event logs on the server to see if there...

This will also probably help answer your query in regards to the 2 AD groups;

http://www.sqlservercentral.com/Forums/Topic368179-6-1.aspx#bm951922

The user will normally retain the highest level of permission I believe, in that...

Whatever account the user is logged in at the time, will be passed to the SQL Server for authentication by default, with windows authentication (pass through).

You can of course mask...

Okay, if you base your database for the system in SQL Server, you have a few options.

You can either use SQL Mail or send via SMTP directly using CDOSYS (see...

GSquared (1/4/2011)

---

Rebuilding indexes takes space in the file, unless you specify doing the work in tempdb (check the documentation on rebuilding for the option for that). Once it's done,...

If it's in Access, there isn't necessarily any SQL Server required at all, so this may be the wrong forum for you, but if you're talking about an access front...

If you were happy to go down the VM route, the license allows you to install 4 Virtual Machines, EACH of which grants you up to 50 instances, therefore making...

I must admit, I've never had to cater for filestream data so far, and it does pose some otherwise more difficult manageability issues which other methods don't.

You do have the...

Log shipping is fairly easy to implement, and you can set it to run at a schedule which suits you (i.e. less frequent if you find it is causing any...

Some very nice links there, thanks 🙂

I have read a few things contradicting the sqlskills article too, just as the author suggests, so the sqlskills link clears it up nicely...

Thanks David,

Yeah it will be the same number of physical disks for the user db, but by splitting particular tables or parts onto alloted disks, I'm assuming greater efficiency simply...

Excellent, thanks guys.

Sorry, I really didn't give enough info earlier.

I do have separate physical drives for the log files (ldf's) and other separate drives for the operating system, backups and...

Sorry, I should have said the disks for the data partition (which the mdf is sitting on at present) are on RAID 10 configuration, not just 4 joined disks...the usable...

It's better to follow the custom installation if you know exactly what parts you need and where you need to put them, but in this case, the version of SQL...