Forum Replies Created

Viewing 15 posts - 35,476 through 35,490 (of 49,552 total)

  • RE: Query of INNER Join

    Not in an inner join. In an outer they may produce different results

    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

    December 5, 2009 at 4:18 am

    #1088141

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/4/2009)

    Alvin Ramard (12/4/2009)

    Bru Medishetty (12/4/2009)

    I am not sure what did he mean by this

    Atul DBA (12/4/2009)

    I am not sure about you OS.

    Does SQL Server supports any...

    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

    December 4, 2009 at 10:54 pm

    #1088120

  • RE: Dropping a cached plan?

    Do you really need dynamic SQL? Your question indicated there were two possibilities - the detailed and the high level report. If that's the case, use if - else with...

    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

    December 4, 2009 at 10:53 pm

    #1088119

  • RE: URGENT: Question about merge and hash JOIN

    Why is this urgent?

    http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/

    http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/

    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

    December 4, 2009 at 10:51 pm

    #1088118

  • RE: allocating memory for execution plan cache

    bodhilove (12/4/2009)

    would decreasing my buffer cache allow more room for plan cache?

    As I said, the buffer cache (usually called the buffer pool) is divided into the data cache and 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

    December 4, 2009 at 10:35 pm

    #1088113

  • RE: Performance optimization on huge data

    arr.nagaraj (12/4/2009)

    So i felt it should be

    NCIndex key + Included column( which includes cluster) + cluster key

    SQL's not stupid enough to store a column...

    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

    December 4, 2009 at 10:28 pm

    #1088112

  • RE: DBCC CHECKDB: Fast / Slow?

    Got any options checked in the maintenance plan?

    What's the server (and IO) load at the two times?

    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

    December 4, 2009 at 2:21 pm

    #1088048

  • RE: Are the posted questions getting worse?

    Now that I read it again, it's a 2-for-1.

    As you have Replication setup, you can failover to other server database and then restart the service.

    When did replication gain a failover...

    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

    December 4, 2009 at 2:16 pm

    #1088045

  • RE: Dynamic where clause

    Dave Mason (12/4/2009)

    [font="Arial"]I prefer to avoid the IF/ELSE scenario for queries. Eventually, you'll have to "fix it" in two places. Plus, you open up the possibility of two...

    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

    December 4, 2009 at 1:59 pm

    #1088042

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/4/2009)

    Gus also replied to the thread, still no good.

    Not helped by someone who doesn't appear to know the difference between an operating system kill process and a SQL...

    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

    December 4, 2009 at 1:27 pm

    #1088024

  • RE: Cancelled transaction log backup rolling back???

    Atul DBA (12/4/2009)

    I am not sure about you OS. You can use the /F option with KILL command to make it forcefully kill the process. If you have TaskKill utility...

    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

    December 4, 2009 at 1:23 pm

    #1088017

  • RE: SQL Server at the system level

    Dan H. (12/4/2009)

    I've seen excerpts of Kalen's book (it does look excellent), but does it relate to SQL Server 2005?

    The title's actually Inside SQL Server 2005: The Storage Engine. 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

    December 4, 2009 at 1:09 pm

    #1088009

  • RE: Full backup error

    Is the non-recoverable IO error on the drive with the data file or the drive that you're backing up to? If it's the data drive, you got lot bigger problems...

    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

    December 4, 2009 at 1:01 pm

    #1088004

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/4/2009)

    Hey guys, this user needs help in solving the issue. It's been 2 days since he posted and no good.

    http://www.sqlservercentral.com/Forums/Topic827900-357-1.aspx#bm827908

    I've pinged Paul R and asked if he'll...

    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

    December 4, 2009 at 12:55 pm

    #1087995

  • RE: Clarification on results of using option(maxdop 1)

    GSquared (12/4/2009)

    Would be better in SQL 2005/2008, since you could use the Include clause for most of the columns, but in SQL 2000, you may or may not get what...

    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

    December 4, 2009 at 12:49 pm

    #1087985

Viewing 15 posts - 35,476 through 35,490 (of 49,552 total)