Forum Replies Created

Viewing 15 posts - 17,281 through 17,295 (of 39,834 total)

  • RE: Date Conversion

    What do you mean by date conversions? NULL doesn't convert to anything but NULL.

    NULL might be your best bet. You can always do MINDATE() ... WHERE mydate > '1/2/1900'

  • RE: What's Happening Here?

    grahamc (12/14/2010)


    In this case it might not be such a big deal, but surely a counter like Page Life Expectancy is a better way of monitoring Memory pressure??

    This is typically...

  • RE: Infromation from tables

    Typically the "pull" is through a query. As far as how you'll get the data to people, you'll have to make some decisions.

    If you are just pulling this from...

  • RE: What's Happening Here?

    rabartels (12/14/2010)


    perhaps first look if your I/O is fine

    Benchmarking SQL Server IO with SQLIO

    http://www.mssqltips.com/tip.asp?tip=2127

    Good idea, though we're already in production. Hard to stop things and bang on the disks with...

  • RE: Talking baseball

    The Phillies certainly are the favorites on paper, but we don't play on paper. Anyone think the Giants were going to win before Oct last year?

    Phillies have had injuries in...

  • RE: Are the posted questions getting worse?

    Craig Farrell (12/14/2010)


    GilaMonster (12/14/2010)


    Brandie Tarvin (12/14/2010)


    (Where's my halo? Self-righteous doesn't work without my halo, darnit!)

    How long did it take you to forge your own halo, in between the lightning strikes,...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/14/2010)


    GilaMonster (12/14/2010)


    Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.

    It almost resulted in coffee over laptop.

    I can see why. @=) I'll...

  • RE: The Low End

    The "low end" refers to the barrier to entry. It's easy(ier) to pick up development skills on these products, as opposed to C/C++

  • RE: The Low End

    Ron Porter (12/14/2010)


    By accepting it and bringing it into the open, you have the chance to provide skill-appropriate guidance, reduce the duplication of effort, and identify prime candidates for more...

  • RE: Talking baseball

    Heard Tim Legler on Mike and Mike say that most of the time this doesn't work. 97 Marlins, '09 Yankees were able to buy a championship. Most other times it...

  • RE: Dev team wants to rely heavily on Views... performance problems?

    For the most part I agree with GSquared. The performance issues can grow as you layer and nest things. UDFs and Views, while abstracting and reusing code, often mask issues....

  • RE: Inserting duplicate key?? Why??

    What is the primary key on bookingactivity?

    You can find duplicates by using a GROUP BY on the pK and a having count(*) > 1. What you first need to do...

  • RE: Using "Use" in stored procedure

    You cannot do this. You would either need to create the tables with the proper database name as I've done with dynamic SQL, or run a pre-written script. If the...

  • RE: /3GB

    /3GB allows a 32 bit application in Windows to use up to 3GB of space (leaving 1GB for the OS). However SQL Server Standard (2000) has a limitation of 2GB.

  • RE: How Do You Work When You are Not at Work?

    For me, email is really the way I hear about things. I have a smartphone, iPad, and multiple machines. On one of those, I'll get a note. It could be...

Viewing 15 posts - 17,281 through 17,295 (of 39,834 total)