Forum Replies Created

Viewing 15 posts - 331 through 345 (of 380 total)

  • RE: LEN and CONVERT

    meh... 😛

  • RE: LEN and CONVERT

    Hugo Kornelis (8/1/2013)SELECT LEN(@var) implicitly converts @var to string, because that's the only data type supported for LEN. This conversion is independent of the clients' Windows locale setting, since it's...

  • RE: LEN and CONVERT

    thierry.vandurme (7/30/2013)


    Hi Philip

    that indeed explains it. Thx a lot! I was almost losing my mind over this 🙂

    Chrz

    Thierry

    Thierry,

    That explanation is not correct for TSQL. Style does not affect the...

  • RE: LEN and CONVERT

    PHYData DBA (7/30/2013)


    My two cents on why answer one is 12 and not 14 is another question.

    Is money a numeric type?

    http://msdn.microsoft.com/en-us/library/ms187752.aspx

    If it is then isn't the length the number of...

  • RE: LEN and CONVERT

    My two cents on why answer one is 12 and not 14 is another question.

    Is money a numeric type?

    http://msdn.microsoft.com/en-us/library/ms187752.aspx

    If it is then isn't the length the number of bytes used...

  • RE: LEN and CONVERT

    Nice and easy question.

  • RE: Flying high on the Big Data hot-air

    RobertYoung (7/30/2013)


    PHYData DBA (7/30/2013)


    Phil Factor (7/30/2013)


    @wim.bekkens

    Thanks for that.

    For a simple example, take a look at this series that is now coming out on Simple-talk. It walks you through an example...

  • RE: Flying high on the Big Data hot-air

    Phil Factor (7/30/2013)


    @wim.bekkens

    Thanks for that.

    For a simple example, take a look at this series that is now coming out on Simple-talk. It walks you through an example application that involves...

  • RE: Flying high on the Big Data hot-air

    I am not a huge fan of random big data projects for useless over caffeinated marketing ideals.

    I do like projects like a certain Health Industry project started in...

  • RE: TDE Setup

    Hugo Kornelis (7/26/2013)


    I got it right, because I know that you have to create a certificate in master to protect the master key - but the question is a bit...

  • RE: TDE Setup

    Nice question that should have been easy.

    Should have read it slower I guess.

    You create and store the Certificates in master.

    You have to be connected to the CRM to USE the...

  • RE: Adding New Node to exisiting SQL Server 2008 R2 Cluster

    At this point we would need some you to post a detailed description of your three physical servers, the shared and local storage they will be using, and how they...

  • RE: Adding New Node to exisiting SQL Server 2008 R2 Cluster

    It should give you the needed information on how to add the additional node to your set-up. As far as making a Active/Active/Passive SQL Cluster IDK... I have not...

  • RE: Adding New Node to exisiting SQL Server 2008 R2 Cluster

    I am not sure this will work as you would like, but anytime you are going to add a node to an existing cluster the first step is to install...

  • RE: Monitoring script

    Steve Jones - SSC Editor (12/21/2009)


    If you don't know what monitoring is, then we likely won't be able to provide much help until you start to spend some time learning....

Viewing 15 posts - 331 through 345 (of 380 total)