Forum Replies Created

Viewing 15 posts - 781 through 795 (of 1,319 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (2/20/2009)


    Bob Hovious (2/20/2009)


    Is there an easy way to search for all the threads he has originated?

    You sure you want to do that?

    That was my thought as well. A glutton...

    -- You can't be late until you show up.

  • RE: UDF not returning desired format

    Lynn Pettis (2/20/2009)


    Have a great weekend.

    You too!

    -- You can't be late until you show up.

  • RE: UDF not returning desired format

    Lynn Pettis (2/20/2009)


    It has something to do with the PRINT statement. This, select dbo.ufnGetGentranDate (1220905427); returns what you'd expect.

    I knew I was getting blurry-eyed looking at it and a...

    -- You can't be late until you show up.

  • RE: UDF not returning desired format

    Pure datetime:

    2009-02-20 15:54:26.427

    That's why I am so confused. Getting close to quitting time for the week. Maybe a fresh pair of eyes from home tomorrow will yield something as I'm...

    -- You can't be late until you show up.

  • RE: SQL or Oracle

    Roy Ernest (2/16/2009)


    I know for a fact that Oracle will loose in a MS SQL Forum... But these many people against it ??:unsure:

    Ya' think? Any stats to support your argument?

    --...

    -- You can't be late until you show up.

  • RE: Problem to Restore the Backup frpm SQL Server 2005 to 2000

    You can, however, script the 2005 database, create it in 2000 and then export the data. As Adi stated, you cannot restore a backup to an older version.

    -- You can't be late until you show up.

  • RE: if sql server slow

    It depends. Use perfmon and profiler for watching the metrics for the apps/server and what statements are being called to try and catch poor performing queries. Look at your hardware...

    -- You can't be late until you show up.

  • RE: How Many DBAs

    That was my point exactly, however I failed to state that I am the only SQL DBA at my job too. A lot of the administrative stuff becomes redundant and...

    -- You can't be late until you show up.

  • RE: How Many DBAs

    It's the infamous "it depends" answer. I have 10 production servers, and maybe 15 dev/test servers and from an administrative standpoint, maintenance takes about 10% of my time. My jobs...

    -- You can't be late until you show up.

  • RE: data file

    Personally, I don't like MAXSIZE unless you're really limited on disk space, in which case you should be proactively monitoring growth and determining when you may run out of space...

    -- You can't be late until you show up.

  • RE: Changed to a StarWars Avatar...am I part of the Club now?

    Grant Fritchey (2/6/2009)


    I've given up Boba Fett, so he's available.... which sounds weird.

    Not the BEST bounty hunter in the galaxy - was it a mutual agreement sort of thing? (now...

    -- You can't be late until you show up.

  • RE: restoring change logs

    Duplicate post. Post all replies to the link below. OP - Please don't double post as it will waste people's time when they respond to one and you've received the...

    -- You can't be late until you show up.

  • RE: restoring change logs

    Scripts abound everywhere. Search here, use BOL, Google. Do you know exactly what you're trying to accomplish on the restore? Point in time, last full backup and all logs after...

    -- You can't be late until you show up.

  • RE: Changed to a StarWars Avatar...am I part of the Club now?

    Steve Jones - Editor (2/3/2009)


    I never noticed that. I'll take Chewbacca if no one else has him.

    I think "chewie" is up for grabs....

    -- You can't be late until you show up.

  • RE: Database Status SUSPECT

    And this means what to a topic that has been dormant for 9 months? Care to shed any light on the issues you had and how you corrected them?

    -- You can't be late until you show up.

Viewing 15 posts - 781 through 795 (of 1,319 total)