Forum Replies Created

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

  • RE: Magic 8 Ball

    A bit of fun.

    Question:

    Since I assume the computer your SQL Server is on has a network card, why not just order by newid()?

  • RE: Type conversions and Nulls

    Curse you Precedence!

    always the one that I forget about, ah well πŸ™‚

  • RE: IDENTITY INSERT

    harmiewiz (12/14/2012)


    Curious about this one, wouldn't the second SET IDENTITY_INSERT ON statement generate an error right there?

    Yes it does πŸ™‚

    and if it weren't for all those GO's in the code...

  • RE: STUFF - 2

    L' Eomot InversΓ© (12/11/2012)


    The general idea of null is that it means "it is not known what this value is"; if I replace some characters in a sting with an...

  • RE: STUFF - 2

    It occurs to me that we should not be confusing STUFF with arithmetic (string concat is a form of additive string arithmetic) with regards to the replaceWith argument.

    yes, anything +...

  • RE: Unprotected Queries

    To be fair to the ISP's out there, we aren't talking a few connections here, we're talking many tens or hundreds of thousands if not millions (for the bigger providers)...

  • RE: New features in SQL 2012, the contained database

    Sounds very interesting for a self contained database, I have many business systems where I would find this valuable for DR.

    Just wondering how this works if I need to join...

  • RE: The Consistency Debate

    I wouldn't use ATM's as an example as I think you will find that in this day and age, all ATM transactions are live (both debit and credit cards).

    You need...

  • RE: Jeff Moden elected Exceptional DBA of 2011

    I'm not amazed in the least...

    I will often cite Jeff's articles to our developers and also to people I know outside of work.

    He is one of those people whose name...

  • RE: Niagara Falls

    This article might be interesting: note the reply from microsoft at the bottom

    Replace of char(0) does not work in DB with Windows collation

    I know it isn't exactly the same issue,...

  • RE: Bad Eyes

    O' and sleep.

    Fatigue is also a major source of general eye strain.

    I have found this to be true for myself as when I have a run of late nights (for...

  • RE: Bad Eyes

    One concept that has floated around for many years (and I find it works fairly well) is for those with more than 1 monitor, ensure that they are at different...

  • RE: We Need a DBA Boot Camp

    1) Nope, although growing up on a dairy farm sometimes felt like one πŸ˜›

    2) Yes.

    I think there are enough core concepts that you could make one:

    The ANSI Standard...

  • RE: Cost of the Cloud

    Again, it depends on how you define it.

    Exactly right, and that is the problem. Sales people say "Cloud" as some kind of cureall.

    "I need to make coffee. ...

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