Forum Replies Created

Viewing 15 posts - 31,666 through 31,680 (of 49,552 total)

  • RE: IF EXISTS statement very slow

    I suspect it's something like 'short-circuiting' in a query's where clause. It may happen, but cannot be depended upon to always happen, not like C++ where as soon as 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

    July 23, 2010 at 1:46 pm

    #1197738

  • RE: Missing Indexes in SQL Server 2005

    It's there in 2008.

    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

    July 23, 2010 at 1:40 pm

    #1197731

  • RE: Are DB snapshots read-only or can they be used for restoring a database fully?

    PaulB-TheOneAndOnly (7/23/2010)

    A snapshot is taken by splitting a mirrored storage device - like EMC BCV.

    SQL Server snapshots a operationally identical to standard SQL Server backups but you do not have...

    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

    July 23, 2010 at 1:26 pm

    #1197725

  • RE: Missing Indexes in SQL Server 2005

    alen teplitsky (7/23/2010)

    bob.taylor (9/16/2008)

    And in SQL Server 2008, it gets even easier. When you display an actual execution plan in SQL Server Management Studio query windows, you will receive 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

    July 23, 2010 at 1:17 pm

    #1197716

  • RE: IF EXISTS statement very slow

    SQL doesn't short-circuit ORs or ANDs in an 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

    July 23, 2010 at 10:14 am

    #1197600

  • RE: IF EXISTS statement very slow

    There are a lot of 'funnies' around queries over linked server. I often recommend using OpenQuery instead of 4-part naming, and specifying exactly what should come back from the linked...

    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

    July 23, 2010 at 9:15 am

    #1197569

  • RE: No records in db after importing a 60GB db over the network

    ss_nl (7/23/2010)

    - Is there a way to 'repair' the imported db? Since the data seems physically there on the hdd, and the row importing process went till 100%

    It's not broken....

    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

    July 23, 2010 at 8:55 am

    #1197560

  • RE: I Can't Understand Why This is Slow

    I don't fully understand your explanation. Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Are you asking why it's slow, or how to get it fast?

    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

    July 23, 2010 at 8:23 am

    #1197542

  • RE: Which is the primary key of given table

    malleswarareddy_m (7/22/2010)

    please provide design and structure of the table.

    What table?

    May I suggest you hit google and search for a good primer on Normalisation?

    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

    July 23, 2010 at 7:57 am

    #1197521

  • RE: MS SQL 2005 Datafiles no Autogrowth [5128] Write to sparse file

    mulle-78 (7/23/2010)

    Hi and thx for the explanation. But what is the risk of option TABLOCK. Are other processes blocked by accessing the currently checked areas in the DB?

    From BoL:

    TABLOCK

    Causes...

    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

    July 23, 2010 at 7:55 am

    #1197519

  • RE: How to revert recovered database to previous in recovery mode?

    If you need to have users using the secondary then you'll need to recover it.

    Two points:

    1) Once you've finished the disaster recovery, you'll need to recreate the secondary. There's no...

    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

    July 23, 2010 at 5:39 am

    #1197438

  • RE: MS SQL 2005 Datafiles no Autogrowth [5128] Write to sparse file

    It's not an error about space in the file. There was a database integrity job run and there wasn't space for the CheckDB to create the snapshot that it needs...

    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

    July 23, 2010 at 5:36 am

    #1197437

  • RE: How to revert recovered database to previous in recovery mode?

    Once the database has been recovered (a restore was run WITH RECOVERY), you'll need to start again from the full backup to be able to restore further log backup.

    Why 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

    July 23, 2010 at 5:32 am

    #1197435

  • RE: Dirty Reads

    Grant Fritchey (7/23/2010)

    sreedhar1.m (7/23/2010)

    Do not use row and table locks.

    A couple of questions. How do you go about not using locks? Aren't they pretty much required by the system when...

    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

    July 23, 2010 at 5:31 am

    #1197434

  • RE: General pointers on reading wait statistics

    Please post new questions in a new thread.

    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

    July 23, 2010 at 2:35 am

    #1197381

Viewing 15 posts - 31,666 through 31,680 (of 49,552 total)