Forum Replies Created

Viewing 15 posts - 46 through 60 (of 112 total)

  • RE: List all index held on a SQL 2005 server

    this is in the solarwinds DB, NetPerfMon and I had a similar issue with a reorganize query i got ==> http://www.sqlservercentral.com/scripts/index/64469/ and I modified it to apply those ALTER INDEX...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 29, 2010 at 6:59 am

    #1228971

  • RE: Transaction Log file size grows exponentially after maintenance Job ?

    I'm using this index reorganize/rebuild script ==> http://sqlfool.com/2010/04/index-defrag-script-v4-0/

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 29, 2010 at 3:59 am

    #1228850

  • RE: Odd issue with Maintenance job histories

    Hi, I had a similar issue when there was no Service Packs installed for MS SQL 2005 and when I had an issue installing SP3 on the same server and...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 28, 2010 at 4:53 am

    #1228246

  • RE: SCOM DB CheckDB errors

    no issues thanks :hehe:

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 27, 2010 at 9:00 am

    #1227756

  • RE: Best practices are really the best (fastest) solution?

    ricardo_chicas (9/22/2010)

    Thank you All

    I found a really good book about best practices and such

    With my sproc i just ran a query for missing index, modified on index to add some...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 23, 2010 at 3:31 am

    #1226169

  • RE: SQL2005 / SP3 fails with start services problem

    I think this is my issue aswell regarding McAfee HIPS stopping the Database Services install ...

    I will get the security guys to disable HIPS an then I'll try again as...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 18, 2010 at 2:36 am

    #1223444

  • RE: Log shipping and DB Mirror question

    DB mirroring can be set to pause ...

    With log shipping could you just disable the log backup, copy and restore jobs to pause it for a server reboot for example???

    Enable...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 14, 2010 at 6:21 am

    #1220615

  • RE: Log shipping and DB Mirror question

    THANKS 😎

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 14, 2010 at 2:05 am

    #1220510

  • RE: Log shipping and DB Mirror question

    Thanks Gail ... so no DB corruption from the principle will reach the mirror DB ...

    So both Log shipping and Database mirroring will not require downtime to setup initially on...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 14, 2010 at 12:42 am

    #1220471

  • RE: Error during S3 istall on SQL Service error 1603

    Hi yes it is SP3 :hehe:

    I have domain admin rights and tried installing it with this account. I tried with the local admin account 1st...

    The server server services update with...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    September 6, 2010 at 2:06 am

    #1216785

  • RE: SQL Server Agent failed to start

    I have a similar problem on 1 of the servers i check ... any updates on your issue?

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    August 25, 2010 at 2:41 am

    #1211494

  • RE: MS SQL (Express, 32bit - Standard, 64bit - Enterprise)

    Hi, I got it installed as per umakanthvydyula and ALZDBA's replies thanx ;-);-)

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    July 23, 2010 at 7:21 am

    #1197491

  • RE: MS SQL (Express, 32bit - Standard, 64bit - Enterprise)

    SP3 for Windows Server 2003???

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    July 22, 2010 at 8:17 am

    #1196876

  • RE: SQL 2005 - SELECT query takes long time to retrieve

    how many columns and rows is there in this table?

    if it's a small table it should not take long to display the table at all without indexes on it ...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    July 20, 2010 at 7:41 am

    #1195517

  • RE: Execute T-SQL Statement Task issue

    hi sql peeps, when I run the query I posted above in a new query window in the management studio it runs without any issues. If I run it in...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    July 14, 2010 at 12:42 am

    #1192578

Viewing 15 posts - 46 through 60 (of 112 total)