Forum Replies Created

Viewing 15 posts - 24,196 through 24,210 (of 49,552 total)

  • RE: Does SQL Server issue when we shut down windows/SQL Server ?

    It'll try to shut down cleanly, depends what's running/outstanding. There's only so much time allowed during a restart.

    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

    August 12, 2011 at 4:50 am

    #1367802

  • RE: Cannot open tables in Database

    I wouldn't bet on it.

    Data recovery companies get data off a damaged/unreadable drive (and they charge a fortune). The drive here is readable, but the SQL database is toast, hence...

    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

    August 12, 2011 at 4:46 am

    #1367800

  • RE: how to all table which indexes are useing in database

    Query sys.indexes join to sys.tables

    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

    August 12, 2011 at 2:27 am

    #1367763

  • RE: Why bulk logged recovery model supports Logshipping

    Eddie Wuerch (8/11/2011)

    In the bulk-logging recovery model, transaction log backups contain all data pages that were modified as a result of the transactions in the transaction log backup. (Yes, 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

    August 12, 2011 at 2:27 am

    #1367762

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/11/2011)

    Forever it won't dominate your destiny. Life there is after the dark side.

    I was going to wait until tomorrow night, but it is close enough.

    I am resigning...

    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

    August 12, 2011 at 2:22 am

    #1367761

  • RE: Simplify Large Queries with Temporary Tables, Table Variables and CTEs

    mstjean (8/11/2011)

    EdSwiedler (8/9/2011)

    One thing that I have found that can cause a temporary table or table variable to perform better than a CTE is that you can create indexes on...

    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

    August 12, 2011 at 2:18 am

    #1367759

  • RE: Can I move sorting and avoid Order By with Clustered Index on an empty table?

    You can't include columns in a clustered index. The cluster by definition includes all columns in a table.

    Some more reading for you, if you want:

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

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

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

    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

    August 12, 2011 at 2:12 am

    #1367755

  • RE: Shrink Database

    Evil Kraig F (8/11/2011)

    It's getting to the point that people are actually worried about submitting QOTDs because of reactions like yours. Chill dude.

    I'm not submitting any more. It's a...

    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

    August 12, 2011 at 2:00 am

    #1367750

  • RE: trying to reduce the amount of logical reads

    The Dixie Flatline (8/11/2011)

    If the ID is included as part of the index, the optimizer can find MAX by matching on [field_name1] and [field_name2], then reading the last value of...

    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

    August 12, 2011 at 1:42 am

    #1367745

  • RE: Can I move sorting and avoid Order By with Clustered Index on an empty table?

    Right, so if you change those to datetimes ('2009-06-01 00:00:00' and '2010-06-01 00:00:00') then your where clause becomes as simple as

    WHERE <column name> >= @Start_dt AND <column name> < @End_dt...

    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

    August 11, 2011 at 4:05 pm

    #1367639

  • RE: Can I move sorting and avoid Order By with Clustered Index on an empty table?

    drew.georgopulos (8/11/2011)

    The start and end dates have no time associated with them and the intent was to group the data by month

    So what would example values of those be?

    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

    August 11, 2011 at 3:50 pm

    #1367633

  • RE: Can I move sorting and avoid Order By with Clustered Index on an empty table?

    drew.georgopulos (8/11/2011)

    Create a clustered index including effective date, termination date (the parameters) & dx1 through dx8

    That sounds like a rather poor choice for a clustered index. Clustered indexes should...

    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

    August 11, 2011 at 3:48 pm

    #1367631

  • RE: Yeah! my first real corrupt DB

    Patch to SP4 first and confirm that the behaviour's unchanged (CSS will almost certainly want you to do that)

    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

    August 11, 2011 at 3:43 pm

    #1367624

  • RE: CDE in SQL

    I've heard of TDE (transparent database encryption), CTE (common table expression), CDC (change data capture), never heard of a CDE.

    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

    August 11, 2011 at 3:39 pm

    #1367621

  • RE: Yeah! my first real corrupt DB

    @@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

    August 11, 2011 at 3:36 pm

    #1367617

Viewing 15 posts - 24,196 through 24,210 (of 49,552 total)