Forum Replies Created

Viewing 15 posts - 3,856 through 3,870 (of 19,560 total)

  • RE: I need to deduplicate a 800 million row table (100 million rows have duplicates)

    I will go ahead and give you one possible solution that I have been holding back on because I feel it would be a huge resource hog with the number...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 2:40 pm

    #1686786

  • RE: Strange behaviour of some jobs ...

    Have you looked over the job owners, or server utilization at the time that some of these jobs fail to start.

    And they definitely do not start, right?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 2:36 pm

    #1686782

  • RE: Strange behaviour of some jobs ...

    Does this affect all 40 jobs or just some of the jobs?

    Have you noticed any messages in the server logs (not agent logs)?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 2:06 pm

    #1686772

  • RE: Server Migration

    Is that on the 2000 or the 2008 instance that you see the null database name?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 2:01 pm

    #1686769

  • RE: I need to deduplicate a 800 million row table (100 million rows have duplicates)

    VoldemarG (2/6/2014)

    << I wonder if there is anyway whatsoever to distinguish these dupes from each other.>> well it is NOT KNOWN.

    IT will take a while till we complete the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 1:58 pm

    #1686767

  • RE: I need to deduplicate a 800 million row table (100 million rows have duplicates)

    Well, if you could answer the last part of my previous post, then there may be other possibilities that would be acceptable and not take excessive resources.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 11:13 am

    #1686703

  • RE: OS Disk Capacity Information

    Robert klimes (2/6/2014)

    try this out

    $ds = New-Object system.Data.DataSet

    $ds = Get-WMIObject Win32_LogicalDisk -filter "DriveType=3" -computer (Get-Content c:\computers.txt) | Select SystemName,DeviceID,VolumeName,@{Name="size"; Expression={"{0:N1}" -f($_.size/1gb)}},@{Name="freespace";Expression={"{0:N1}" -f($_.freespace/1gb)}}

    foreach ($d in $ds)

    {

    $systemname = $d.systemname

    $deviceID = $d.DeviceID

    $volumename...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 11:10 am

    #1686701

  • RE: Query Help : pull Store Procedure name from Command

    Luis Cazares (2/6/2014)

    I'm pleasantly surprised, too. I wonder if this would stop people from improving working solutions.

    Possibly but I would wager that it won't.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 10:43 am

    #1686692

  • RE: Query Help : pull Store Procedure name from Command

    Lowell (2/6/2014)

    wah.... this is the first time i saw this new highlighting and "this worked for the OP";

    cute ehnacement!

    Wow - ditto. Never seen that before and it is definitely...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 10:24 am

    #1686686

  • RE: I need to deduplicate a 800 million row table (100 million rows have duplicates)

    Sean Lange (2/6/2014)

    Ouch. An 800 million row heap?

    Given that amount of data and that performance is going to be painful here is one idea.

    Do a select distinct into a new...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 9:58 am

    #1686676

  • RE: Number of times a function is accessed.

    ben.brugman (2/6/2014)

    SQLRNNR (2/6/2014)

    You can try this code that may get some execution counts for the function you are investigating.

    Thanks for the script, in the script I noticed a number of...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 9:39 am

    #1686671

  • RE: Sending a Variable Number of Elements in a Parameter

    Thanks for the article.

    I agree with Phil that the Title of the article seemed to be unclear in the intended topic.

    I think the article would also benefit from better formatting....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 8:48 am

    #1686648

  • RE: Today's Random Word!

    Ed Wagner (2/6/2014)

    BWFC (2/6/2014)

    Sean Lange (2/6/2014)

    Ed Wagner (2/6/2014)

    SQLRNNR (2/6/2014)

    BWFC (2/6/2014)

    SQLRNNR (2/6/2014)

    Kurt W. Zimmerman (2/6/2014)

    BWFC (2/6/2014)

    Ed Wagner (2/6/2014)

    L' Eomot Inversé (2/6/2014)

    BWFC (2/6/2014)

    Animated

    Cartoon

    Bugs

    Bunny

    Fudd (Elmer J)

    Wabbit

    Won...wabbit, won wabbit, won, won, won 🙂

    Kill the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 8:39 am

    #1686642

  • RE: Number of times a function is accessed.

    You can try this code that may get some execution counts for the function you are investigating.

    /* set the code text to be searched on with the variable @CodeName

    */

    DECLARE @CodeName...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 8:36 am

    #1686639

  • RE: Today's Random Word!

    BWFC (2/6/2014)

    SQLRNNR (2/6/2014)

    Kurt W. Zimmerman (2/6/2014)

    BWFC (2/6/2014)

    Ed Wagner (2/6/2014)

    L' Eomot Inversé (2/6/2014)

    BWFC (2/6/2014)

    Animated

    Cartoon

    Bugs

    Bunny

    Fudd (Elmer J)

    Wabbit

    Won...wabbit, won wabbit, won, won, won 🙂

    Kill the wabbit

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 6, 2014 at 8:01 am

    #1686618

Viewing 15 posts - 3,856 through 3,870 (of 19,560 total)