Forum Replies Created

Viewing 15 posts - 18,901 through 18,915 (of 26,484 total)

  • RE: DBAs Pen

    I find much value in getting published. Having authored 4 articles (2 here on SSC and 2 on SSWUG.ORG), I find it a way to give back to a...

  • RE: Not Installing BOL

    george sibbald (9/9/2009)


    It comes under the heading of not installing sample databases on a production server for me.

    Now this I fully agree with, no sample databases on the production servers.

  • RE: Ansi SQL show different results

    Lynn Pettis (9/9/2009)


    lleemon13 (9/9/2009)


    I have two tables one which may or may not have data related to the primary table contest. When I do an old school non...

  • RE: Ansi SQL show different results

    lleemon13 (9/9/2009)


    I have two tables one which may or may not have data related to the primary table contest. When I do an old school non ansi tsql...

  • RE: Cursor very slow...Pls help

    Lynn Pettis (9/4/2009)


    gugan_ta (9/4/2009)


    Hi,

    Thanks a lot...query works fine. Its saves huge processing time and an alternate to cursor.

    Nice to know, but as you were given several alternatives, what is your...

  • RE: Are the posted questions getting worse?

    GilaMonster (9/9/2009)


    GilaMonster (9/8/2009)


    Only in South Africa - http://pigeonrace2009.co.za/pigeon-race-2009

    My money's on the pigeon.

    The pigeon won. By a significant amount. The download was 4% complete by the time the pigeon arrived

    That's sad,...

  • RE: Not Installing BOL

    I install BOL on production servers. If things are bad enough that I have to be physically on the server to resolve system problems I want BOL there and...

  • RE: Am I the only DBA

    Laptop - Yes

    Desktop - Yes

    SQL Books - Yes (Lots of them)

    University - Yes (BS Computer Science and Business Adminstration;MA Computer Information Resource...

  • RE: Indexes

    Not thinking about the extremely small stat set provided, I answered Query 1. If you look at the where clauses for all four queries you find that the proposed...

  • RE: brocken

    First, I'm glad to see that you finally took the time to post your question on SSC instead of attempting to get help via a PM. As you can...

  • RE: Cursor very slow...Pls help

    gugan_ta (9/4/2009)


    Hi,

    Thanks a lot...query works fine. Its saves huge processing time and an alternate to cursor.

    Nice to know, but as you were given several alternatives, what is your final solution?

  • RE: Last Day of any Month

    Here is some code for you all to play with. Use at your own risk. I tested this with my Tally table.

    create function dbo.tvf_EOM (

    ...

  • RE: Squeezing the DBA

    Years ago while attending Regis University for my BS degree, one of the courses I had to take was an Ethics class. Looking at things today, I think that...

  • RE: If you weren't a DBA what would you be doing?

    Developer/Programmer of some sort. Maybe be in IT Management.

  • RE: insert select with a condition on the table being added too

    Show us what you are asking with a concrete example. Just from your description, I'm not sure what you are asking.

Viewing 15 posts - 18,901 through 18,915 (of 26,484 total)