No.

The option affects where SQL allocated sort space during and only during an index...

No.

A restore over an existing database is equivalent to dropping the old DB and replacing it. It's not a merge, SQL discards the existing DB and completely replaces it with...

In that case, I'll take it. Won't be this month though. Is that OK?

It's used for temp tables, table variables, sort and hash spills (which you generally don't want because they're slower than hash/sort done in memory) and for work tables which the...

Short of writing a SQL parser in T-SQL, probably not.

ALTER DATABASE ... MODIFY FILE, set the new name. Take the DB offline. Copy the files to their new location, ensure SQL has permission on the folder, bring DB online.

Transactional replication, change data capture, mirroring, availability groups, log backups, full/diff backups, transaction rollbacks all read from the log.

Could be the writes to the log from the rebuild have a...

Personally I like conservative, it reduces unpleasant surprises.

Just don't use Task Manager to monitor SQL's memory, it...

sqlbuddy123 (4/15/2014)

---

LPIM behaves differently on 32 bit and 64 bit systems and so is the AWE API. It's complex and lot of analysis is needed to get the true meaning....

16 is probably a good place to start.

mlwiller2 (4/15/2014)

---

I'm still getting that error but when doing select @@version it says I'm at 0.0.5000 (sp4). Tried the exec xp_readerrorlog command and still didn't get the "locked memory in...

If you have a job scheduled for 2pm, 4pm and 6pm, the job starts at 2pm is still running at 4pm and finishes at 4:15pm, the job wills start again...

ChrisM@Work (4/15/2014)

---

Your query filters out a very small number of rows from the table - you may as well scan them all from an index ordered by , which should...

Table definitions and index definitions please.

Table definitions, index definitions and execution plan please.

How many rows qualify for that where clause predicate?