dec 8 anders jeppesen Microsoft Windows Server

Boost network tranfer between windows server

Hi, I found a couple of easy tweaks optimizing the traffic when copying files between servers, in my lab it helped my throughput by 50%!. First add these keys to your registry: HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters Value =DisableTaskOffload Type = DWORD Data = 1 Value =EnableTCPChimney Type = DWORD Data = 0 Value = EnableTCPA Type = DWORD…

Read more

jul 26 Microsoft Microsoft CRM scripts T-SQL tables update

T-SQL Make SLECT statement only on fields with data in

If you need to make a data dump of a table but don’t want to have all the empty fields, they just run this script and it will create the needed select statement that you can copy paste into a new query. DECLARE @TAB_NAME NVARCHAR(MAX) SET @TAB_NAME = ‘SystemUser’ DECLARE @RET_QUERY NVARCHAR(MAX) SET @RET_QUERY =…

Read more