https://www.google.co.za/?q=SQL+Server+2014+new+features

Maybe, maybe not. No hard answer there. Depends if you're seeing IO contention or not. If not, then splitting them out is a huge amount of work for minimal gain.

Deletes...

No, not unless the file groups in question are read only.

To restore a DB from file/filegroup backups, the following is required:

1) If the DB is in simple recovery, then any...

I'm going to assume by that question that you don't have a backup.

If you do have a backup you can restore, please rather do that.

The hack is on Paul...

Same way as any other statement. There's nothing special about inserts

if I run the...

lmarkum (1/20/2015)

---

Any time you insert data that is involved any one of the indexes, you will get an insert for that index as well as an insert into the...

With a single select it's not necessary. With multiple selects, if you're running under the default isolation level then the transactions don't change anything about how the selects behave, in...

Underscores?!?!?! Heretic! Burn him!

:hehe:

Can you restore a backup?

If so, do so.

If not, you'll have to hack the DB into the server and repair it, you may lose data, you may lose...

Ok, not an SSMS version mismatch.

Offhand, not sure. Have you tried doing the mirroring setup in T-SQL instead of the GUI?

And the results of SELECT @@Version on both principal and mirror?

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/

I use ID, everyone else in my company uses Id.

Huh?

Don't understand the question.

Those 4 exams are for two different certifications, so which you take depends on which certification you want.

There's no higher certification level than the MCSE.