Forum Replies Created

Viewing 15 posts - 181 through 195 (of 237 total)

  • RE: ExecutionLogStorage table and Subscriptions table

    Here's a query cobbled together from various sources that gives you a fair bit of info including report execution duration. If you've used a shared schedule then the schedule name...

  • RE: alterning colors

    Hi,

    The query results you've provided are not enough to reproduce your problem. When I set up a report like this, there are only two rows and the second row background...

  • RE: Add or Edit Delivery Extension - Unicode?

    Hi,

    I've created a test report with a table in it. I've set the font to Arial Unicode MS. I've used Chinese characters because I'm pretty sure they are multibyte.

    Rendering...

  • RE: Parameter being disabled even though it's not a cascading parameter

    The ordering of parameters in the Report Data window in Visual Studio is also the cascade order when you've set up dependencies, but you seem to be well aware of...

  • RE: Restart Log Backups

    Thanks for the clarification Lynn, it makes more sense in that context.

  • RE: Restart Log Backups

    Normally I answer these without looking up BOL first but this time I thought I'd double check.

    Unfortunately this myth comes straight from the horse's mouth:

    "Before you can create the first...

  • RE: SQL 2012 Data Warehouse Suggestions

    I'm probably not the expert to talk about the normalised vs star schema debate. It's a difference in philosophy. Bill Inmon is a proponent of the normalised data warehouse and...

  • RE: SQL 2012 Data Warehouse Suggestions

    JJ-469859 (6/15/2012)


    ... are you planning on using both AlwaysOn to create a read-only copy for OLTP reporting and then also creating a DW in SSAS? Or if you do a...

  • RE: Technology Guilt

    luke.warneminde (6/14/2012)


    the original weavers in England destroyed the looms in protest of being replaced by unskilled machine operators.

    Another story has the workers in the Netherlands throwing their sabots (shoes) into...

  • RE: Technology Guilt

    "It seemed to be a capitalist market idea that change will occur, new industries will arise as old ones die"

    Interestingly, this idea is called "Creative Destruction" and actually comes from...

  • RE: Stop Food Waste - OS Open Data & SQL Azure

    Very interesting project. I've also made use of that Shape2SQL program.

    I find that a lot of the shape files available are way too detailed for most practical mapping purposes....

  • RE: Index defaults 1

    Trick question is not quite the right description of this.

    I was one of the "myth" believers and now I've learned something. Whilst it might have been a bit painful getting...

  • RE: Transactions 3

    Transactions are not an error-handling mechanism; they're a data consistency mechanism.

    I think that pretty much summarises this interesting discussion.

  • RE: Transactions 3

    Is this not the same question that we've had three times now?

    Maybe the addition of set XACT_ABORT OFF

    But it's off by default, right?

    I guess it reinforces how transactions work...

  • RE: Backups

    I'm not sure if a page at simple-talk from 2006 qualifies as a good reference, although BOL has its fair share of errors anyway so probably not worth worrying about.

Viewing 15 posts - 181 through 195 (of 237 total)