Forum Replies Created

Viewing 15 posts - 15,616 through 15,630 (of 49,552 total)

  • RE: Stop sql serive also stops another service

    While you can, I don't recommend that you should. If the service has been set as dependant on SQL Server, there's probably a good reason. Removing that dependency may cause...

    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 17, 2012 at 12:03 pm

    #1560030

  • RE: Restore 1.9T on SQL 2008

    _Beetlejuice (11/17/2012)

    This query will tell you how long the restore will take in seconds:

    SELECT Percent_Complete, Estimated_Completion_Time / 1000 as [CompletionTimeSeconds]

    FROM sys.dm_exec_requests

    WHERE Command LIKE '%RESTORE%'

    It'll tell you how long the restore...

    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 17, 2012 at 11:57 am

    #1560028

  • RE: Adding a new column to a table. Best approach

    bugg (11/17/2012)

    I must ask though why does SSMS throw an error saying you should drop and recreate? Unless you uncheck the 'prevent saving changes that require a table recreate"?

    Because...

    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 17, 2012 at 11:52 am

    #1560027

  • RE: query taking long time for execution inthis case what should i do

    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/

    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 17, 2012 at 11:15 am

    #1560022

  • RE: Mirroring configure HA and DR

    No, you cannot set up log shipping from the secondary, no you do not need to remove mirroring.

    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 17, 2012 at 6:03 am

    #1559997

  • RE: Mirroring configure HA and DR

    With mirroring there can only be a single mirror database. You'll need to either use log shipping to the secondary datacentre, upgrade to SQL 2012 and use availability groups or...

    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 17, 2012 at 4:43 am

    #1559992

  • RE: table valued function

    Sarsoura (11/16/2012)

    Can you provide me with a more efficient splitter

    capnhector (11/16/2012)

    i would suggest looking at DelimitedSplit8k for this, the link is in my signature or you can find it...

    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 17, 2012 at 4:39 am

    #1559990

  • RE: 64-bit vs 32-bit SQL 2008 and development

    SQLCrazyCertified (11/16/2012)

    I am little confused, I thought you won't be able to install 64 bit SQL into 32 bit OS.

    Correct, that's not possible.

    Correct me if I am wrong, what am...

    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 17, 2012 at 4:37 am

    #1559989

  • RE: high internal Catch Latch

    Those are IO-related waits. You might want to take a look at your IO subsystem, make sure you're not putting more demand than it can handle.

    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 16, 2012 at 1:48 pm

    #1559940

  • RE: table valued function

    Two points.

    There are far more efficient split functions around than one using a loop, multi-statement table-valued functions can have rather unpleasant performance implications.

    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 16, 2012 at 9:46 am

    #1559861

  • RE: 64-bit vs 32-bit SQL 2008 and development

    Executable files are 32-bit or 64-bit, that's if. Scripts are not, databases are not, backups are not.

    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 16, 2012 at 9:43 am

    #1559860

  • RE: Which is best way

    thava (11/16/2012)

    this is what i exactly told i think this is enough

    ALTER PROC TestProc (@id INT, @aName VARCHAR(10))

    AS

    BEGIN

    SELECT * FROM TableA

    ...

    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 16, 2012 at 8:48 am

    #1559841

  • RE: Backups changes table stats ?

    No. A restore will recreate the DB exactly as it was at the time of backup.

    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 16, 2012 at 6:57 am

    #1559792

  • RE: How to solve this issue sqlserver.exe process is taking so much of memory [70%]

    naga.rohitkumar (11/16/2012)

    ya anthony is asking me the details but frankly saying i dont know how to check

    Exactly the same way you checked max server memory.

    You do know how 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

    November 16, 2012 at 5:39 am

    #1559749

  • RE: New Indexes - merging suggestions

    MartJ (11/16/2012)

    Thank you for the prompt reply. If I were to do that, just so I understand for the future, which order would I put the second two columns in...

    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 16, 2012 at 5:27 am

    #1559744

Viewing 15 posts - 15,616 through 15,630 (of 49,552 total)