Forum Replies Created

Viewing 15 posts - 7,846 through 7,860 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/12/2014)

    GilaMonster (9/12/2014)

    Lynn Pettis (9/12/2014)

    SQLRNNR (9/12/2014)

    GilaMonster (9/12/2014)

    Um... http://www.sqlservercentral.com/Forums/Topic1612868-3411-1.aspx ????

    I invoke the barge pole rule.

    2nd that. Does the motion pass??

    Motion passes with no objections.

    Without objection, it is so ordered....

    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 12, 2014 at 11:56 am

    #1745167

  • RE: Log Shipping destination stuck on "restoring..."

    Lempster (9/12/2014)

    cafescott (9/12/2014)

    Hey GilaMonster, I have set up Transactional Replication and I am totally loving it! It works like a champ. Thanks for the excellent suggestion. 😎

    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

    September 12, 2014 at 11:53 am

    #1745166

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/12/2014)

    SQLRNNR (9/12/2014)

    GilaMonster (9/12/2014)

    Um... http://www.sqlservercentral.com/Forums/Topic1612868-3411-1.aspx ????

    I invoke the barge pole rule.

    2nd that. Does the motion pass??

    Motion passes with no objections.

    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 12, 2014 at 9:37 am

    #1745131

  • RE: Storing temporary data within a select statement

    Should be (and btw, that's not a temp table. It's a permanent table)

    WITH TempCharges AS (

    SELECT ChargeRef, PolicyRef, LastChargedDate,

    CASE

    WHEN Freq = 1 THEN 12

    WHEN Freq = 2 THEN...

    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 12, 2014 at 8:14 am

    #1745098

  • RE: How is data stored or indexed in Clustered and nonclustered Columnstore Index?

    Columnstores aren't in-memory structures. They're disk-based.

    Have you read all the whitepapers on columnstore? If not, hit google, a search for whitepaper columnstore finds 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

    September 12, 2014 at 6:03 am

    #1745051

  • RE: Are the posted questions getting worse?

    TomThomson (9/12/2014)

    GilaMonster (9/12/2014)

    Um... http://www.sqlservercentral.com/Forums/Topic1612868-3411-1.aspx ????

    Not fair Gail, surely on topic comments are not allowed in the thread. 🙂

    I'm sorry. I will schedule penance for the afternoon (documentation)

    Ed Wagner (9/12/2014)

    And just...

    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 12, 2014 at 6:01 am

    #1745050

  • RE: Performance issue in store procedure

    Please post table definitions, index definitions and execution plan.

    Is that SELECT * really necessary or do you just need a subset of the columns?

    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 12, 2014 at 6:00 am

    #1745049

  • RE: Truncate table query

    Koen Verbeeck (9/12/2014)

    Replication doesn't need triggers

    Merge 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

    September 12, 2014 at 5:50 am

    #1745043

  • RE: Truncate table query

    Iulian -207023 (9/12/2014)

    I found this, on msdn, it must be on a different context and that would explain it or it can be a typo as well, who knows...

    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 12, 2014 at 5:41 am

    #1745038

  • RE: Clear Procedure Cache

    Tell them that neither are required to test performance of their procedures.

    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 12, 2014 at 5:37 am

    #1745036

  • RE: Clear Procedure Cache

    EXEC sp_recompile 'ProcedureName'

    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 12, 2014 at 4:34 am

    #1745022

  • RE: Truncate table query

    Meow Now (9/11/2014)

    I was asked this very thing in an interview a while back. Except, they wanted to know if a TRUNCATE was fully or minimally logged. While I mentioned...

    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 12, 2014 at 4:33 am

    #1745020

  • RE: Are the posted questions getting worse?

    Um... http://www.sqlservercentral.com/Forums/Topic1612868-3411-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

    September 12, 2014 at 2:37 am

    #1744997

  • RE: Max and Min Memory setting are the same.

    It means that SQL cannot respond to OS requests to reduce its memory usage and hence, if the OS comes under memory pressure may result in SQL being swapped 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 12, 2014 at 2:24 am

    #1744991

  • RE: Combine 2 selects

    That's fairly easy

    SELECT e.Data AS ID, y.Data AS FiscalYear

    FROM dbo.Split(@EmployeeID, ',') e CROSS JOIN dbo.Split(@fiscalyear, ',') y

    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 11, 2014 at 2:46 pm

    #1744933

Viewing 15 posts - 7,846 through 7,860 (of 49,552 total)