Forum Replies Created

Viewing 15 posts - 16,621 through 16,635 (of 49,552 total)

  • RE: Index columns Selectivity

    No, there is no magic formula.

    You look at all the queries running against that table (not just one), then you figure out which columns they filter on and which order...

    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

    September 14, 2012 at 6:09 am

    #1537756

  • RE: logical consistency-based I/O error: incorrect checksum

    Did you run checkDB on TempDB?

    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

    September 14, 2012 at 5:13 am

    #1537735

  • RE: Index columns Selectivity

    chandan_jha18 (9/14/2012)

    So the question that I am still not able to find answer to is: how to decide which columns out of the above 3 should go as first column...

    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

    September 14, 2012 at 5:00 am

    #1537729

  • RE: Index columns Selectivity

    It's not selectivity that's the biggest key.

    http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

    http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    Edit: fixed one link

    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

    September 14, 2012 at 2:54 am

    #1537688

  • RE: Reorganize Indexes in sql 2008

    Let me guess....

    You've seen no change in fragmentation. These tables are all very small, maybe a few hundred to a few thousand rows.

    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

    September 14, 2012 at 2:47 am

    #1537685

  • RE: invalid object name 'sys.identity_columns'

    Compat mode does not affect the visibility of the DMVs. All DMVs are viewable no matter what the compat mode is.

    Now, if he's actually on SQL 200, that might. Please...

    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

    September 14, 2012 at 2:43 am

    #1537683

  • RE: How can i drop table?

    Not repairable. There's damage to the system tables.

    Script all objects, export all data and recreate the database. Then set up a backup strategy.

    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

    September 14, 2012 at 2:37 am

    #1537681

  • RE: simple que

    harri.reddy (9/13/2012)

    (2) If i define variable global variable in my stored proc doesnt it appear inside another stored proc.(nested)

    Perhaps because SQL doesn't have global variables?

    For the first, why don't...

    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

    September 13, 2012 at 4:58 pm

    #1537573

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/13/2012)

    GilaMonster (9/13/2012)

    Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-1.aspx

    We'll see. I hope I can be of help.

    He's in over his head...

    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

    September 13, 2012 at 4:39 pm

    #1537564

  • RE: What is Proper Steps to Remove FileGroups

    stanlyn (9/13/2012)

    Gail,

    From that article, did you read the very last part as show here:

    It is quite simple to fix this error, but you will need to delete all the Metadata...

    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

    September 13, 2012 at 4:16 pm

    #1537554

  • RE: What is Proper Steps to Remove FileGroups

    Sorry, wrong one. DBCC LogInfo.

    File ID maps to the file ID in sys.database_files. Status of 0 is inactive, 2 is active. A log file can only be dropped if 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

    September 13, 2012 at 4:13 pm

    #1537550

  • RE: What is Proper Steps to Remove FileGroups

    stanlyn (9/13/2012)

    Gail,

    Here is just one of the articles that you've suggested I throw away. Take a look at the bottom and advise...

    http://stackoverflow.com/questions/5946153/why-do-we-need-the-ldf-files-along-with-mdf-files

    Thanks, Stanley

    From that article...

    The database will be marked...

    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

    September 13, 2012 at 4:04 pm

    #1537538

  • RE: What is Proper Steps to Remove FileGroups

    stanlyn (9/13/2012)

    >> DBCC SQLPerf(LogSpace) to identify which log files are in use. If one is in use, you have to wait (not for time, for transactions to run)

    What can force...

    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

    September 13, 2012 at 4:01 pm

    #1537536

  • RE: SQL Compare 10

    Mail redgate support?

    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

    September 13, 2012 at 4:00 pm

    #1537535

  • RE: What is Proper Steps to Remove FileGroups

    andersg98 (9/13/2012)

    Make sure you have moved statistics and text/Image data as well.

    Statistics are stored in the system tables, hence are always on Primary

    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

    September 13, 2012 at 3:59 pm

    #1537533

Viewing 15 posts - 16,621 through 16,635 (of 49,552 total)