There seems an obvious advantage in giving warehouse dimensions and facts their own schema (dim, fact); but it might be more imagined than real. I have started using this separation; it allows the dim table prefix to be dropped which … Continue reading →
The answer is: Latin1_General_CI_AS. (the windows collation) This is Microsoft’s recommendation. It’s in article 322112 Comparing SQL Collations to Windows collations. References Collation Hell (Part 1) by Dan Guzman
Continue reading →The Problems IIS server is on domain A. Problem 1. User accounts are on domain A. Users access the site from a network outside the domain, with no domain trusts established. Problem 2. User accounts are on domain B. domain … Continue reading →
Snippets of code to create date-range parameter defaults for SSRS reports. PrecedingWeek The seven days up to and including yesterday. /* Yesterday = Yesterday’s date. SevenDaysAgo = Seven days before today: i.e. a week up to and including yesterday. 12/08/2014 … Continue reading →
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 →
Requirement: to use the a member Key in a report rather than the display name or Value properties. Problem the SSRS query builder doesn’t allow selection of properties to return. Reference to Fields!MemberName.Key returns Null in reports. One Solution: Locate following … Continue reading →
What are minimal permissions required for certain operations? Run Profiler ALTER TRACE SSDT Import a database schema into project VIEW DEFINITION VIEW SERVER STATE If working with multiple databases use VIEW ANY DEFINITION run on master. SSDT Make schema updates … Continue reading →
Problem Table contains two or three columns that should be output as a single column over two or three rows. Such as [Telephone1], [Telephone2], … columns in a table. Use Table Values constructor in CROSS APPLY clause Use the table … Continue reading →