Forum Replies Created

Viewing 15 posts - 41,311 through 41,325 (of 49,552 total)

  • RE: Files per Filegroup depends on # of CPU?

    sqlfriend (1/29/2009)

    # of files per filegroup = # of CPUs in the system?

    No. Not at all. That recommendation is give for TempDB and only for TempDB and only if you're...

    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 29, 2009 at 12:48 pm

    #935001

  • RE: Am I deadlocking?

    If it was a deadlock, you'd be getting a different error.

    Msg 1205, Level 13, State 45, Line 5

    Transaction (Process ID 53) was deadlocked on lock resources with another process and...

    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 29, 2009 at 12:45 pm

    #934999

  • RE: Deadlock notification(When many jobs hangs)

    A deadlock won't cause a job to hang. It would cause a job to fail. Are you sure you're getting deadlocks, and not regular blocking?

    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 29, 2009 at 12:45 pm

    #934998

  • RE: Newbie:Why is select doing a table scan?

    ScottPletcher (1/29/2009)

    I never said it was doing a seek, I said it was using the index. It looked to me like SQL was scanning the non-clus index to get...

    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 29, 2009 at 12:29 pm

    #934987

  • RE: Trending

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic645895-145-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 29, 2009 at 7:29 am

    #934666

  • RE: update trigger

    What I'd suggest is, instead of sending the mail direct from a trigger (which is usually a bad idea anyway), have the trigger write the info for the mails into...

    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 29, 2009 at 7:14 am

    #934646

  • RE: Restoring Back-Ups into a Different Server

    Please create a new thread for a new question, don't just tag on to the end of an existing thread.

    In addition, this is a repeat of a post tagged onto...

    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 29, 2009 at 7:01 am

    #934633

  • RE: Error when trying to Restore a .bak file.

    Sounds like you're trying to restore over an existing database. If this is a migration from MSDE to SQL 2005, why are you restoring over an existing database? You should...

    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 29, 2009 at 6:59 am

    #934626

  • RE: update trigger

    sudhirbharti (1/29/2009)

    SELECT @user-id = userid,

    @OldCity= d.City

    FROM deleted d

    SELECT @NewCity =...

    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 29, 2009 at 6:58 am

    #934624

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/29/2009)

    I was under the impression you were only filthy rich :D.

    I wish!

    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 29, 2009 at 6:39 am

    #934602

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/29/2009)

    Ya Grant don't rub it in, she's not a consultant anymore :P:hehe::cool:

    I'm not?

    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 29, 2009 at 6:25 am

    #934584

  • RE: How to prevent SQL Injection Attack?

    It's not sufficient. Consider this malicious parameter that has neither ;, nor --, nor any hex string at all.

    declare @query varchar(max)

    declare @parameter varchar(200)

    set @parameter = '''' + CHAR(13) + CHAR(10)...

    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 29, 2009 at 6:13 am

    #934577

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/29/2009)

    ...fithy rich consultant...

    I wish!

    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 29, 2009 at 6:05 am

    #934568

  • RE: Are the posted questions getting worse?

    I was thinking the super, ultimate, extremely awesome version. Why settle for second-best?

    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 29, 2009 at 5:49 am

    #934554

  • RE: Problem with if condition

    Christopher Stobbs (1/29/2009)

    any advice on why the Deferred naming option is a NO NO 🙂

    Did I say it was? It's an interesting trick.

    I said dynamic SQL's the only way...

    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 29, 2009 at 4:36 am

    #934514

Viewing 15 posts - 41,311 through 41,325 (of 49,552 total)