Forum Replies Created

Viewing 15 posts - 4,741 through 4,755 (of 9,399 total)

  • RE: Job Schedules

    Dain Bramage (11/10/2015)

    Ed Wagner (11/10/2015)

    Dain Bramage (11/10/2015)

    If I would have known that the date stored in dbo.sysjobschedules is an integer that is calculated to be the year, month, and day,...

    November 10, 2015 at 10:50 am

    #1838917

  • RE: Job Schedules

    Sean Lange (11/10/2015)

    Iwas Bornready (11/10/2015)

    I had to check the table structure of sysjobschedules. I would never have guessed that a date column was put into a purposely constructed int.

    For some...

    November 10, 2015 at 7:42 am

    #1838848

  • RE: Do You Have Scary Code?

    I'm in a similar situation myself. I have a large stored procedure that calls other procedures (sometimes multiple times) and the logic is a bit dizzying. The sheer...

    November 10, 2015 at 6:39 am

    #1838825

  • RE: Job Schedules

    Dain Bramage (11/10/2015)

    If I would have known that the date stored in dbo.sysjobschedules is an integer that is calculated to be the year, month, and day, as a large value...

    November 10, 2015 at 6:20 am

    #1838813

  • RE: Index Scan: Ordered or not?

    Learned something new from this one, so thank you.

    November 10, 2015 at 6:16 am

    #1838812

  • RE: Today's Random Word!

    anthony.green (11/10/2015)

    Ed Wagner (11/9/2015)

    #MyHead

    Bobblehead

    Dashboard

    November 10, 2015 at 6:15 am

    #1838811

  • RE: Today's Random Word!

    whereisSQL? (11/9/2015)

    Ed Wagner (11/9/2015)

    djj (11/9/2015)

    crookj (11/9/2015)

    DonlSimpson (11/9/2015)

    djj (11/9/2015)

    anthony.green (11/9/2015)

    Ed Wagner (11/6/2015)

    Pain (back to obama care)

    Killer

    Geraldine

    Flip

    Wilson (Here comes the Judge...)

    Sock-it to me

    Hit me

    *Slap* O_o

    #MyHead

    November 9, 2015 at 1:06 pm

    #1838673

  • RE: Today's Random Word!

    djj (11/9/2015)

    crookj (11/9/2015)

    DonlSimpson (11/9/2015)

    djj (11/9/2015)

    anthony.green (11/9/2015)

    Ed Wagner (11/6/2015)

    Pain (back to obama care)

    Killer

    Geraldine

    Flip

    Wilson (Here comes the Judge...)

    Sock-it to me

    Hit me

    November 9, 2015 at 11:29 am

    #1838641

  • RE: Are the posted questions getting worse?

    Luis Cazares (11/9/2015)

    Does anyone here knows the site howtosql.com? I was searching for an old thread on Google and found that "I'm an author" for them. It was actually linking...

    November 9, 2015 at 10:21 am

    #1838614

  • RE: log file growth

    johnwalker10 (11/8/2015)

    The most common reason for uncontrolled log growth is being in Full Recovery mode without having any log backups.

    That's my guess as well.

    November 9, 2015 at 6:01 am

    #1838525

  • RE: Can not shink Temp DB Files

    If you restarted the SQL Server service then that resets the tempdb to its initial size. If it didn't change, have you checked the initial size of tempdb? ...

    November 7, 2015 at 6:48 am

    #1838409

  • RE: A big thank you

    Grant, that was a nice un-editorial editorial. I especially like your point about "best" practices. I sometimes think that a best practice became a best practice only because...

    November 7, 2015 at 6:47 am

    #1838408

  • RE: log file growth

    Eirikur Eiriksson (11/7/2015)

    giri10488 (11/7/2015)

    can anyone pls help me

    A log file size of a production database has been increase from 4gb to 150 gb initial size.Now i want to find...

    November 7, 2015 at 6:36 am

    #1838407

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/7/2015)

    Lynn Pettis (11/6/2015)

    Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL...

    November 7, 2015 at 6:30 am

    #1838406

  • RE: Are the posted questions getting worse?

    Sean Lange (11/6/2015)

    Luis Cazares (11/6/2015)

    Sean Lange (11/6/2015)

    Ed Wagner (11/6/2015)

    Brandie Tarvin (11/6/2015)

    Greg Edwards-268690 (11/6/2015)

    Eirikur Eiriksson (11/6/2015)

    On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?

    Three options...

    November 6, 2015 at 12:25 pm

    #1838328

Viewing 15 posts - 4,741 through 4,755 (of 9,399 total)