Viewing 15 posts - 10,801 through 10,815 (of 49,566 total)
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...
November 28, 2013 at 12:52 am
You mean queries with high workspace memory grants?
November 27, 2013 at 11:24 pm
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.
November 27, 2013 at 7:44 am
The index build is using the transaction log. It's a single transaction, the log can't be reused until it completes.
November 27, 2013 at 7:14 am
Ed Wagner (11/27/2013)
GilaMonster (11/27/2013)
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 offered up...
November 27, 2013 at 6:26 am
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
November 27, 2013 at 5:46 am
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...
November 27, 2013 at 5:45 am
MohamedDBA (11/27/2013)
But after I get these certificates what is the name of my job will be ( Senior DBA , or Senior Systems Administrator ... etc )
Depends on the company....
November 27, 2013 at 5:07 am
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...
November 27, 2013 at 4:54 am
Define 'internal fragmentation' please? It's not a standard term, it doesn't have a defined meaning, different people use it for different things.
November 27, 2013 at 4:41 am
SQL Show (11/27/2013)
--Now I’m creating one NCI with heavy fragmentationCREATE NONCLUSTERED INDEX [idx_BigTable_SomeColumn1] ON [dbo].[BigTable1] (c2 ASC)
with fillfactor=2
That creates an index with very low fragmentation, not heavy...
November 27, 2013 at 4:28 am
The optimiser has no knowledge of fragmentation, therefore logical fragmentation cannot directly affect an execution plan.
November 27, 2013 at 4:24 am
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
November 27, 2013 at 4:22 am
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...
November 27, 2013 at 3:54 am
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...
November 27, 2013 at 3:39 am
Viewing 15 posts - 10,801 through 10,815 (of 49,566 total)