Forum Replies Created

Viewing 15 posts - 23,881 through 23,895 (of 49,552 total)

  • RE: Need information regarding Indexes

    Not enough information.

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 26, 2011 at 9:53 am

    #1373902

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/26/2011)

    skrilla99 (8/26/2011)

    Grant Fritchey (8/26/2011)

    Need the advice of the Thread.

    Putting together an article on the most common backup errors (apart from not having one) and how to avoid them....

    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 26, 2011 at 9:47 am

    #1373896

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/26/2011)

    Gotta ask though, do we really think that's as big a deal as we used to? I only ask because I've been running backups for years to "local"...

    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 26, 2011 at 9:45 am

    #1373893

  • RE: Backup and old file delete GOTCHAs!

    Depends on business requirements, available maintenance time, available disk space, etc.

    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 26, 2011 at 9:04 am

    #1373835

  • RE: Having MDF and LDF reside on save disk

    Performance and recoverability.

    With the log file on a separate drive, if the mdf drive fails you can still back up the tail of the log so that you lose 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

    August 26, 2011 at 8:53 am

    #1373818

  • RE: SQL 2008 R2 msdb 95.66% frag

    The tables in MSDB aren't system 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 26, 2011 at 8:02 am

    #1373779

  • RE: What happens if the Domain Controller is down?

    The DC is the primary DNS, the ADSL modem is a a secondary DNS, and the SQL Server is local anyway.

    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 26, 2011 at 7:58 am

    #1373776

  • RE: Statistics are not updated in clustred index

    ananda.murugesan (8/26/2011)

    Understood about the heap index statistices, Mr. Grant told me Heap index does not have maintain statistices.

    Heaps aren't indexes. It's not that they don't have to maintain statistics, it'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

    August 26, 2011 at 7:28 am

    #1373753

  • RE: NoLock Hint on a Read-only database

    Probably no benefits, but the same risks of incorrect data. The replication is changing the DB, so you can get all the missed-rows, duplicate-rows that you would in a normal...

    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 26, 2011 at 6:18 am

    #1373706

  • RE: How to Use LIKE with Table variable

    I tested mine, it runs fine.

    Post the exact code that is failing for you.

    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 26, 2011 at 6:17 am

    #1373704

  • RE: Statistics are not updated in clustred index

    A clustered index (or any other index for that matter) shows null for the stats date if there are no rows in the table, or if the index is disabled.

    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 26, 2011 at 6:02 am

    #1373695

  • RE: How to Use LIKE with Table variable

    Your code was a mess of string and quote-related errors.

    With the table you gave me, this works.

    Declare @testquery varchar(1000),

    @test-2 varchar(200)

    set @test-2 = '*Ma.01.01'

    select @testquery = 'select TestCode, TestId from [public]...

    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 26, 2011 at 6:00 am

    #1373693

  • RE: Dead lock problem.

    Repeatable read and serialisable have different behaviours. You should read up on what they do and use the one that's appropriate.

    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 26, 2011 at 5:54 am

    #1373689

  • RE: NoLock Hint on a Read-only database

    In a read-only database, no locks will be taken ever. SQL doesn't need to, it knows nothing can ever change data (it's defined read-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

    August 26, 2011 at 5:54 am

    #1373688

  • RE: How to Use LIKE with Table variable

    Test is not a table variable. It's a scalar variable, a 200 character varchar.

    Declare @testquery varchar(1000),

    @test-2 varchar(200)

    set @test-2 = '*Ma.01.01'

    Can you post the CREATE TABLE statement for the table public...

    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 26, 2011 at 5:52 am

    #1373684

Viewing 15 posts - 23,881 through 23,895 (of 49,552 total)