Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • Reply To: Need to export excel sheet with SPECIAL formats

    The SSRS option can be a useful & less complex option if there is a lot of formatting to apply.

    Another option to consider if the requirement relates to formatting based...

  • Reply To: Job Activity Monitor view - but where are the In Progress jobs?

    Same issue (5 MORE years on!) sysjobhistory does not appear to ever contain any rows with run_status 4 (in progress), despite the documentation... (checked on SQL2014 & SQL2017). Even tried...

  • RE: The Last Service Pack

    I'd like to share your optimism for the CU release model, however so far we have had a couple of not so good experiences in this space with SQL Server...

  • RE: Obsoleting Unused SSRS Reports

    Warning: You will need to be careful with any sub-reports that are defined and deployed - sub-reports do NOT appear in the execution log when the "parent" report is executed...

  • RE: Alter Column

    The unfortunate answer to this question has always bugged me. - It just doesn't make sense that ALTER COLUMN is not allowed on a computed column...

    The DROP COLUMN + ADD...

  • RE: Fixing CREATE TABLE

    The inability to put inline comments in to describe the purpose of table columns I don't have a problem with - such metadata IMO should instead be directly attached to...

  • RE: Report Builder or Reporting Services?

    A couple of my "BIDS vs. Report Builder 3.0" thoughts:

    Report Builder 3.0 coupled with some well designed Analysis Services cubes and/or Report Models provides a good, intuitive report design experience...

  • RE: The Standard Edition Wish List

    Reporting Services Web-Farm / scale-out.

    This is one key feature missing from Standard Edition that I find incomprehensible as to why it is not included at this level. Here's why:

    Scenario:

    - I...

  • RE: Logged Operations

    Umm - there are TWO correct answers listed for this question (as described in the explanation), but only ONE can be selected. i.e.:

    - Inserts into Table Variables are not logged

    -...

  • RE: Check Identity onatable

    I guess the 1st question is "Do you really need to know if IDENTITY_INSERT is enabled on a table, or do you want to find out which table in the...

Viewing 10 posts - 1 through 10 (of 10 total)