Forum Replies Created

Viewing 15 posts - 41,956 through 41,970 (of 49,552 total)

  • RE: need a simple query

    shiwani2002sg (1/5/2009)

    hay all

    Well i want relation to be generated on the attribute 'A' of both the tables. but in both table A does not include any keys. and its stated...

    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

    January 6, 2009 at 7:08 am

    #921755

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/6/2009)

    URGENT!

    How do you pick indexes... Oh lordy

    I recommend a 20-sided dice.

    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

    January 6, 2009 at 6:54 am

    #921742

  • RE: Can you Replicate from a Mirrored database?

    tony.harris (1/6/2009)

    - i.e. having the Database Snapshot delegate to the mirror database for Views, Procedures and Functions?

    That's the only way you can do it. Database snapshots are read-only 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

    January 6, 2009 at 6:50 am

    #921741

  • RE: Please help with tuning, its taking infinity time to run

    Can you post the execution plan please. Save as a .sqlplan file, zip that and attach it to your post.

    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

    January 6, 2009 at 6:34 am

    #921727

  • RE: Tips on creating indexes

    Grant Fritchey (1/6/2009)

    Keep your indexes as small as you can.

    But no smaller than necessary. If the index needs to be four columns wide to be useful, making it only...

    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

    January 6, 2009 at 6:34 am

    #921726

  • RE: can not create index more than 249

    free_mascot (1/6/2009)

    In addition to the above, I guess Replication do not require index on all the columns. But it require a Cluster Index to get the article replicated.

    Transactional replication requires...

    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

    January 6, 2009 at 6:31 am

    #921723

  • RE: can not create index more than 249

    Why do you have 249 or so indexes on a table?

    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

    January 6, 2009 at 6:21 am

    #921716

  • RE: Can you Replicate from a Mirrored database?

    You can't use a mirror as a publisher, because the mirror database will be in a recovering state and hence unreadable. You can use the principal database as a publisher...

    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

    January 6, 2009 at 5:49 am

    #921698

  • RE: Scenarios for Disaster Recovery

    Jeffrey Williams (1/5/2009)

    GilaMonster (1/5/2009)

    Meteor hits the server room.

    Maybe meteors are a bigger threat for you, but for me I am more worried about the aircraft taking off and landing next...

    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

    January 6, 2009 at 5:45 am

    #921693

  • RE: User Defined Function: order by won't work

    Jeff Moden (1/5/2009)

    For certain UPDATEs with a forced scan on the clustered index, it'll work. But for SELECTs it just isn't reliable even if it looks that way 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

    January 6, 2009 at 5:40 am

    #921689

  • RE: LDF file grew unexpectedly

    SQLBOT (1/5/2009)

    Will a restore work for getting the backup into a readable active log?

    No. I tried that once.

    When SQL restores a log backup it replays the transactions recorded against 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

    January 5, 2009 at 1:45 pm

    #921412

  • RE: CXPACKET wait

    I'd try dropping the MAXDOP to 4 and see how it goes. Since it's a warehouse (big queries) I wouldn't take it to 1

    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

    January 5, 2009 at 1:04 pm

    #921384

  • RE: Trans Log Backup takes too long after db recovery model change

    sql_er (1/5/2009)

    Does what you said mean that I am not breaking any chain when I do that

    Conditional yes.

    There are some limitations on point-in-time recovery when there are bulk operations...

    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

    January 5, 2009 at 1:01 pm

    #921380

  • RE: How do you reindex a very large database?

    Jonathan Kehayias (1/5/2009)

    GilaMonster (1/5/2009)

    I had a similar piece of code (for SQL) at my former company. I didn't take the code when I left, of course. I should probably rewrite...

    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

    January 5, 2009 at 12:37 pm

    #921368

  • RE: Trans Log Backup takes too long after db recovery model change

    When you perform a bulk operation under bulk-logged recovery, the details of the changes are not logged, just a record of what pages were logged. When the log is 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

    January 5, 2009 at 12:29 pm

    #921366

Viewing 15 posts - 41,956 through 41,970 (of 49,552 total)