Forum Replies Created

Viewing 15 posts - 6,901 through 6,915 (of 9,399 total)

  • RE: Approach to archiving tables with foreign key constraints

    Jeff Moden (11/30/2014)

    p.s. I strongly recommend that you take a full backup of your test environment before you do any delete tests. If the delete tests don't work...

    November 30, 2014 at 6:31 pm

    #1761583

  • RE: Azure

    An easy one, even though I haven't used Azure. I don't like them anyway and don't use them, so it wouldn't hurt to have them taken away.

    November 30, 2014 at 5:48 pm

    #1761581

  • RE: Thanksgiving 2014

    Steve Jones - SSC Editor (11/29/2014)

    kaspencer (11/27/2014)

    A question for Steve: what is the ratio of US-based registrants to non-US-based registrants for SQL Server Central?

    70+% US.

    Thanks for the interesting statistic. ...

    November 30, 2014 at 5:46 pm

    #1761580

  • RE: Please vote for the "built in Tally Table" function.

    I think you're going to get some votes on this one, Jeff. Hey, it's coming up on its 8-year anniversary in February and it has the support of more...

    November 26, 2014 at 8:00 am

    #1761099

  • RE: Are the posted questions getting worse?

    jcrawf02 (11/26/2014)

    Stuart Davies (11/26/2014)

    Eirikur Eiriksson (11/26/2014)

    WayneS (11/26/2014)

    ..what the vote count was..

    If I remember correctly it was 135 after my vote

    😎

    Mine made it 143

    it's showing 147 right now, and when I...

    November 26, 2014 at 7:24 am

    #1761084

  • RE: IF EXISTS vs @@ROWCOUNT

    Yeah, the question was definitely poor.

    November 26, 2014 at 5:50 am

    #1761065

  • RE: Please vote for the "built in Tally Table" function.

    My vote made the count 147.

    November 26, 2014 at 5:44 am

    #1761062

  • RE: In The Beginning

    kherald69 (11/25/2014)

    I can see that it works but what is the meaning of the time int value.

    Here is an example of why I say it is stored as a float.

    with...

    November 26, 2014 at 5:26 am

    #1761058

  • RE: In The Beginning

    kherald69 (11/25/2014)

    Ed Wagner (11/25/2014)

    PHYData DBA (11/25/2014)

    Brian.Klinect (11/25/2014)

    That's exactly what I did. I had no idea I could use a negative number for a datetime!

    Since DateTime is stored as an...

    November 25, 2014 at 2:00 pm

    #1760911

  • RE: In The Beginning

    PHYData DBA (11/25/2014)

    Brian.Klinect (11/25/2014)

    That's exactly what I did. I had no idea I could use a negative number for a datetime!

    Since DateTime is stored as an Integer, it only...

    November 25, 2014 at 8:32 am

    #1760839

  • RE: Today's Random Word!

    SQLRNNR (11/25/2014)

    Ed Wagner (11/25/2014)

    crookj (11/25/2014)

    SQLRNNR (11/25/2014)

    Ed Wagner (11/25/2014)

    crookj (11/25/2014)

    Ed Wagner (11/25/2014)

    BWFC (11/25/2014)

    Stuart Davies (11/25/2014)

    SQLRNNR (11/24/2014)

    Stuart Davies (11/24/2014)

    SQLRNNR (11/24/2014)

    accelerant

    arson

    fun

    house

    Arrest

    Detain

    Impede

    Block

    Building

    Rollercoaster

    Sickness :sick:

    Bring it

    Adrenaline

    November 25, 2014 at 8:30 am

    #1760837

  • RE: group by query

    If your data is in a real table, why not put your grouping in a real table?

    November 25, 2014 at 8:04 am

    #1760824

  • RE: sql server 2008

    I've also received the error when I try to copy very large query results. The query runs, but about 1 second after I hit Ctrl-C, SSMS throws the error....

    November 25, 2014 at 7:29 am

    #1760806

  • RE: Today's Random Word!

    crookj (11/25/2014)

    SQLRNNR (11/25/2014)

    Ed Wagner (11/25/2014)

    crookj (11/25/2014)

    Ed Wagner (11/25/2014)

    BWFC (11/25/2014)

    Stuart Davies (11/25/2014)

    SQLRNNR (11/24/2014)

    Stuart Davies (11/24/2014)

    SQLRNNR (11/24/2014)

    accelerant

    arson

    fun

    house

    Arrest

    Detain

    Impede

    Block

    Building

    Rollercoaster

    Sickness :sick:

    November 25, 2014 at 7:26 am

    #1760804

  • RE: In The Beginning

    paul.knibbs (11/25/2014)

    Mike Hays (11/25/2014)

    I could swore that it was sometime in 1975?

    So you've never stored a date prior to 1975 in a DATETIME? :blink:

    Or what that your personal beginning of...

    November 25, 2014 at 7:25 am

    #1760803

Viewing 15 posts - 6,901 through 6,915 (of 9,399 total)