Forum Replies Created

Viewing 15 posts - 12,256 through 12,270 (of 49,552 total)

  • RE: Partition Strategy

    Chris-475469 (7/23/2013)

    I'm aware that partitioning isn't primarily a performance enhancer but I have seen examples where SQL Server will only look at one partition for the data it requires (if...

    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

    July 24, 2013 at 2:06 am

    #1635232

  • RE: checkpoint for committed transactions..

    Checkpoint writes all modified pages to disk.

    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

    July 23, 2013 at 4:28 pm

    #1635157

  • RE: Page level compression - Indices/Partitions/Heap

    curious_sqldba (7/23/2013)

    i) if a table has no clustered index and has non-clustered indices, do i need to compress the table first and then the nc indices?

    Depends. Do you want the...

    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

    July 23, 2013 at 12:50 pm

    #1635098

  • RE: BACKUP WITH NORECOVERY

    Please note: 3 year old thread. New questions in a new thread 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

    July 23, 2013 at 8:19 am

    #1634972

  • RE: SP vs Identical T-SQL - different results

    Can you also add the following to the procedure and to the ad-hoc SQL and post the output

    SELECT SESSIONPROPERTY(ANSI_NULLS), SESSIONPROPERTY(ANSI_PADDING)

    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

    July 23, 2013 at 6:48 am

    #1634922

  • RE: SP vs Identical T-SQL - different results

    Rob-350472 (7/23/2013)

    There must be something different with connecting to a separate database either in straight tSQL vis via a procedure, not sure what though (it's very rare for a proc...

    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

    July 23, 2013 at 6:36 am

    #1634917

  • RE: SP vs Identical T-SQL - different results

    Perhaps unrelated (or perhaps not), but those nolocks are going to cause you problems at some point.

    See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.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

    July 23, 2013 at 6:19 am

    #1634908

  • RE: exclude specific tables during the database restore

    Koen Verbeeck (7/23/2013)

    So you're saying that if a restore a filegroup (primary and maybe others), all the other filegroups are taken offline?

    They can't be online, because they're not there. The...

    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

    July 23, 2013 at 5:38 am

    #1634889

  • RE: exclude specific tables during the database restore

    Koen Verbeeck (7/23/2013)

    An possible alternative could be (keep in mind that I'm not a restore expert) is to put the tables you do not want to restore on a different...

    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

    July 23, 2013 at 5:16 am

    #1634879

  • RE: SP / TABLE NAME

    No.

    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

    July 23, 2013 at 5:00 am

    #1634872

  • RE: SP vs Identical T-SQL - different results

    If they're producing different results, then there must be a difference somewhere in code or connection settings. There's no hidden 'return different results' properties of a procedure, there's no hidden...

    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

    July 23, 2013 at 4:59 am

    #1634871

  • RE: Viewing an xml plan as a graphical plan

    http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/28/getting-graphical-showplan-back-in-sql-server-2008-r2.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

    July 23, 2013 at 4:53 am

    #1634867

  • RE: exclude specific tables during the database restore

    No.

    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

    July 23, 2013 at 4:51 am

    #1634866

  • RE: SP vs Identical T-SQL - different results

    Can you post the two pieces of code?

    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

    July 23, 2013 at 4:50 am

    #1634864

  • RE: Will doing a backup slow down the system

    A backup does a huge amount of IO. If your system is not bottlenecked on IO, if the additional load the backup puts in place doesn't impact queries trying to...

    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

    July 23, 2013 at 3:51 am

    #1634835

Viewing 15 posts - 12,256 through 12,270 (of 49,552 total)