Forum Replies Created

Viewing 15 posts - 41,851 through 41,865 (of 49,552 total)

  • RE: How to manage errors efficiently?

    crfenix (1/9/2009)

    Thanks you all for your answers! My script will be executes on MANY servers and I think a couple of them are sql server 2000 so Try Catch is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 8:53 am

    #924269

  • RE: SQL trigger

    The inserted table will contain all the rows that were updated. There may be more than one, SQL doesn't have row triggers.

    So, what you need is something like this

    UPDATE tbl_Question1Answers...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 8:41 am

    #924252

  • RE: SQL trigger

    Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic633463-8-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 8:39 am

    #924251

  • RE: SSIS a pain and Openrowset is disabled no access for linked...

    JPLeBlanc (1/9/2009)

    It looks and feels fairly simple but each time i do this i get an import error. It finds the data but from what i remember without doing...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 8:26 am

    #924233

  • RE: Transaction log status

    There's no equivalent on SQL 2000.

    On SQL 2000, check to make sure the log backups are running and check that there are no old open transactions or old unreplicated...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 8:24 am

    #924229

  • RE: How big will the transaction logs get?

    Mat Cottrell (1/9/2009)

    Is there a way to get an idea on this?

    How long is a piece of string?

    It depends on the activity in your database, the frequency of your log...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 8:22 am

    #924226

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/9/2009)

    Oh heck yes. I've got no issues with heat. You sweat, what's the big deal?

    Cold hurts.

    I'm actually the other way around. The heat just kills me. Day...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 8:13 am

    #924210

  • RE: Numerical values getting trunctaed in 2005 which were not in 2000

    Please post table definitions, sample data, the query and show what you think you should be getting, and what you are. Read this to see the best way to post...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 7:39 am

    #924168

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/9/2009)

    There's about 3 inches of completely frozen snow in my yard and another 4-6 inches of the fluffy crap on the way tomorrow night.

    BLECH!

    It's been 30+ degrees here...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 7:31 am

    #924160

  • RE: Update small parts of XML in DB

    jonas_granlund (1/9/2009)

    I dont agree to that SQL server 2008 dont work as an XML Store, with the new enhancement in XQuery and XML Schema it is a really great XML...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 7:27 am

    #924153

  • RE: Update small parts of XML in DB

    jonas_granlund (1/9/2009)

    Im not sure if you mean to store claims in a traditional (relational) way with each attribute for the claim in an own column?

    Absolutely. SQL is a relational...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 1:17 am

    #923962

  • RE: Help needed to do performance tune in stored...

    The first thing I would suggest is you try to split that up into smaller procedures. First, it'll make it more likely for the thing to get an optimal plan,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 1:03 am

    #923954

  • RE: How do I solve 2005 workgroup deadlocks

    langsoo (1/8/2009)

    How should I go about optimizing to get rid of the deadlocks?

    Please post the deadlock graph that traceflag 1222 produces.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 9, 2009 at 12:38 am

    #923943

  • RE: highest unused ID

    foxjazz (1/8/2009)

    yea, sorry I guess I meant lowest unused.

    if 1,2,4,5 are used, then 3 would be a result.

    So you want the lowest unused value from an identity column? Not a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 8, 2009 at 3:17 pm

    #923766

  • RE: Restore Database Without Log

    Can you describe your scenario in more detail please? Are you restoring a backup, trying to attach a database, something else?

    Do you have a clean, uncorrupted backup of this database?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 8, 2009 at 3:08 pm

    #923757

Viewing 15 posts - 41,851 through 41,865 (of 49,552 total)