Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 3,658 total)

  • RE: NOLOCK processing vs normal; Does NOLOCK do less processing?

    It's probably worth mentioning that if you are using NOLOCK then you should be making the switch to using READUNCOMMITTED as this is the replacement for NOLOCK.

    The problem with NOLOCK...

  • RE: A Break from Data

    Battleship was appalling but hugely entertaining.

    Alexander Skarsgard plays a guy called Stone Hopper. I kept thinking of his brother as "Cole" or "Grass".

    The only movies I've bought on DVD...

  • RE: RegEx for DBAs

    You are half right Jeff,

    We'll leave out the vagueness of the term "Big Data" which is more marketing than useful. I think Buck Woody has the closest to a...

  • RE: Stop Asking and Start Making Decisions Today

    I particularly enjoyed the irony of "How to Raise Your Game by Doing Nothing" linking to a 404 page:-)

  • RE: RegEx for DBAs

    Jeff Moden (5/13/2012)


    I might go so far as to say that if youre trying to find items like the example you gave, then the data probably shouldn't be allowed...

  • RE: RegEx for DBAs

    Jeff Moden (5/12/2012)


    SPAM reported.

    Time for a spot of RegEx pattern matching:hehe:

  • RE: RegEx for DBAs

    Guys, the reason I wrote the article was not to say RegEx is king or you must use it. I've got away with not using it for a very...

  • RE: RegEx for DBAs

    Cadavre (5/8/2012)


    Any disputes about my test results? Because so far I'm thinking that I don't want RegEx in my database 😛

    Just as the advice is not to use CLR functions...

  • RE: Responsibility for Security

    "Most developers are reluctant to take the responsibility in security and assume that this is the job of web administrators and network engineers."

    I think it is a case of the...

  • RE: The Best Way to Learn

    Training videos in e-books is a great idea!

    I've always loved books and read voraciously. I never thought I'd take to a Kindle given the tactile pleasure of browsing, buying,...

  • RE: The Best Way to Learn

    I've got a number of e-books on my Kindle and for me text books don't work well on that.

    If they are explicit Kindle books then you can at least navigate...

  • RE: When Will You Upgrade to SQL Server 2012?

    In the DW world the new column stores present a compelling case but if you are not in the DW world what problems does SQL2012 solve for you? Emphasis...

  • RE: Big Data

    What I've found so far is that Big Data is a nice vague term so loved by IT vendors rather like "Cloud".

    There is Big Data as in vast amount of...

  • RE: Linked server to MySQL Server.

    I could be wrong but I thought that InnoDB was the engine closest to the model used by SQL Server and therefore THE engine that is transaction safe.

    I didn't think...

  • RE: Linked server to MySQL Server.

    It's worth mentioning that some queries require additional casting in order to work across the link otherwise you get hexadecimal gobbledegook.

    SELECT

    CAST(NAME AS VARCHAR(64)) AS TableName,

    CAST(COALESCE(Engine,'') AS VARCHAR(64)) AS Engine,

    COALESCE(ROWS,0)...

Viewing 15 posts - 1,816 through 1,830 (of 3,658 total)