Improve performance on large dataset queries on Dynamics CRM 2011
- May 7th, 2012
- By Germán Medina
- Write comment
$LiveCred = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection
Import-PSSession $Session
Add-MailboxFolderPermission -Identity “userA:\Calendar” -AccessRights PublishingEditor -User UserB
Remove-PSSession $Session
sc delete “Service Name”
This code will populate a date/time table for a cube or any other purpose in SQL Server.
declare @start datetime, @end datetime, @date datetime, @hour int select @start = '2011-08-01 00:00', @end = '2013-01-01 00:00' set @date = @start while @date < @end begin set @hour = 0 while @hour < 24 begin insert into [date]([id], yeardate, monthdate, daydate, hourdate,[year], [month], [day], [hour]) values( ltrim(datepart(year, @date)) + '-' + ltrim(datepart(month, @date)) + '-' + ltrim(datepart(day, @date)) + ' ' + str(@hour) + ':00', ltrim(datepart(year, @date)) + '-01-01 00:00', ltrim(datepart(year, @date)) + '-' + ltrim(datepart(month, @date)) + '-01 00:00', ltrim(datepart(year, @date)) + '-' + ltrim(datepart(month, @date)) + '-' + ltrim(datepart(day, @date)) + ' 00:00', ltrim(datepart(year, @date)) + '-' + ltrim(datepart(month, @date)) + '-' + ltrim(datepart(day, @date)) + ' ' + str(@hour) + ':00', datepart(year, @date), datepart(month, @date), datepart(day, @date), @hour) set @hour = @hour + 1; end set @date = dateadd(day, 1, @date) end
This query will retrieve the rounded (2) size (MB) of all your tables on a SQL Azure database.
select
sys.objects.name,
cast(round(sum(reserved_page_count) * 8.0 / 1024, 2) as float) as size
from
sys.dm_db_partition_stats,
sys.objects
where
sys.dm_db_partition_stats.object_id = sys.objects.object_id
group by
sys.objects.name
order by
size desc
Linux Integration Services Version 2.1 now has support for Timesync, Integrated Shutdown and Symmetric Multi-Processing (SMP) up to 4 virtual processors.