Forum Replies Created

Viewing 15 posts - 14,596 through 14,610 (of 49,552 total)

  • RE: database restore 2008 r2

    sathiyan00 (1/28/2013)

    because for past 2 hours its showing 0%.

    Creating and zeroing out the database files.

    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

    January 28, 2013 at 6:01 am

    #1581578

  • RE: SQL SERVER CPU Usage 100 % even at no traffic time

    anthony.green (1/28/2013)

    purushottam2 (1/28/2013)

    it is charging few dollars, i have to take approvals from client.

    I take it you missed the "Get your free eBook download here." link on the webpage then?

    and...

    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

    January 28, 2013 at 5:38 am

    #1581567

  • RE: Stored procedure very slow execution

    Grant Fritchey (1/28/2013)

    You can set a traceflag, 2371, to change this behavior. Here are the details.

    For SQL 2008 R2 and above only unfortunately.

    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

    January 28, 2013 at 5:26 am

    #1581562

  • RE: Delete with TABLOCK

    SQL* (1/28/2013)

    From the above statement from MSDN, if we use TABLOCK in the DELETE statement then the allocated pages will be deallocated.

    If the table is a heap.

    So the above statement...

    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

    January 28, 2013 at 5:10 am

    #1581553

  • RE: SQL SERVER CPU Usage 100 % even at no traffic time

    Did you read the book chapter I recommended?

    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

    January 28, 2013 at 4:56 am

    #1581549

  • RE: IN or LEFT OUTER JOIN which is better ?

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    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

    January 28, 2013 at 2:22 am

    #1581478

  • RE: Can lots of User Connections cause high CPU use

    Please note: 4 year old thread.

    Also, ad-hoc queries and plan cache has nothing to do with sleeping connections. Sleeping connections are ones waiting for input from the application, they are...

    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

    January 28, 2013 at 2:16 am

    #1581477

  • RE: Sleeping Process...

    Please note: 5 year old thread.

    Also, ad-hoc queries and plan cache has nothing to do with sleeping connections.

    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

    January 28, 2013 at 2:15 am

    #1581475

  • RE: Sleeping Processes

    Please note: 3 year old thread.

    Also, ad-hoc queries and plan cache has nothing to do with sleeping connections.

    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

    January 28, 2013 at 2:09 am

    #1581473

  • RE: connections sleeping

    Angel DBA Mex (6/5/2007)

    could you help me how clearing this proccesses, maybe with a period of time, thank a lot

    Why?

    A sleeping connection is not doing anything, it's waiting for some...

    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

    January 28, 2013 at 2:05 am

    #1581470

  • RE: connections sleeping

    Rahim-441309 (1/28/2013)

    U can use

    DBCC FREEPOCCACHE Command to clear them regularly or

    create a job that will do late in the night

    Errr... no. FreeProcCache does nothing 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

    January 28, 2013 at 2:03 am

    #1581467

  • RE: Deattach/Attach actions made CPU utilization 100 %

    You need to manage that log better

    Please read through this - Managing Transaction Logs[/url]

    Do not ever delete a database's transaction log. SQL cannot always recreate the log, only if 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

    January 28, 2013 at 2:01 am

    #1581465

  • RE: SQL SERVER CPU Usage 100 % even at no traffic time

    Next step would be to identify what in SQL Server is using the CPU.

    See chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    January 28, 2013 at 1:59 am

    #1581463

  • RE: Strored procedure returns different row counts

    Alex koranteng (1/27/2013)

    The sproc is giving different row counts between the development and test servers.

    The data is different or the code is different. Can't really say much more without...

    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

    January 27, 2013 at 7:05 am

    #1581370

  • RE: ERROR SETTING FK

    There's a RiderNo in trip details that does not have a matching entry in Riders

    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

    January 26, 2013 at 10:43 am

    #1581307

Viewing 15 posts - 14,596 through 14,610 (of 49,552 total)