Forum Replies Created

Viewing 15 posts - 21,736 through 21,750 (of 49,552 total)

  • RE: DBA activity How to find out backend correction audit log

    Grant Fritchey (12/14/2011)

    If you do need to set up a custom set of monitors to keep track of changes long term, instead of relying on the default trace or using...

    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

    December 14, 2011 at 8:32 am

    #1421369

  • RE: DBA activity How to find out backend correction audit log

    Dev (12/14/2011)

    Triggers are costly affairs (in terms of performance).

    A well-written DDL trigger is not a performance problem, unless the DB is creating and tens or hundreds of objects/sec....

    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

    December 14, 2011 at 2:27 am

    #1421116

  • RE: Need Optimization the Query

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    December 14, 2011 at 1:51 am

    #1421089

  • RE: corrupt going from 2000 to 2008

    ALZDBA (12/14/2011)

    to ease your load, you could consider creating FK-constraints after the load has been performed.

    And probably the nonclustered indexes as well.

    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

    December 14, 2011 at 1:47 am

    #1421084

  • RE: DBA activity How to find out backend correction audit log

    Very common requirement. Two ways you can do this.

    1) Default trace. All object alterations are logged in the default trace, so you can read that from a scheduled job 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

    December 14, 2011 at 1:46 am

    #1421082

  • RE: Are my DB Settings ok?

    Your autogrow on the data file is insanely low. For a 300 GB database I'd set autogrow probably 5GB-10GB to start. See how long 10GB growth takes (minimal if instant...

    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

    December 14, 2011 at 1:22 am

    #1421074

  • RE: corrupt going from 2000 to 2008

    jacobbdrew (12/13/2011)

    so, I'm going to try this tonight and have been trying to research the best options. here's what i have so far (with some questions.)

    step 1) create scripts for...

    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

    December 14, 2011 at 1:14 am

    #1421072

  • RE: how different could it be joining a #temp_table Vs @table_variable?

    sqldba_newbie (12/13/2011)

    Now the problem is, all this time i was testing the sql with in the function, when i do a "select * from my_functionname" it seems it is 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

    December 13, 2011 at 2:25 pm

    #1420901

  • RE: How long should a shrink take

    Cool. Now go rebuild all of your indexes to fix the fragmentation that the shrink caused.

    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

    December 13, 2011 at 2:17 pm

    #1420897

  • RE: Query to return which tables and indexes are in each file group and file

    Lowell (12/13/2011)

    isn't the "table" data stored wherever the HEAP or CLUSTERED idnex type is stored?

    Yup.

    The heap (index id 0) or clustered index (index id 1) is the table, it's 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

    December 13, 2011 at 12:35 pm

    #1420827

  • RE: Query to return which tables and indexes are in each file group and file

    If there's only one file in the filegroup, then there's your answer. If there's more than one file in the filegroup, the data will be spread across all the files...

    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

    December 13, 2011 at 12:24 pm

    #1420820

  • RE: How long should a shrink take

    Sean Grebey-262535 (12/13/2011)

    How long should this process take normally? Thanks.

    Depends. Got heaps or LOB columns?

    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

    December 13, 2011 at 11:49 am

    #1420801

  • RE: TempDB Test question

    Lexa (12/13/2011)

    What if the server does not come back up? If you can't connect to the server to alter tempdb location, what are the options?

    You can start up...

    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

    December 13, 2011 at 11:47 am

    #1420799

  • RE: Microsoft Sql server standard download

    You'll have to download enterprise evaluation and use that, or buy a licence for standard edition, there's no free trial version of standard edition.

    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

    December 13, 2011 at 11:44 am

    #1420796

  • RE: Rename named instance on an Active-Active Cluster

    You can't change the name of a named instance without reinstalling. The addserver/dropserver are for when the name of the computer has changed.

    So, if I have a SQL instance Server1\SQL2008...

    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

    December 13, 2011 at 10:18 am

    #1420735

Viewing 15 posts - 21,736 through 21,750 (of 49,552 total)