Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 26,490 total)

  • RE: TempDB Keeps Filling Up After Log Truncation

    chris_barnhart (7/12/2016)


    Lynn Pettis (7/12/2016)


    chris_barnhart (7/12/2016)


    Thanks for the advice...we have a contractor on the way, but not until Monday.

    I've been monitoring the consumption using the first set of SQL, the second...

  • RE: TempDB Keeps Filling Up After Log Truncation

    chris_barnhart (7/12/2016)


    Thanks for the advice...we have a contractor on the way, but not until Monday.

    I've been monitoring the consumption using the first set of SQL, the second one shows me...

  • RE: TempDB Keeps Filling Up After Log Truncation

    chris_barnhart (7/12/2016)


    I apologize...i knew I would leave something important out. Error is below:

    (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]...

  • RE: TempDB Keeps Filling Up After Log Truncation

    It would probably help if you also provided the full and complete error messages you are getting. Not much we can do based just on what you have posted...

  • RE: Are the posted questions getting worse?

    jasona.work (7/12/2016)


    Maybe I should get off my butt and start a blog for commenting on things like this: SIEUFERD

    Yet another wonder tool (so far only an academic project) to...

  • RE: Regarding SQL server Licensing (SQL 2012/2014)

    SQLisAwE5OmE (7/12/2016)


    Can someone provide some insights into how the licensing works for SQL 2012 or 2014 for non-profit organizations?

    Does Microsoft provide discounts for non-profit organizations?

    We currently have SQL 2008R2 and...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/12/2016)


    It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The...

  • RE: Are the posted questions getting worse?

    Sean Lange (7/12/2016)


    Jeff Moden (7/12/2016)


    Brandie Tarvin (7/12/2016)


    GAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHH!

    Last week before upgrade and the stupid IP addresses for my AGs and one of my sql instances aren't responding to pings.

    Who has the...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/12/2016)


    So, out Fri and Sat to help my kid work on his Eagle Scout project (finally). We went from this Fri:

    to this by Sat afternoon:

    Proud...

  • RE: problem converting date on procedure.

    Sergiy (7/10/2016)


    Lynn Pettis (7/8/2016)


    Sergiy (7/7/2016)


    Lynn Pettis (7/7/2016)


    But I think this argument has gone on long enough, and it is time to stop.

    Long enough - by which standard?

    :hehe:

    By the standanrd that...

  • RE: problem converting date on procedure.

    Sergiy (7/7/2016)


    Lynn Pettis (7/7/2016)


    But I think this argument has gone on long enough, and it is time to stop.

    Long enough - by which standard?

    :hehe:

    By the standanrd that you keep bringing...

  • RE: Price Variation Query for the same Stock Numbers

    Just want to verify that you are using SQL Server 2008. This will determine how a solution is developed. There are features in 2012 and newer that make...

  • RE: problem converting date on procedure.

    Sergiy (7/7/2016)


    drew.allen (7/7/2016)


    If the two are otherwise indistinguishable,

    They are not.

    I provided an example where CAST is not doing its job properly. and can add more.

    which is true in the...

  • RE: problem converting date on procedure.

    Sergiy (7/7/2016)


    drew.allen (7/7/2016)


    Sergiy (7/6/2016)


    It's actually another way around - it's you who did not provide any rationale for using CAST rather than CONVERT in any cases.

    Actually, I did provide my...

  • RE: problem converting date on procedure.

    Jeff Moden (7/7/2016)


    Just my humble opinion... ignore it if you want but it's worked wonders for me...

    The ANSI and ISO Standards quickly limit what you can actually do. For...

Viewing 15 posts - 3,571 through 3,585 (of 26,490 total)