Forum Replies Created

Viewing 15 posts - 10,606 through 10,620 (of 59,065 total)

  • RE: SELECT TOP 1 on Primary Key?

    AdrianLParker+sqlservercentral.com - Friday, November 9, 2018 10:12 AM

    The MSDN says of OPTIONA (FAST X):

    Specifies that the query is optimized for fast retrieval...

  • RE: Are the posted questions getting worse?

    Michael L John - Sunday, November 11, 2018 12:37 PM

    About 5 miles. We finished just under 22 hours after we started. ...

  • RE: Julian Date

    p.s.  And sorry about the mess the forum software made with the code and the results.  I posted it the same way I did in similar posts above but it...

  • RE: Julian Date

    Jeff Moden - Saturday, November 10, 2018 9:41 PM

    frederico_fonseca - Saturday, November 10, 2018 2:06 PM

  • RE: Are the posted questions getting worse?

    Michael L John - Saturday, November 10, 2018 2:43 PM

    We started moving our data center last night at 3 am. 12 racks...

  • RE: Julian Date

    irehman - Saturday, November 10, 2018 1:32 PM

    Jeff Moden - Saturday, November 10, 2018 1:24 PM

    November 10, 2018 at 9:44 pm

    #2013115

  • RE: Julian Date

    frederico_fonseca - Saturday, November 10, 2018 2:06 PM

    similar results for me 

    As the results I had given before only related to the date...

  • RE: Julian Date

    jcelko212 32090 - Saturday, November 10, 2018 2:54 PM

    irehman - Saturday, November 10, 2018 8:25 AM

    November 10, 2018 at 9:37 pm

    #2013113

  • RE: Julian Date

    Ok... so nothing has changed much in the last couple of decades for this type of conversion.  A trip through character based code to do such conversions is still a...

  • RE: Julian Date

    irehman - Saturday, November 10, 2018 12:49 PM

    Jeff Moden - Saturday, November 10, 2018 9:23 AM

    November 10, 2018 at 1:24 pm

    #2013101

  • RE: Julian Date

    Thanks, Frederico.  Time for some play.

  • RE: Julian Date

    Can we see the code you used to generate the test data?  My concern is that it may have a cardinality of "1" and that can lead to some pretty...

  • RE: The Cost of Switching

    Back to the subject of "switching", I've found that there are several hidden costs to making such switches.  The single greatest loss (IMHO) is "Lost Learning" and the "art" of...

  • RE: Julian Date

    frederico_fonseca - Saturday, November 10, 2018 9:31 AM

    one other option (and there are more)

    declare @tbl table
      ( juldate decimal(18, 0)
     ...

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, October 31, 2018 2:52 PM

    Grant Fritchey - Wednesday, October 31, 2018 2:36 PM

Viewing 15 posts - 10,606 through 10,620 (of 59,065 total)