sqldba551 (2/16/2010)

---

As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST...

It looks like there are some non-printable characters that aren't spaces but look like spaces. Edit the whole thing onto a single line then re-format. Seems to work

No it doesn't

Sure it does.

The execution plan...

How do you conclude that?

How about looking in Books Online?

allow updates Option

This option is still present in the sp_configure stored procedure, although its functionality is unavailable in SQL Server. The setting has no...

The error's not about the filestream. Check the setting for allow updates, I'd guess someone for some reason has set it to 1.

It's not required that a table have a clustered index in order to defragment a nonclustered index.

Please post new questions in a new thread. Thanks

No. The row will be locked,...

It's not a program, it's just a class of commands that the SQL engine understands, just like CREATE TABLE and the like.

You can use sp_helptext to see the definition of...

How big's the table? How many pages?

Not if those tasks have been scheduled nightly.

You can move master from one server to another. It often results in lingering, hard to debug issues, especially around server principals, but...

GT the risk that you're running there is that if that manual stats update was needed, some queries may now exhibit slow performance occasionally, when the stats are stale enough...

Take a look at this, see if the error you're getting is detailed and worked through. If not, post the error.

http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

GT-897544 (2/15/2010)

---

In SQL version is 2005\2008 Auto update statistics option is set 'on' by default at database level, no need to update stats frequntely, and also remember updating statistics causes...