Forum Replies Created

Viewing 15 posts - 271 through 285 (of 2,494 total)

  • RE: Looking for way to dynamically replace street suffix with abbreviation based on tables

    I know you are trying to replace full values with abbreviations and probably have good reasons to do this. However, if this was my system I would be looking...

  • RE: sql backup

    Going back to Krasavita's original question: how long will it take to back up 600GB?

    As seen in the replies, the answer depends on many things. To a large extent,...

  • RE: backward compatibility

    The SQL 2005 backward compatibility pack can be installed with any version of SQL Server above SQL 2005. It is not needed with anyt version, unless you want to...

  • RE: Fact table with hundred of columns - Any alternative?

    Definitely you need to know which attributes relate to Facts and which relate to Dimensions.

    As a starting point, if the attribute is numeric and the aggregated value of...

  • RE: Deleted

    SSAS will probably be useful for a few years to come, but R Services will become the main analysis tool of the future. I would not be surprised if...

  • RE: Unable to install SP1 or SP1 CU5

    Please do not uninstall any version of .Net on any box you hope to continue to use. There are a vast number of inter-dependencies that may get broken. ...

  • RE: peer to peer replication PK violation issue.

    When I was Architect at Totaljobs Group we implemented P2P replication.

    One of our design criteria was to reduce operational risk. We already had our applications written to...

  • RE: A Beautiful Google Mind

    Most people who read this will have charities nearby that could really use some part-time technical support. It is worth finding one that works in a field you like...

  • RE: SQL Server Agent stopping automatically in SQL Server 2016 Cluster

    When you uninstalled your ins1, ins2, did you clean out the redundant virtual names from AD?

    If AD still has an entry that relates to the original ins1 Agent...

  • RE: Alternate Way to Write query: ISNULL function causing issues

    I think both the original code and all the alternatives suggested would prevent the use of an index to resolve the clause using pdenddate. This is due to the...

  • RE: File Stream

    You don't want your antivirus to read the filestream container

    Agreed!! If you are concerned about storing a virus, then most A/V products have an API that allows a .Net application...

  • RE: Service account setup for SQL Services

    Are you able to post the consultant's reasons for wanting to make this change. It would be interesting to see what reasons are given, and what the risk/benefit analysis...

  • RE: Always On, as a DR site.

    It gets tested twice a year

    As an outsider to your organisation, it is really hard to see that a DR that only gets tested twice a year is going to...

  • RE: More Overloads

    I Love Standards…There Are So Many Of Them

    Life would be so much simpler if everything had a clear and unambiguous name, but I fear it will never happen. Even...

  • RE: How to find postcodes with two spaces in the middle?

    export it to Excel and do a simple find and replace

    What is wrong with

    UPDATE yourtable

    SET Postcode = Replace(Postcode, ' ', ' ')

    FROM yourtable

    WHERE postcode LIKE N'___...

Viewing 15 posts - 271 through 285 (of 2,494 total)