Forum Replies Created

Viewing 15 posts - 15,991 through 16,005 (of 49,552 total)

  • RE: sql locking problem

    Bad, bad, bad idea. Unless your users are happy with their reports being potentially inaccurate (have you asked them it 'mostly correct' is acceptable? Have you asked your manager 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

    October 21, 2012 at 5:08 am

    #1551147

  • RE: Index question

    L' Eomot Inversé (10/21/2012)

    The reason this was useful instead of a catastrophic mistake was that you were selecting only 1 row

    in about 100,000 rather than 1 row in 4,...

    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

    October 21, 2012 at 5:04 am

    #1551146

  • RE: sql locking problem

    You always have locking on updates, you will have locking on the select unless in one of the snapshot isolation levels.

    Are you seeing blocking, or is the update just slow?

    What's...

    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

    October 21, 2012 at 4:33 am

    #1551144

  • RE: Index question

    Lee Crain (10/20/2012)

    But let's look at the worst case. Let's say that:

    > the data in the column is evenly distributed. There are exactly 12,500,000 rows for each of the 4...

    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

    October 21, 2012 at 4:24 am

    #1551142

  • RE: SQL Server 2008 - DB failed to attach

    Uninstall that and install the release version of SQL 2008. I don't know how you have a CTP still working, unless you're playing tricks with the system clock. All CTPs...

    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

    October 21, 2012 at 4:03 am

    #1551141

  • RE: Index question

    Lee Crain (10/20/2012)

    Gail,

    If the original poster creates an index on just the column with the 4 values, will this not force the Optimizer to use that index?

    "SELECT <column names> FROM...

    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

    October 20, 2012 at 3:26 pm

    #1551129

  • RE: Index question

    Lee Crain (10/20/2012)

    sunny.tjk,

    Why don't you try both solution ideas:

    1. One large, low cardinality index

    2. Four filtered indexes

    and let us know which performs the best.

    Unless covering, SQL will ignore both...

    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

    October 20, 2012 at 1:19 pm

    #1551126

  • RE: SQL Server 2008 - DB failed to attach

    Please run SELECT @@version

    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

    October 20, 2012 at 11:32 am

    #1551122

  • RE: dbcc shrinkfile

    DBA328 (10/19/2012)

    DBCC shirinkfile may not move data to other files. you can virtually move the data from the table to a different filegroup by creating a clustered index and placing...

    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

    October 20, 2012 at 3:48 am

    #1551102

  • RE: Index question

    SpringTownDBA (10/19/2012)

    If you're on enterprise edition, 4 filtered indexes (1 for each distinct value) might be your best bet.

    Filtered indexes aren't an Enterprise-only feature.

    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

    October 20, 2012 at 3:38 am

    #1551100

  • RE: Transaction Log Shipping and performance

    What's wrong with native backup compression? Standard edition?

    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

    October 19, 2012 at 2:27 pm

    #1551055

  • RE: Transaction Log Shipping and performance

    Thought you were asking about adding indexes on the primary.

    Transactional replication. Or a complete restore of the full backup nightly. Log shipping, mirroring both leave the DB on the secondary...

    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

    October 19, 2012 at 1:05 pm

    #1551032

  • RE: Transaction Log Shipping and performance

    oradbguru (10/19/2012)

    Would we be able to add new indexes to the target database once it is in LS mode?

    Edit: misread. No, target is read-only at best.

    oradbguru (10/19/2012)

    Also, if I were...

    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

    October 19, 2012 at 12:46 pm

    #1551023

  • RE: Are the posted questions getting worse?

    Sean Lange (10/19/2012)

    Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes. No other...

    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

    October 19, 2012 at 11:17 am

    #1550980

  • RE: Types of DBA's ???

    Well you can't delete the discussion anyway, so don't 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

    October 19, 2012 at 11:12 am

    #1550975

Viewing 15 posts - 15,991 through 16,005 (of 49,552 total)