Time Dimension creation script DDL for a time dimension table. Create table DimTime ( time_key smallint NOT NULL, time_type varchar(20) NOT NULL, full_time time(0) NULL, hour_of_day tinyint NULL, minute_of_hour tinyint NULL, hourly_segments varchar(13) NULL, minute_15_segment_key tinyint NULL, minute_15_segments varchar(13) NULL, … Continue reading →
Interpreting data in ReportServer database Observations from SSRS 2008 R2 Subscriptions table dbo.Subscriptions. InactiveFlags There’s no way to disable a subscription from SSRS UI though articles suggest setting InactiveFlags to 1 will achieve this. 0 : schedule is active. 8 … Continue reading →
Introduction Avoid all use of the Performance Monitor interface by using typeperf.exe (the oddest of names). Brent Ozar’s Tutorial on SQL Performance Monitoring – using performance monitor manually to gather SQL-relevant counters. Shaun J Stuart Baselining SQL Server Part 1 and … Continue reading →