Faster BLOC Response group reports

The Lync/Skype4b lcsCDR database is missing some indexes by default that can speed up the reports included with it.  To add those indexes you should run the following.

CREATE NONCLUSTERED INDEX [IX_CdrRGSUsage_MissingIX] ON [dbo].[SessionDetails]
(
 [ReplacesDialogIdTime] ASC,
 [ReplacesDialogIdSeq] ASC,
 [MediaTypes] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_CdrRGSUsage_MissingIX2] ON [dbo].[SessionDetails]
(
 [CorrelationId] ASC,
 [MediaTypes] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO