SELECT * FROM @test1 t2

WHERE NOT EXISTS (SELECT 1 FROM @Test2 t2 WHERE t1.Field1...

Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Not really that way, depends on the database activity, the portion of the DB that is heavily used, the workload and a whole bunch of other things.

For what to leave...

It's in the suspended state because it's waiting for a mail to send. When a mail is sent, it will run, send the mail then go back to waiting for...

Maybe....

Please post new questions in a new thread. Thanks

The thing is, the memory allocated by AllocPhysicalPages is known as AWE memory, so it's not a misleading display, it's correct. AWE does not just mean the 32 bit memory...

http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/

The 'table variables are memory only' is an all-too-common misconception. Both temp tables and table variables are allocated space in TempDB and added to the tempDB system tables. They may...

DEpends whether the sort's expensive enough to justify a duplicate index.

mehta.saurabhj (3/21/2013)

---

@sean-2 lange As per my knowledge when you create a non clustered index on a table column they occupy some space in memory as a hash tree or...

If it's a NAS, you need to make very sure that is supports SQL's IO requirements. SQL requires write order preservation and that there be no sector rewrites.

IO contention won't...

It might. Test it, test a stats update and see which if either makes a noticable difference

Is the index rebuild necessary?

Transactional replication?

Don't mix up the AWE memory allocation API, which is used any time that locked pages is enabled, and the AWE setting which is only for 32 bit SQL.

Yes, if...