Forum Replies Created

Viewing 15 posts - 28,531 through 28,545 (of 49,552 total)

  • RE: i need to audit the back end processes on sql server ie which user ran what query with what program

    Do some searching for 'Server side trace', there have been several articles written about that. The trace can also get you host name, login name, program name, etc.

    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 11, 2011 at 6:46 am

    #1271847

  • RE: Same query plan, but differing times

    I meant the graphical plan. Include actual execution plan, save as .sqlplan file.

    By removing the wildcard you've changed the like to an =. It is less work to do, even...

    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 11, 2011 at 6:43 am

    #1271846

  • RE: In Sql Server Can we recover new log file(.ldf) if we added that after full backup

    One question first. Why would you be adding another log file?

    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 11, 2011 at 6:01 am

    #1271832

  • RE: MAX() Behavior on Indexed Columns

    Was discussed here: http://www.sqlservercentral.com/Forums/FindPost1044266.aspx and in next few replies

    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 11, 2011 at 5:56 am

    #1271828

  • RE: Same query plan, but differing times

    Post the plans?

    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 11, 2011 at 5:43 am

    #1271822

  • RE: i need to audit the back end processes on sql server ie which user ran what query with what program

    If you need to track all procedures that run against the server, you need a trace. The query stats DMV doesn't necessarily reflect everything that ran on the server.

    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 11, 2011 at 5:35 am

    #1271820

  • RE: Error : Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)" in SQL 2005

    Please note: 3 year old thread.

    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 11, 2011 at 2:59 am

    #1271769

  • RE: Temporary variables in SQL

    It's used when you run into problems with parameter sniffing.

    http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

    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 11, 2011 at 2:56 am

    #1271768

  • RE: How to take Backup of large Database

    Well, you can take backups the same way you take them for small databases. BACKUP DATABASE still works. It may be impractical because of the time, but it does work.

    There...

    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 11, 2011 at 2:50 am

    #1271765

  • RE: Restore DB backup from Enterprise Edition to Standard Edition

    Henrico Bekker (1/11/2011)

    If your source SQL Server is on a newer Service Pack level, your destination needs to be the same.

    You can, in the vast majority of cases, restore from...

    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 11, 2011 at 12:53 am

    #1271738

  • RE: Recover the Table Data

    Do you have log backups? An unbroken chain of log backups from the last full/diff backup up to the point that you deleted data?

    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 11, 2011 at 12:51 am

    #1271736

  • RE: Exists and IF Exists

    Elliott Whitlow (1/10/2011)

    nekonecny (1/10/2011)

    I need only one row (top 1), if i use "EXISTS". Is Optimizer so clever to eliminate other potential rows?:-)

    Yes, it is.. An EXISTS check completes...

    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 10, 2011 at 1:53 pm

    #1271619

  • RE: SQL Server 2008R2 - Backups

    Are you appending to the same backup file?

    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 10, 2011 at 12:20 pm

    #1271559

  • RE: Index rebuild/reorg and statistics

    Chad Crawford (1/10/2011)

    Good timing too, since I'm giving a short presentation on Wednesday that includes a section on statistics.

    If you'd like a copy of my deck from PASS 2009...

    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 10, 2011 at 12:19 pm

    #1271558

  • RE: SQL Server 2008R2 - Backups

    How are you taking your backups? What command?

    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 10, 2011 at 10:51 am

    #1271522

Viewing 15 posts - 28,531 through 28,545 (of 49,552 total)