Viewing 15 posts - 1 through 15 (of 36 total)
stakes (4/23/2015)
Eric M Russell (4/23/2015)
April 29, 2015 at 7:09 am
Never heard of it, so I googled. Found this: http://msdn.microsoft.com/en-us/library/dd340753.aspx
There it says 'CurCmd', not 'CurrCmd'. Apart from that all 5 seem to be correct.
October 22, 2014 at 12:47 am
Is it a filestream database? In my experience, such a db with many small files is slow in backup.
September 12, 2014 at 3:40 am
Eirikur Eiriksson (9/9/2014)
Alan.B (9/9/2014)
Cool. I never knew you could do that, very interesting :laugh:
Edit: sql code tag messed up...
September 11, 2014 at 12:58 am
I suspect sql2012 (SP 2) of still having a memory leak. We have a daily job (on a test system) that runs fine for about a month until it starts...
August 13, 2014 at 3:54 am
Some years back we had a real big software release during the weekend, working long days.
Part of the release involved adding a column on some tables and filling it with...
March 21, 2014 at 3:55 am
I am sure the role of the DBA will continue to change. But dead? Certainly not.
The DBA isn't dead. He just smells funny. (Zappa)
January 31, 2014 at 4:22 am
marlon.seton (10/28/2013)
nickd-799913 (10/28/2013)
October 30, 2013 at 12:55 am
Saravanan_tvr (10/15/2013)
But without creating one more instance, previously it added the new column in to CDC tables.. how it was? I cant digest the behavior of CDC?
When you remember how...
October 15, 2013 at 7:27 am
Works as intended.
An added column will not be included in an existing cdc table.
A deleted column will result in NULL in the corresponding column in cdc.
Only solution is to create...
October 14, 2013 at 6:57 am
Does this answer your question?
http://www.sommarskog.se/query-plan-mysteries.html#defaultsettings
Oh, sorry. Just saw you already read that.
October 31, 2012 at 7:39 am
Hi,
To find the plan, you could try something like this
SELECT TOP 100 [Average CPU used] = total_worker_time / qs.execution_count,[Total CPU used] = total_worker_time,[Execution count] = qs.execution_count, qs.total_logical_reads TotalPageReads, qs.total_logical_writes TotalPageWrites,last_execution_time,[Individual...
October 10, 2012 at 1:10 am
Viewing 15 posts - 1 through 15 (of 36 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy