Forum Replies Created

Viewing 15 posts - 26,941 through 26,955 (of 49,552 total)

  • RE: Certification Resources

    chetanr.jain (3/30/2011)

    I have apperaed for the same exam in last oct and got 980.

    i have gone through the Self study guide of Microsoft for 70-432. Read out that book fully.

    There...

    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

    March 30, 2011 at 7:49 am

    #1305445

  • RE: affinity mask value for 8 cpu heavily loaded sqlserver 2005 Ent

    Then tell the dev team to optimise their queries

    I've seen scenarios where performance is worse on servers with more CPUs. Was because the queries were badly written and could parallel...

    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

    March 30, 2011 at 7:46 am

    #1305442

  • RE: Lock on a table

    If it's critically urgent, hire a consultant. Please remember that we're all unpaid volunteers here, we all have our own jobs, our own problems.

    Also, you haven't posted the query, 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

    March 30, 2011 at 7:43 am

    #1305440

  • RE: Lock on a table

    It uploaded correctly, but it's a plan for nothing.

    <?xml version="1.0" encoding="utf-16"?>

    <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.0" Build="9.00.4053.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

    <BatchSequence>

    <Batch>

    <Statements>

    ...

    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

    March 30, 2011 at 7:01 am

    #1305411

  • RE: SQL Server shutdown - how to re-start server

    M.Kahn (3/30/2011)

    In my case is, backup is taking care of 3rd section, which i dont have any idea of how they taking back stuff. And where back is, neither i...

    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

    March 30, 2011 at 6:56 am

    #1305407

  • RE: Lock on a table

    Query and table and index definitions as well please

    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

    March 30, 2011 at 6:09 am

    #1305379

  • RE: Facing SQL server 2005 Database restore issues

    Restore the full backup as a new database. Restore WITH NORECOVERY

    Restore the 10:30 transaction log backup WITH NORECOVERY

    Restore the 11:30 log backup WITH STOPAT 10:59

    If the database is still marked...

    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

    March 30, 2011 at 6:03 am

    #1305376

  • RE: Table Design -> DataTypes for identifier values

    Mikey01 (3/30/2011)

    what i was hoping to implement was an approach which would replace this composite version id (IDENTITY+DATETIME) with a single id value

    Why?

    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

    March 30, 2011 at 5:33 am

    #1305359

  • RE: sys.dm_db_index_physical_stats Query

    Why did you omit the AS TableName? It's just a column alias.

    What happened is that I changed the table aliases (as a and b were meaningless) and forgot to change...

    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

    March 30, 2011 at 5:32 am

    #1305358

  • RE: How can I create and export a XML file based on XSDs in SSIS

    Please don't cross post.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1086104-148-1.aspx

    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

    March 30, 2011 at 5:21 am

    #1305352

  • RE: How to create a XML file based on XSDs in SSIS?

    Ignore, meant to post that in the other one.

    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

    March 30, 2011 at 5:21 am

    #1305351

  • RE: Poor database design

    Sean Pearce (3/30/2011)

    GilaMonster (3/30/2011)

    I suspect that you may need to get a specialist in (on-site) for a couple of days. I can recommend some good people here. Sounds like 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

    March 30, 2011 at 5:20 am

    #1305350

  • RE: Table Design -> DataTypes for identifier values

    Steve Jones - SSC Editor (3/30/2011)

    I also fail to see why an identity in the primary table doesn't work. In the audit table, would it not be the identity plus...

    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

    March 30, 2011 at 5:12 am

    #1305344

  • RE: sys.dm_db_index_physical_stats Query

    Pass NULL as the objectID to get all tables. That's what the objectID function will be returning when you specify %%, unless you happen to have a table called %%....

    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

    March 30, 2011 at 5:08 am

    #1305343

  • RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

    vamshikrishnaeee (3/30/2011)

    1.Can't we use differential backup in between instead of restoring all the logbackups?

    You can use a diff, providing that it doesn't contain the corrupted pages. If it was taken...

    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

    March 30, 2011 at 5:02 am

    #1305336

Viewing 15 posts - 26,941 through 26,955 (of 49,552 total)