That memory consumption isn't from the query, it's from the buffer pool, memory in the buffer pool (used to cache data) isn't associated with any particular query because it's used...

You mean queries with high workspace memory grants?

Simple recovery it might be less if it can run minimally logged, but generally something like this is a size of data operation, so log space needed > data size.

The index build is using the transaction log. It's a single transaction, the log can't be reused until it completes.

Ed Wagner (11/27/2013)

I offered up...

Anyone want to handle this one?

'A server which sends custom alerts is sending notifications that an offline database is offline. Why would it do that?'

http://www.sqlservercentral.com/Forums/Topic1518022-146-1.aspx

I guess to answer that one would have to look at the server that's sending you that info and see what it's set up to send, when and how. None...

Depends on the company....

That's low page density, not fragmentation. When you say 'fragmentation', the general assumption will be that you mean 'logical fragmentation'

The optimiser has no knowledge of logical fragmentation. It has no...

Define 'internal fragmentation' please? It's not a standard term, it doesn't have a defined meaning, different people use it for different things.

That creates an index with very low fragmentation, not heavy...

The optimiser has no knowledge of fragmentation, therefore logical fragmentation cannot directly affect an execution plan.

Please don't cross post. It just ends up fragmenting replies.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1517984-391-1.aspx

DBCC ShrinkFile (or ShrinkDatabase) is the only way to release space back to the OS. Depending on what you deleted, you may need to rebuild the clustered index first if...

You can back up the entire database and then delete the older data. You can't take a backup of part of a database unless the database has multiple files or...