Forum Replies Created

Viewing 15 posts - 16,756 through 16,770 (of 49,552 total)

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    If you're not willing to give details (such as what and how you 'deleted' stuff from Control Panel), what installer you ran, what options you selected, the exact dialog 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

    September 6, 2012 at 1:45 pm

    #1534738

  • RE: Steps for installing a SQL Server 2005 Cluster

    Please note: 4 year old thread.

    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 6, 2012 at 1:29 pm

    #1534727

  • RE: Performance issue

    Table definitions, index definitions and execution plan please, as per the article that Sean referenced.

    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 6, 2012 at 9:55 am

    #1534597

  • RE: Database analisys

    For performance, maybe start here:

    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

    September 6, 2012 at 9:53 am

    #1534594

  • RE: SQL Server Clustering

    Did you try a google search?

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

    #1534475

  • RE: Release Total Server Memory in SQL 2008

    Releasing memory won't make things fast. It's more likely to make things slow.

    SQL uses a lot of memory, that is how it works. It does not run slowly when 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

    September 6, 2012 at 7:54 am

    #1534473

  • RE: Shrink DB

    Before you do anything else...

    GilaMonster (9/6/2012)

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

    It's not a space issue, it's a complete lack of log management.

    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 6, 2012 at 5:58 am

    #1534410

  • RE: Shrink DB

    whizkidgps (9/6/2012)

    We have not taken up the log file back up or truncation of log file so far.

    We just leave the database as it is since it was created...:crying:

    You definitely...

    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 6, 2012 at 5:19 am

    #1534391

  • RE: DBCC CHECKDB

    At a very high level it checks the metadata for consistency, checks the allocation structures for consistency and then checks every table in the DB for damaged pages, bad links...

    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 6, 2012 at 5:15 am

    #1534390

  • RE: Insert Profiler output into a table without a trace (trc) file

    You can only do it using the Profiler GUI, not server-side traces. It's got the highest overhead and worst impact on the traced server of all the options for tracing,...

    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 6, 2012 at 5:15 am

    #1534389

  • RE: Release Total Server Memory in SQL 2008

    sqldba4u (9/6/2012)

    There is a requirement to reset SQL Server memory without restarting SQL Services. And the below commands are not doing the needful.

    Why? That's going to make things run slower...

    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 6, 2012 at 5:11 am

    #1534385

  • RE: Shrink DB

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

    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 6, 2012 at 5:10 am

    #1534380

  • RE: How to upload images in a post in SQLSERVERCENTRAL forum ?

    What needs a screenshot?

    Right click your attachment -> copy link

    Paste that link into the text area. Highlight it.

    In the panel to the left (IFCode shortcuts) click the [/img ]...

    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 5, 2012 at 4:52 pm

    #1534185

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    jrichards54 (9/5/2012)

    I am unable to do either of these as in Windows 7 Home Premium, in Control Panel, in Remove programs, I do not have an add programs feature. 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 5, 2012 at 4:50 pm

    #1534184

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    SQL Server Management Studio is SSMS, not SSMO (where does the O come from?)

    What you describe (SSMS starting and asking you to connect to a server) is completely correct 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

    September 5, 2012 at 4:42 pm

    #1534179

Viewing 15 posts - 16,756 through 16,770 (of 49,552 total)