Possibly because they're doing something that doesn't work in fibre mode. There's a number of things that don't. Difficult to say for sure though.

SQL does not randomly change its configuration settings. Someone went in and enabled that feature.

Check the SQL Error log, there will be an entry in there from when the...

Start by identifying queries that are performing badly.

I would...

You can do asynchronous mirroring without a witness, but it doesn't have the same level of data protection as synchronous, manual failover is required and there's a chance of data...

paul.knibbs (2/9/2010)

---

Or, I could shut the machine down and use some sort of boot CD to entirely delete the file containing the security event log, thus bypassing the "clear" option...

Absolutely.

Any unexpected restart of the SQL...

Considering it requires local administrator permissions, I wouldn't really call it a back door. Someone with local admin could just as easily stop SQL and copy off the data and...

Please read through this - Managing Transaction Logs[/url]

Please post table definitions, index definitions and actual execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

The exec plan that you posted earlier is the estimated plan and is missing certain key information.

Henrico Bekker (2/8/2010)

---

Gail, Steve, taken from the MS site on 70-450...

Microsoft E-Learning

There is no Microsoft E-Learning training currently available.

Microsoft Press Books

There are no Microsoft Press books...

Maybe, but you should test. The time for restoring the full won't change. Whether the restoring of all the tran logs is faster or slower than a single diff, that...

Roust_m (2/8/2010)

---

If I do weekly index rebuild for all indexes on user tables in all user databases, would this mean that all the indexes are going to show on this...

Have a look at this thread where the complexities of 'unrecoverable deletes' was discussed.

http://www.sqlservercentral.com/Forums/Topic857162-391-1.aspx

Well, all the study books are copyrighted, and I'm sure you're not asking for illegal material. Most of the free stuff is questionable and often braindumps (questions taken straight from...