Forum Replies Created

Viewing 15 posts - 10,906 through 10,920 (of 49,552 total)

  • RE: On which column to create index if no where clause is present ?

    Koen Verbeeck (11/18/2013)

    Maybe - and just maybe - you might benefit from a (clustered) columnstore index - if you're using SQL Server 2012 or 2014 - because those indexes compress...

    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

    November 18, 2013 at 1:02 am

    #1667041

  • RE: An error while copying database

    Koen Verbeeck (11/17/2013)

    Wouldn't a compressed full backup/restore have been faster?

    A normal uncompressed backup/restore would likely have been faster and less prone to random failures.

    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

    November 18, 2013 at 12:44 am

    #1667035

  • RE: On which column to create index if no where clause is present ?

    I disagree with you completely.

    Every table should have a clustered index, but certainly not on 'a random column'. The column has to be carefully chosen. That's irrelevant to this question...

    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

    November 18, 2013 at 12:41 am

    #1667032

  • RE: On which column to create index if no where clause is present ?

    None, there's no index useful for that query.

    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

    November 18, 2013 at 12:21 am

    #1667020

  • RE: Migrate a SQL 2000 database to a different server

    Restore then, run a checkDB with data_purity, update all stats with fullscan, run DBCC updateusage. Then consider whether you're going to change the compatibility level

    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

    November 17, 2013 at 11:54 pm

    #1667016

  • RE: Corrupt Backup File ?

    Maybe. But it's a temporary mitigation. If you have stuff fragmenting MemToLeave, increasing the size will delay the problems, not prevent them.

    Also, that means that, without AWE or 3GB, you...

    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

    November 17, 2013 at 10:16 pm

    #1667008

  • RE: Execution plan uses CONVERT_IMPLICLIT , But i have mention CAST in where clause

    Post the plan.

    Not seeing why you're concerned though. Convert implicit isn't expensive, it just prevents index seeks, and cast does exactly the same.

    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

    November 17, 2013 at 10:11 pm

    #1667007

  • RE: Killing a transaction

    Oracle_91 (11/17/2013)

    Can anyone share such instances/examples where locks are being hold and what would you do to overcome the problem. Someone has already killed it and comes to dba 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

    November 17, 2013 at 10:06 am

    #1666957

  • RE: Killing a transaction

    1) you can, but you should probably figure out what it's doing first and what will happen when it gets undone.

    2) Until the rollback completes. Do not restart SQL unless...

    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

    November 17, 2013 at 2:03 am

    #1666916

  • RE: RESTORE, Media Set and Family Count

    The error is because two files were specificed for the backup. This is commonly by mistake, where there were two files listed in the destination box on the backup dialog...

    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

    November 16, 2013 at 8:13 am

    #1666888

  • RE: open table in SQl 2005

    No guarantee of any order. I think with the open table you can click a button at the top to get the query, add the order by and re-run, but...

    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

    November 16, 2013 at 2:31 am

    #1666872

  • RE: Does a SQL Server Backup can be restored to different disk space sizes from original?, and how?

    A restore recreates the database exactly as it was at the time of backup, including all file sizes. You need the same space for the files as the source database...

    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

    November 15, 2013 at 6:59 am

    #1666725

  • RE: Index creation after Insert for Temporary Table inside a SP

    Unless you're talking about many minutes of processing time and GB of TempDB space, just let the temp tables go out of scope and they'll be automatically dropped.

    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

    November 15, 2013 at 6:32 am

    #1666713

  • RE: Index creation after Insert for Temporary Table inside a SP

    If you need to empty the table it's fine, faster than delete. If you don't have further use for the table, drop it.

    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

    November 15, 2013 at 6:05 am

    #1666707

  • RE: Index creation after Insert for Temporary Table inside a SP

    ganeshc27 (11/15/2013)

    The column on which the NCI is created, is being used in the WHERE conditions in the queries post this Index creation. How do I find whether this NCI...

    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

    November 15, 2013 at 5:54 am

    #1666704

Viewing 15 posts - 10,906 through 10,920 (of 49,552 total)