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...

  • RE: UDF not returning desired format

    Lynn Pettis (2/20/2009)


    Have a great weekend.

    You too!

  • 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...

  • 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...

  • 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?

    --...

  • 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.

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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....

  • 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?

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