Forum Replies Created

Viewing 15 posts - 22,261 through 22,275 (of 49,552 total)

  • RE: view time out

    What exactly are you doing that generates that? If you're using the view designer, stop doing so, it's a bug-ridden mess.

    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

    November 13, 2011 at 1:38 pm

    #1406860

  • RE: How to Eliminate loop and use set based approach?

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1204802-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

    November 13, 2011 at 1:37 pm

    #1406859

  • RE: Deadlocks

    BSavoie (11/12/2011)

    Now I'm turning on these:DBCC TRACEON (3605,1204,1222,-1)

    No need for 3605. That just redirects certain output (like DBCC page) to the error log. Nothing to do with deadlocks.

    Don't enable 1204...

    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

    November 13, 2011 at 10:46 am

    #1406850

  • RE: If you passed exam 70-450

    JakeSA (11/13/2011)

    but not really so in Development unless you are a hard-core programmer (which you cannot teach yourself to be because good programmer is more in your genes rather than...

    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

    November 13, 2011 at 10:45 am

    #1406847

  • RE: Unable to upgrade from 10.2.4000 to 2008 R2 emergency

    If it's an urgent, major, critical issue, I suggest you open a case with Microsoft CSS.

    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

    November 13, 2011 at 4:51 am

    #1406807

  • RE: Help solve a mystery regarding assingnment of variable to output parameter.

    It's not about severities (though anything above 19 will do that). It's about where the error is thrown from. Any form of parse/bind error (object does not exist, column does...

    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

    November 13, 2011 at 4:33 am

    #1406804

  • RE: Unable to upgrade from 10.2.4000 to 2008 R2 emergency

    Huh???

    When run the installer, are you selecting at least one database engine on the installation selection screen?

    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

    November 13, 2011 at 4:31 am

    #1406803

  • RE: Help solve a mystery regarding assingnment of variable to output parameter.

    There's all sorts of deferred name resolution and late-binding and recompiles going on so, yes, the first will actually execute, but the bottom line is that the first is 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

    November 12, 2011 at 3:51 pm

    #1406764

  • RE: Partial Restore - Does it really need to start with restore of the PRIMARY FG?

    What about just RESTORE DATABASE <dbname> WITH RECOVERY ?

    I know that's what you run after a page restore if the last log restore isn't run WITH RECOVERY.

    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

    November 12, 2011 at 3:49 pm

    #1406763

  • RE: Help solve a mystery regarding assingnment of variable to output parameter.

    Peter Brinkhaus (11/12/2011)

    I'm probably not using the correct terminology, but let's give it a shot. To summarize, procedure Test1 contains a compile-time error (unknown table), while procedure Test2 contains 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

    November 12, 2011 at 2:04 pm

    #1406758

  • RE: Partial Restore - Does it really need to start with restore of the PRIMARY FG?

    Which statement fails? The restore of the filegroup or the restore of the DB with recovery?

    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

    November 12, 2011 at 1:59 pm

    #1406756

  • RE: Memory Utilization is very low 13.8 GB out of 20 GB

    If it's causing blocking, it's probably not tuned.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    or 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

    November 12, 2011 at 1:57 pm

    #1406755

  • RE: Memory Utilization is very low 13.8 GB out of 20 GB

    Alone (11/12/2011)

    I am not sure whether there in any memory issue but i can see SQL only using 13.8 GB memory constantly but i have configured max memory 20GB.

    Ok, again,...

    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

    November 12, 2011 at 12:43 pm

    #1406747

  • RE: Memory Utilization is very low 13.8 GB out of 20 GB

    The only 64-bit version of SQL 2000 is the Itanium, and I doubt you have one of those lying around, or want one for that matter.

    Is there actually a problem...

    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

    November 12, 2011 at 12:28 pm

    #1406741

  • RE: tempdb 35 GB using by query statement- Help

    Widen this index: IX_CMTS_IPADD nonclustered located on PRIMARY CMMAC. Add cpip as a second column.

    Widen this index: IX_CMTS_IPADD_D nonclustered located on PRIMARY CMMAC. Add CPEIP, CPEMAC

    Not sure if CMMAC is...

    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

    November 12, 2011 at 6:10 am

    #1406693

Viewing 15 posts - 22,261 through 22,275 (of 49,552 total)