Forum Replies Created

Viewing 15 posts - 36,556 through 36,570 (of 49,552 total)

  • RE: Password Vulnerability in SQL 2005 and 2000

    GSquared (9/4/2009)

    As far as falsifying credentials goes, I'm pretty sure you could get away with using "setuser" for that more easily than you can pull a password out of RAM...

    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

    September 4, 2009 at 3:51 pm

    #1049635

  • RE: Trying to attach MDF from 2000 to 2008. Corrupt LDF message

    cathy.baker (9/4/2009)

    Attach the database using Management Studio, select the .mdf file, highlight the .ldf file and click remove. SQL Server will create a new .ldf file in 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

    September 4, 2009 at 3:45 pm

    #1049632

  • RE: Performance issue

    shine.mm (9/4/2009)

    Hi,

    this is good article, my problem is both the servers are having same configuration ,why is it taking

    more time on production server,there are no other database exist there

    More...

    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

    September 4, 2009 at 1:55 pm

    #1049613

  • RE: logsize

    Paul White (9/4/2009)

    If we have an 8MB single log file, the log records start being written at offset 8192 (skipping the first 8K page) - leaving 8192KB - 8KB =...

    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

    September 4, 2009 at 10:13 am

    #1049499

  • RE: Long running query - out of ideas

    It's exceedingly difficult to say anything useful about a performance problem without the exec plan and/or the table and index definitions and the query. From what I can see, 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

    September 4, 2009 at 9:59 am

    #1049489

  • RE: Long running query - out of ideas

    This article goes over how to save and attach execution plans. There's not enough information in just a screenshot. Most of the important details are in the properties of 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

    September 4, 2009 at 8:36 am

    #1049429

  • RE: Unique Index Causing Slow Read Performance

    TheSQLGuru (9/4/2009)

    1) it doesn't have to be a bug if the optimizer for 2000 derives a suboptimal query plan for a complex query involving 15 tables in a mishmash 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

    September 4, 2009 at 8:28 am

    #1049422

  • RE: Raising Error from Procedure

    I think part of the question is why an explicit transaction for a single update?

    You could remove both the ROLLBACK and the RETURN and not change the behaviour, nothing'll 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

    September 4, 2009 at 8:27 am

    #1049421

  • RE: Strange Process Wait on a small table for a Select statement

    Form that the select is blocked, waiting for a lock. Can't see what table teh lock is requested on (query sys.partitions and sys.tables for the partition_id 72057594308001792 to get 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

    September 4, 2009 at 8:25 am

    #1049417

  • RE: MSDB suspect... cant do anything

    Chirag (9/4/2009)

    This is what i got from the error log - An error occurred during recovery, preventing the database 'msdb' (database ID 4) from restarting. Diagnose the recovery errors 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

    September 4, 2009 at 7:40 am

    #1049359

  • RE: restore database from 2 mdf files

    nitin jain (9/4/2009)

    i hav one database backup file which contain 2 mdf and 2 ldf file. now i want to restore it with 1 mdf & 1 ldf file, means...

    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

    September 4, 2009 at 6:56 am

    #1049336

  • RE: MSDB suspect... cant do anything

    Ok, not good.

    Firstly, what did the SQL error log say about why MSDB was marked suspect? There would have been a reason in there.

    If you remove the traceflag, does 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

    September 4, 2009 at 6:55 am

    #1049335

  • RE: Retrieving a nth highest row

    You can use Row_Number.

    If you want more specific help, please post table definitions, sample data and desired output. Read this to see the best way to post this 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

    September 4, 2009 at 4:40 am

    #1049288

  • RE: Performance issue

    If you want us to help optimise, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    PageIOLatch is typically a sign of IO contention. The IO subsystem cannot...

    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

    September 4, 2009 at 1:11 am

    #1049233

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/3/2009)

    He was probably using sp_Space used or some code that looks at sysIndexes and DBCC UPDATEUSAGE fixes some sins that occur there.

    The code he initially posted (before editing...

    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

    September 4, 2009 at 1:08 am

    #1049232

Viewing 15 posts - 36,556 through 36,570 (of 49,552 total)