Forum Replies Created

Viewing 15 posts - 46 through 60 (of 111 total)

  • RE: Clear Database Engine Server Name drop down

    I'm using the SQL2008 SSMS and have the same problem. I've found these keys and sure enough they list all of the valid servers I've connected to, but where I've...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: SQLServerCentral.com - The Missing Manual

    And having made the first post - the forums are way better.

    Just keep that "Supreme Being" title under my avatar and you've won brownie points forever!


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: SQLServerCentral.com - The Missing Manual

    Woo hoo!

    I've always wanted to be the first to post a reply to a topic :w00t:

    Just a quick comment to say that at first impressions, I'm very impressed!  Gone are...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: A Matter of Trust

    As a DBA myself, and as part of a company than has very sensitive data, I do believe that a high level of trust has to be assigned to a...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: A Special Announcement from Andy, Brian, and Steve

    Excellent news guys, and good luck for the future.

    This site has saved my neck on a couple of occassions, always insightful, always informative, and sometimes great for a bloody good...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Help me please before I shoot the server!!!

    The problem is with SQL "parameter sniffing"

    Not often this occurs, but when it does, the performance of a stored procedure can degrade quite dramatically.

    You can usually tell when this occurs...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Question of the Day for 04 Jul 2005

    I think this is something of an unfair question!

    Indicating that fact that SQL Server is better than mySQL on the basis of the presence of this (somewhat superb, informative, amusing, feature...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Problem reinstalling reporting services

    Just for reference to anyone reading this.  We cracked it, but not without some interesting repercussions.

    It appeared that the link between the NT groups and SRS's interpretation of them had...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Question of the Day for 01 Jun 2005

    This wasn't a bad one at all.

    Every disaster recovery plan should have off-site storage.  What happens if there is a fire in the datacentre, a (heaven forbid - fire the...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Question of the Day for 25 May 2005

    Oh I dunno, I could imagine Microsoft turning off the support at the end of 2005 and releasing the product in 2006!

    Incidentally, when are the banners on this post page...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Is there a SCHEMA view to return routine privileges

    I had a horrible feeling this was the case.

    Masny thanks.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Question of the Day for 27 Jul 2004

    Jamie, I have to admit, after the revelations from this QoD, I think it would make a very interesting article to compare Oracle, ANSI, SQL and the extensions Microsoft have...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Question of the Day for 27 Jul 2004

    Michael, the alias is referenced, but not until absolutely necessary.

    In SQL Statement A the Order By alias is used. The column is not found in the results, so SQL...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Question of the Day for 27 Jul 2004

    OOPS!

    You are in fact correct, they have got the answer the wrong way...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

  • RE: Question of the Day for 27 Jul 2004

    Nope, the question is correct

    With query 1

    SQL extracts a dataset using the Select statement

    This consists of

    ORDER_NOITEM_NOUNIQUEID

    RON11

    RON21

    RON31

    RON41

    BILL12

    BILL22

    BILL32

    BILL42

    FRED13

    FRED23

    FRED33

    FRED43

    SQL is the asked to order the resultset by myIT.Unique_ID desc

    SQL will first ignore the...


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

Viewing 15 posts - 46 through 60 (of 111 total)