1. Home
  2. Categories
  3. Side Bar WTF
  4. Working hard to SELECT @@VERSION

Working hard to SELECT @@VERSION

  • Zemm

    I was going through my old "WTF" folder and found a screenshot I'm pretty sure I meant to post but never got around to it.

    How does it take 57 seconds to run this query!?

    0
  • dhromed

     hiccup.

    Shirley it doesn't always do this?

    0
  • Zemm

    @dhromed said:

     hiccup.

    Pretty strange hiccup to take over 5700 times longer than I'd expect!

    @dhromed said:

    Shirley it doesn't always do this?

    Actually, WS08DEV runs on VMware Server. IMSMR the host had 12GB RAM back then for two 4GB and one 1GB guests: not enough. Host has since been upgraded to 24GB RAM (one 4GB guest upped to 8GB) and I just tried it and it only took 1 second.

    0
  • ekolis

    If you'll notice, there is quite a bit more than the SQL Server version - it appears to be querying your OS version as well. Granted, I don't think even that should take 57 seconds, but it could reasonably be expected not to be instantaneous!

    0
  • blakeyrat

    It saw your hat and was laughing so hard it took 59 seconds to calm down enough to get around to responding to your request.

    0
  • dhromed

    @Zemm said:

    @dhromed said:
     hiccup.

    Pretty strange hiccup to take over 5700 times longer than I'd expect!

    @dhromed said:

    Shirley it doesn't always do this?

    Actually, WS08DEV runs on VMware Server. IMSMR the host had 12GB RAM back then for two 4GB and one 1GB guests: not enough. Host has since been upgraded to 24GB RAM (one 4GB guest upped to 8GB) and I just tried it and it only took 1 second.

     

    ... It's a yes/no question...

    - HEY JOE, WHAT TIME IS IT?

    - ACTUALLY, JAKE, IT IS IN FACT AMAZING HOW CLOCKS WORK. HERE, THERE'S ONE ON THE CHURCH, AND ON MY PHONE, AND ON MY WRIST.

     

    I'm going to assume that you mean "Yes, dhromed, it always does this. I have no explanation for it."

    I think the hat consumed your brain.

    0
  • C

    Just tested against several different instances, and each time less than 1 second (shows up as 00:00:00)...

    0
  • dubbreak

    @C-Octothorpe said:

    Just tested against several different instances, and each time less than 1 second (shows up as 00:00:00)...

    Same here. 00:00:00

    0
  • morbiuswilters

    Network hiccup.

    0
  • S

    @dhromed said:

    - HEY JOE, WHAT TIME IS IT?

    - ACTUALLY, JAKE, IT IS IN FACT AMAZING HOW CLOCKS WORK. HERE, THERE'S ONE ON THE CHURCH, AND ON MY PHONE, AND ON MY WRIST.

    This amuses me, because my supervisor's name is Jake and our CEO's name is Joe. True story.

    0
  • D

    1. Execute WAITFOR DELAY '00:01:00'; SELECT @@VERSION
    2. Delete WAITFOR command
    3. Screenshot
      0
    4. morbiuswilters

      @db2 said:

      1. Execute WAITFOR DELAY '00:01:00'; SELECT @@VERSION
      2. Delete WAITFOR command
      3. Screenshot

        Surely Zemm isn't that starved for atten--

        Surely Zemm doesn't know how to edit the contents of a text box.

        0
      4. D

        @db2 said:

        1. Execute WAITFOR DELAY '00:01:00'; SELECT @@VERSION
        2. Delete WAITFOR command
        3. Screenshot
          That would have made a delay of 00:01:00 execute in 00:00:57. Would still be a WTF in my eyes ;-)
          0
        4. Zemm

          @morbiuswilters said:

          Surely Zemm isn't that starved for atten--.

          Look how slow my SQL server is! I can post to TDWTF every time I make a simple query, and compose novels if I try a JOIN!

          @morbiuswilters said:

          Surely Zemm doesn't know how to edit the contents of a text box.

          Not at all. What's a text box?

          0
        Log in to reply