Forum Replies Created

Viewing 15 posts - 33,691 through 33,705 (of 49,552 total)

  • RE: Moving Statistics to Another Filegroup

    Statistics are stored in the system tables, not on a file group. They're stored in sysindexes which is always in PRIMARY, so groupid = 0.

    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

    March 4, 2010 at 4:50 pm

    #1128875

  • RE: Moving Statistics to Another Filegroup

    JohnnyDBA (3/4/2010)

    As far as using the GUI, it says online that if I update the location in the designer it'll recreate / swap the tables under the hood for me....

    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

    March 4, 2010 at 4:07 pm

    #1128858

  • RE: What will be good/accepted threshold values for Average Disk Seconds/Read, Average Disk Seconds/write

    gmamata7 (3/4/2010)

    but what should the accepted value for Avg. Disk Queue Length?

    No way to say. Depends completely on your IO subsystem and, if you've got a SAN, that...

    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

    March 4, 2010 at 3:59 pm

    #1128849

  • RE: Moving Statistics to Another Filegroup

    JohnnyDBA (3/4/2010)

    That's strange... when I do a select from sysobjects where i specify the groupid all it's showing now are textimage indexes and statistics. Do you think these could...

    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

    March 4, 2010 at 3:57 pm

    #1128846

  • RE: SSIS Interview Questions -COMPLEX 1ne

    cRuchika (3/4/2010)

    I still have doubts about BEST PRACTICES...

    Google SSIS Best Practices

    I mean I say that we can use NOLOCK,

    I wouldn't necessarily say that's a best practice. Common practice, yes,...

    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

    March 4, 2010 at 3:03 pm

    #1128811

  • RE: Moving Statistics to Another Filegroup

    The stats blobs are stored within the system tables, hence they will always be on PRIMARY and cannot be moved.

    Why do you want to move them?

    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

    March 4, 2010 at 1:32 pm

    #1128753

  • RE: Missing HD Unit in SQL SERVER 2008

    Clustered?

    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

    March 4, 2010 at 10:53 am

    #1128640

  • RE: Table Partioning in SQL Server 2000/2005

    Easy enough.

    There was no table partitioning in SQL 2000. It's a new feature in 2005, available in Enterprise edition.

    What SQL 2000 had was partitioned views, views whose source query unioned...

    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

    March 4, 2010 at 10:52 am

    #1128637

  • RE: SSIS Interview Questions -COMPLEX 1ne

    I don't think there are right or wrong questions for most of those. They look like questions designed to explore what you know, how you've worked in the past, what...

    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

    March 4, 2010 at 10:36 am

    #1128625

  • RE: Tail of the log

    river1 (3/4/2010)

    This is a new database. I have created the database and then i have made a backup ,so, how can i LOSE transactions if a full backups as all...

    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

    March 4, 2010 at 10:22 am

    #1128612

  • RE: Tail of the log

    river1 (3/4/2010)

    When i make a backup of a database that is in full recovery model, when i try to restore it, through the GUI , the GUI does not let...

    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

    March 4, 2010 at 9:01 am

    #1128550

  • RE: A Function to covert Float data column into varchar(50) w/o lossing any digits

    Moved here: http://www.sqlservercentral.com/Forums/Topic876858-338-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

    March 4, 2010 at 8:27 am

    #1128540

  • RE: Is it possible to recover a table that has been deleted?

    That's why backups are important (one of the reasons)

    If you drop a table within a transaction, the drop can be rolled back, just like any other change. Once the transaction...

    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

    March 4, 2010 at 8:27 am

    #1128538

  • RE: Bookmark / Key Lookup (Clustered) Issue

    r5d4 (3/4/2010)

    The base table is access for the primary key by an 'Index Seek' too.

    These Index seeks cost 4% , 4% and 1% respectively.

    The columns returned from the base table...

    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

    March 4, 2010 at 6:34 am

    #1128474

  • RE: What will be good/accepted threshold values for Average Disk Seconds/Read, Average Disk Seconds/write

    For sec/read and sec/write, under 10ms is good. 10-20ms is average. Over 50ms is bad.

    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

    March 4, 2010 at 2:26 am

    #1128347

Viewing 15 posts - 33,691 through 33,705 (of 49,552 total)