Forum Replies Created

Viewing 15 posts - 1 through 15 (of 32 total)

  • RE: A New Look

    Nice look and feel. Definitely will be reading from the mobile now.

    Like others, fix the white space and put the summaries first.

  • RE: Configuring SQL Server 2008 R2 Change Data Capture with SSAS

    If I understand correctly, your requirement is a transactional report showing login records between a date range.

    I didn't quite follow if it should also display either the latest user details...

  • RE: Staging -> Archive: Serialized or Parallel?

    Assuming the keys will be there is a bad idea. There is too much risk your package will break and problems tend to compound quickly when it does.

    I have known...

  • RE: Was This Week A Good Week?

    I compare how close to what I planned to do versus what I actually did to measure if I had a good week.

  • RE: Help with MDX SUM

    Seems like you are filtering the date in the where clause where you could simply limit the set in the rows.

    e.g.

    SELECT

    {[Measures].[Fact Patient Leaving Reg Fac Count]} ON COLUMNS,

    NON...

  • RE: Guidelines for need to consider for SSRS report development.

    There is nothing clear cut, as its all dependent on the developer.

    Break it into time estimates to get the data and writing the report layer.

    For data I'd consider factors like:

    ...

  • RE: Table defintion for SSAS

    The usual design is to have a Date dimension that only has Date hierarchies and attributes.

    A seperate Time dimension is optionally created if the business reports require you to do...

  • RE: 10 Bad Things About Reporting Services 2008 R2

    the lack of exporting to .xlsx is my number one hatred but the article definitely rings true

  • RE: Data Warehouse Fact Table Design Stumbling Block

    My approach would have a Payment Type dimension with a Payment Type attribute that has the specific type when just one payment method was used (i.e. Cash, Debit Card, Gift...

  • RE: Quality Over Timing

    I constantly see our developers slap on a new feature quickly thats poorly spec'd, quickly developed, and inadequately tested. Then the business wonders why they have scalability and performance issues....

  • RE: When To Touch

    I remember seeing a 3rd party stored procedure where the developers obviously didn't know the concept of transactions and had written code to throw data into a temp table then...

  • RE: 'Just Google It'

    I find Google is great for solving very narrow and well understood problems, or finding direction for broad less understood problems.

    However it's not great for solving broad less understood problems.

  • RE: Snoops

    Yes I could go through everyone' emails, payroll information, and revenue reports.

    But then I have all these massive secrets I have to keep to myself or get fired.

    Ignorance Is Bliss.

    Any...

  • RE: AS permissions?

    On a small note here, have you understood the difference between setting up someone as a server admin through the server properties and setting up security through roles within the...

  • RE: Precious Ideas

    I'm fairly indifferent really.

    I'm not going to use an ISV if I have time and expertise, nor would I do the support.

    If it performs bad its their problem, and being...

Viewing 15 posts - 1 through 15 (of 32 total)