Forum Replies Created

Viewing 15 posts - 34,201 through 34,215 (of 49,552 total)

  • RE: SQL 2000 - Column Statistics

    The SQL 2000 forums are further down the page. They are there. I've requested a mod to move this thread there.

    For statistics on SQL 2000, you can query sysindexes (that'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

    February 5, 2010 at 12:02 am

    #1114205

  • RE: High Availability with zero RPO

    Replication is not a HA technique.

    By 0 RPO, do you mean absolutely 0 downtime? That's not possible. It's possible to get it to a couple seconds in favourable circumstances, 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

    February 4, 2010 at 11:55 pm

    #1114203

  • RE: Canceling an INSERT statement

    Joie Andrew (2/4/2010)

    If you are unsure of the result you could always wrap the statement in a transaction. That would ensure that if it was cancelled it would be rolled...

    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

    February 4, 2010 at 11:51 pm

    #1114202

  • RE: Will The SQL Server Optimizer Recognize and Use More Than One Index on a Single Table?

    So there are no queries that filter on AffiliateId or PartnerLocalDate without also filtering on CampaignID? Nothing that filters on just SubId?

    I'm actually not sure what it is that you're...

    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

    February 4, 2010 at 12:19 pm

    #1113923

  • RE: MDF AND NDF's Locations

    Ali_SQLDBA (2/4/2010)

    Because, SQL tries to look at different drives, and pull data from different drives which indicates more IOs

    What's the difference between pulling 50MB of data from one drive and...

    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

    February 4, 2010 at 12:18 pm

    #1113922

  • RE: MDF AND NDF's Locations

    Ali_SQLDBA (2/4/2010)

    GilaMonster (2/4/2010)

    Ali_SQLDBA (2/4/2010)

    I thought having mdf and ndf in different drives with different raid levels will cause extra IOs isnt it..

    Why?

    that was because of space issues with the original...

    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

    February 4, 2010 at 12:01 pm

    #1113911

  • RE: Will The SQL Server Optimizer Recognize and Use More Than One Index on a Single Table?

    crainlee2 (2/4/2010)

    Regarding your "ouch" comment: That was not particularly useful.

    I take it you haven't read the links I gave you, seeing as the first one was a discussion of 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

    February 4, 2010 at 12:00 pm

    #1113910

  • RE: MDF AND NDF's Locations

    Ali_SQLDBA (2/4/2010)

    I thought having mdf and ndf in different drives with different raid levels will cause extra IOs isnt it..

    Why?

    i am confused. let's take an example of a million row...

    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

    February 4, 2010 at 11:51 am

    #1113905

  • RE: Will The SQL Server Optimizer Recognize and Use More Than One Index on a Single Table?

    crainlee2 (2/4/2010)

    The search columns have been concatenated in the indexes from left to right, from highest cardinality to lowest cardinality

    Ouch.

    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

    February 4, 2010 at 11:41 am

    #1113903

  • RE: Will The SQL Server Optimizer Recognize and Use More Than One Index on a Single Table?

    crainlee2 (2/4/2010)

    Will the SQL Server Optimizer utilize the indexes in both of these situations effectively, assuming selectivity (cardinality) is acceptably granular on both columns:

    Depends what kind of queries you're running.

    Do...

    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

    February 4, 2010 at 11:40 am

    #1113900

  • RE: Msg 8909 & Msg 8998: Page allocation errors

    abo_moaaz (2/4/2010)

    1)As DBCC CHECKDB wasn't run before, this page corruption seems to have been present since weeks ago:w00t:. Does this entail necessity of running CHECKDB on daily basis during afterhours...

    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

    February 4, 2010 at 11:24 am

    #1113896

  • RE: Msg 8909 & Msg 8998: Page allocation errors

    Paul Randal (2/4/2010)

    I should do a blog post at some point

    Please?

    or you should do the MCM class 🙂

    Would love to. As soon as I persuade someone to pay for 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

    February 4, 2010 at 10:17 am

    #1113850

  • RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

    What do you mean by 'average of row counts'. Averages over what?

    I see 4 rows in the hour 7-8, 5 in the hour 8-9 and 2 in the hour 9-10....

    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

    February 4, 2010 at 10:14 am

    #1113849

  • RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    February 4, 2010 at 8:45 am

    #1113795

  • RE: Single mdf file attach in sql 2005

    Have a look at this blog post. Step by step for getting a DB back when the log's deleted. The process for when it's detached starts just past half way...

    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

    February 4, 2010 at 8:22 am

    #1113788

Viewing 15 posts - 34,201 through 34,215 (of 49,552 total)