Forum Replies Created

Viewing 15 posts - 27,496 through 27,510 (of 49,552 total)

  • RE: Non-Clustered Indexes - Need some advice

    Rich Yarger (3/8/2011)

    Who? My report writer? LOL! Nah - he thinks I'm a pain in the ace.

    I wish I had better news on that front - still...

    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 8, 2011 at 10:27 pm

    #1296300

  • RE: How to ensure Security for MDF and LDF files

    Go to the forum that's relevant to the question (click on Forums on the left to get the full list) Click on the 'New Thread' button at the top.

    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 8, 2011 at 10:26 pm

    #1296299

  • RE: How to ensure Security for MDF and LDF files

    Please post new questions in a new thread. Thank 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

    March 8, 2011 at 2:55 pm

    #1296195

  • RE: Code/Syntax for setting READ | UNCOMMITTED

    In case you missed the warning I gave earlier...

    GilaMonster (3/8/2011)

    Before you go and add that to the procedure however, please note that all that is doing is hiding blocking problems....

    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 8, 2011 at 2:53 pm

    #1296192

  • RE: Code/Syntax for setting READ | UNCOMMITTED

    Neither the set isolation level nor the begin tran nor the commit is part of the procedure. All they did was set the isolation level in the connection that created...

    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 8, 2011 at 1:57 pm

    #1296133

  • RE: Avoiding Logging

    Koen Verbeeck (3/8/2011)

    GilaMonster (3/8/2011)

    Koen Verbeeck (3/8/2011)

    If a data load fails, the destination table can be truncated and the load can start over again, so you would not have to worry...

    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 8, 2011 at 1:12 pm

    #1296109

  • RE: Oldest non-distributed LSN but No Transactional Replication

    Yup, that post and the issue is mentioned in the article I referenced (which is why I referred you to 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

    March 8, 2011 at 11:30 am

    #1296036

  • RE: SQL Query Performance Help !

    Execution plans please.

    Why did you disable parameter sniffing?

    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 8, 2011 at 8:28 am

    #1295914

  • RE: i get an error when i try to insert data ino tables

    Take a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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 8, 2011 at 8:27 am

    #1295912

  • RE: Reindexing Necessity

    No.

    Modifying the clustered index will rebuild all nonclustered indexes. The procedure you have there will rebuild all the nonclustered indexes 3 times. Far from fast.

    Drop all nonclustered indexes first. Then...

    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 8, 2011 at 8:24 am

    #1295911

  • RE: Moving a DB from one HDD to another

    None unless you're moving one version to another.

    Update stats needs to be done when upgrading from SQL 2000 to SQL 2005. If you're moving from one SQL 2008 server...

    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 8, 2011 at 8:14 am

    #1295903

  • RE: Primary Key fields as an Included Columns in a Composite Index

    clausm73 (3/8/2011)

    But when the field IS the clustered index I will now conclude that having the field in the INCLUDED COLUMNS list for the composite index only makes the index...

    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 8, 2011 at 8:07 am

    #1295898

  • RE: Is the SQL shorthand notation for equi-joins, by way of the USING construct deprecated?

    USING is not a SQL Server keyword. It's not that it's deprecated, it's that it's not valid.

    As for ANSI, no idea.

    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 8, 2011 at 7:55 am

    #1295889

  • RE: Avoiding Logging

    Koen Verbeeck (3/8/2011)

    If a data load fails, the destination table can be truncated and the load can start over again, so you would not have to worry about inconsistency.

    What would...

    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 8, 2011 at 7:49 am

    #1295880

  • RE: Oldest non-distributed LSN but No Transactional Replication

    See the replication section of this article: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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 8, 2011 at 7:46 am

    #1295879

Viewing 15 posts - 27,496 through 27,510 (of 49,552 total)