Depends how often you want to add space to your drives.

There's no need to have free space on the drive, as long as there's free space in the database files.

ALTER TRACE

And tell them to never use the Profiler GUI against a production server.

Too much of a hardware difference to say anything useful.

Execution plans of fast and slow?

???

There's no isolation level that will eliminate timeouts. Timeouts are a result of queries running longer than...

Megha P (12/10/2014)

---

Whenever ,i run query it shows in suspended states for a while in activity monitor,then in running states afterwards again in suspended states..and so on.so i thought ...

With read committed snapshot on, any request for read committed actually gets read committed snapshot. It's not a separate isolation level, it's read committed done with row versions.

Anything requesting serialisable...

Active-active never meant that both nodes were serving the same databases. That's never been how SQL clustering works. Active-active, before it went out of favour, used to mean two nodes...

No, you're breaking it up wrong (because the indentation's been lost)

Resource 1:

Resource 2 (which is actually the exact...

If the isolation level is enabled then you get the TempDB hit even if sessions are requesting other isolation levels. It's not necessarily going to be heavily used, depends on...

OS error 5 is access denied.

If it's a share check the permissions on the share and the folder. Make sure that there isn't an existing file of the matching...

This may be of use

https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

Could be the...

Jason-299789 (12/10/2014)

---

Over and...

Not a perfmon counter. A property of the final operator in the query plan.

Assuming that the contents are already valid XML, then

ALTER TABLE <table name> ALTER COLUMN <column name> XML

should do it.

If the contents aren't valid XML, you'll have to fix...