Forum Replies Created

Viewing 15 posts - 17,296 through 17,310 (of 26,484 total)

  • RE: DateDiff sql function

    shifty-922587 (1/21/2010)


    I was playing around with some code for showing the date and added the value -10 to this query:

    DATEADD(mm, DATEDIFF(mm,-10,emp.hiredt), 0)

    end) as eligdt

    I was told that this slot...

  • RE: Database Size

    david.wright-948385 (1/21/2010)


    Luck then!

    Nope.

  • RE: Database Size

    david.wright-948385 (1/21/2010)


    Lynn Pettis (1/21/2010)


    I selected the correct answer without hesitating.

    How'd you do that without knowing which version of SQL Server it was asking about, or whether the model database had...

  • RE: Database Size

    mtassin (1/21/2010)


    Lynn Pettis (1/21/2010)


    Have you checked model to see if that is how it is configured on each of the systems? You may not have fiddled with model, but...

  • RE: Distribution clean up failed with dead lock in MS SQL 2005 dev ed

    Duplicate post, please post any responses here.

  • RE: Database Size

    mtassin (1/21/2010)


    psm-983793 (1/21/2010)


    Hi,

    On my Developer edition both 2005 and 2008 come up with 3MB and 1MB.

    Windows 7 x64

    Cheers,

    Peter

    2 MB mdf, 3 MB ldf here, and I know I haven't fiddled...

  • RE: Any SQL gurus / n00bs that are closet musicians?

    Schadenfreude-Mei (1/21/2010)


    What do you mean 'SP' :ermm:

    He was questioning the spelling of mesmerizing.

  • RE: How Do You Handle the Stress of Being a DBA?

    Some stress is good, some stress is bad. I have found, personally, that there needs to be some level of stress in the environment in order to get things...

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/20/2010)


    Heh... I've found a sure-fire way to keep from having problems with MySQL ODBC drivers... don't use them or MySQL. 😛

    Wish I could, unfortunately when people purchase 3rd...

  • RE: Best Overall Certification Right Now

    I have to agree, experience is more important. I have been working with SQL Server for over 12 years, no certs. I'll also agree that you have to...

  • RE: Are the posted questions getting worse?

    Chad Crawford (1/20/2010)


    Alvin Ramard (1/20/2010)


    Probably not, but you can add it to your resume.

    Excellent idea!

    Alright, back to the shadows behind the watercooler for me...

    Chad

    Yea, can see it now:

    Assisted SQL...

  • RE: Backup Failed

    Hard to say, but this error, Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.), could be the result of...

  • RE: Are the posted questions getting worse?

    tosscrosby-60625 (1/20/2010)


    Lynn Pettis (1/20/2010)

    I'll see if one of my kids can make up a certificate for you. They seem better at that sort of stuff then me. 😉

    Isn't that...

  • RE: Backup Failed

    Potentially a permissions issue on the share you are backing up to. The service account running the agent service may not have the needed permissions to write to that...

  • RE: Join tables by matching this month data and previous month data

    Please read the first article I have referenced below in my signature block regarding asking for assistance. Please follow the instructions in that article and provide us with table...

Viewing 15 posts - 17,296 through 17,310 (of 26,484 total)