Forum Replies Created

Viewing 15 posts - 496 through 510 (of 645 total)

  • RE: Time Zones

    Steve Jones (7/17/2012)


    CONVERT still has crazy numeric codes for conversion. Wouldn’t it make more sense to do this:

    DECLARE @dt datetime

    SELECT @dt = GETDATE()

    SELECT CONVERT( datetime,

  • RE: Managing Risk

    Dissension / opposition within groups is necessary to ensure a better decision or plan. I remember learning in college about the role of the "central negative" in a group and...

  • RE: Setup SQL Server on Amazon RDS

    This is a very awesome option. And it seems that Amazon is making it really easy to have a no-cost development DB server via this offer:

    http://aws.amazon.com/rds/sqlserver/free/

    Of course, that is for...

  • RE: Create Your Own Intense Interview

    GSquared (5/30/2012)


    Doctor Who 2 (5/29/2012)


    So, how does one go about finding a better experience at job hunting, with solid companies that have more to offer than a pay check?

    In terms...

  • RE: Create Your Own Intense Interview

    I definitely agree with the "mutual meeting" idea. Employment is a relationship, much like family, friendship, marriage, business/customer, etc. It is a two-way street having responsibilities, expectations, rights, give and...

  • RE: Streaming Data Into SQL Server 2008 From an Application

    mark hutchinson (5/17/2012)


    1. generally, you will find that 500-1000 rows/transaction will give the optimal performance. Beyond that, you won't see much performance improvement.

    Hi Mark and thanks for the reply.

    I...

  • RE: RegEx for DBAs

    Cadavre (5/10/2012)


    What I like about this site, what keeps me coming back, is that I can have a discussion with complete strangers that often have far more experience than me...

  • RE: RegEx for DBAs

    Cadavre (5/9/2012)


    Thanks for the reply, although I think I need more convincing. I don't see it as being a "win" for RegEx due to it being more complicated to...

  • RE: RegEx for DBAs

    To Cadavre:

    I do not dispute your results, but I will dispute your test itself on the grounds that it is not relevant to a situation where someone should or would...

  • RE: RegEx for DBAs

    williams.frd (5/8/2012)


    Am I out of line in thinking this is something that should be handled in a high-level object-oriented language?

    Hello. I am going to say "yes", but I am not...

  • RE: RegEx for DBAs

    Jeffrey Bijkerk (5/8/2012)


    If you use regex combined with a where clause it can not use the index anymore. I think this is very important.

    Hi Jeffrey. It is important to a...

  • RE: RegEx for DBAs

    To david.rowland and Jeff Moden:

    With regards to performance, whether compared to LIKE / PATINDEX or even a custom SQLCLR function, please keep in mind that the main "win" here for...

  • RE: Waiting for SP1

    chrisn-585491 (3/18/2012)


    Given the many CTPs and RC0, it doesn't make much sense anymore to wait. Yes, there will be bugs but that doesn't set it apart from any other software....

  • RE: Waiting for SP1

    Years ago it did make sense to wait for SP1, but those days have been over for at least 7 years now.

    I work at a company that was on SQL...

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    Perry Whittle (2/10/2012)


    The problem with a vendor supplied CLR is you don't have access to the source, it could be doing literally anything, you place an awful lot of trust...

Viewing 15 posts - 496 through 510 (of 645 total)