Viewing 15 posts - 1 through 15 (of 84 total)
Darko, is it possible to provide clr assembly code?
February 27, 2017 at 7:47 am
Ran dbcc checkdb with allow data loss. Could not fix pfs page corruption(Also according Paul Randal, they can not be fixed). These pfs pages in a filegroup where it is...
November 1, 2016 at 8:10 pm
technically you can not reply on it since
1. sproc's with recompile clause would not stay in cache.
2.if there is memory pressure or something(server restart, manual reset) dm_exec_procedure_stats might be...
May 20, 2016 at 8:40 am
you get to be very careful. In a busy system, there are lot of threads would get access before you can get access, such as replication spids, log shipping, users...
November 20, 2015 at 1:19 pm
on top of that, if sql knows there is nolock hint used, it might decide to do allocation order scan in same situation which might be faster.
November 2, 2015 at 9:12 am
Thanks Hugo. I had the impression that all constraints are checked before any updates. Now I recalled in Itzik Ben-Gan's book that it mentioned the order of execution.
November 2, 2015 at 8:01 am
Great question. I did not get "Nolock CAN cause the query to return data that violates constraints". I thought that constraints are checked first before any insert/update etc. Could you...
November 2, 2015 at 7:17 am
Guys, pls read book on line about avg_fragmentation_in_percent and other columns for heaps. in general for heap fragmentation you do not look at avg_fragmentation_in_percent.
May 21, 2014 at 1:16 pm
Igor pls read Paul's blog carefully yourself. rebuild heap table will remove fragmentation even it might not be a good idea since it is expensive.
May 21, 2014 at 8:11 am
I appreciate what sqlservercentral provided to the sql community and all these greatest sql books red gate/authors provided for free.
I also do not think sqlservercentral/red gate should really honor the...
December 5, 2012 at 2:03 pm
i ran into a situation tempdb was full and terminated after a long run. It seems very heavy to run.
July 10, 2012 at 2:13 pm
even you only one physical nic, you still can configure (virtually) the multi-homed sql server to listen on multiple ports. In some situation you might want to do it.
October 17, 2011 at 8:58 am
I am extremely horrible to remember names. But I know them( I meant I know their names). I remembered that Steve Jones posted a daily question to ask if you...
October 7, 2011 at 11:14 am
If you do not know Gail Shaw and Jeff Moden, it would surprise me a lot.
October 7, 2011 at 9:04 am
I bulk imported them to new server before by using ssis to dump sysdtspackages in msdb. I did not remember exactly how, but it is way to go if tons...
August 26, 2011 at 9:27 am