Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 2,463 total)

  • RE: Service pack: Where/Why ?

    thanks but can you be more descriptive ? 🙂

    November 12, 2010 at 12:51 am

    #1249859

  • RE: Blocking

    Use below queries for troubleshoot.these would be more informative.

    --use ESS_ARCHIVE

    --select * from sys.dm_os_wait_stats

    select r.cpu_time

    , r.logical_reads

    , r.session_id

    into #temp

    from sys.dm_exec_sessions as s

    inner join sys.dm_exec_requests as r

    on s.session_id...

    November 11, 2010 at 1:30 am

    #1249308

  • RE: Blocking

    pujain (11/11/2010)

    Hi all,

    I am facing an issue where my update statement is blocked by below statement(Inactive):

    "use dbname"

    is any body having an idea why? and whats the workaround to avoid.

    thanks

    Puneet

    ...

    November 11, 2010 at 1:27 am

    #1249306

  • RE: Output of Query

    Thanks to OP and special thanks to HUGO for great explanation.

    November 9, 2010 at 12:24 am

    #1248042

  • RE: Single SELECT

    GilaMonster (11/8/2010)

    Why? What's the reasoning behind that odd limitation/restriction?

    This was asked by one of my friend during a quiz

    November 8, 2010 at 9:34 pm

    #1247997

  • RE: Single SELECT

    How

    count(*) over (partition by 1)

    section is working here ?

    November 8, 2010 at 6:43 am

    #1247631

  • RE: Single SELECT

    thanks dave , but some times i get error that i need to use "order by" with "partition by" , Any idea ?

    November 8, 2010 at 6:41 am

    #1247627

  • RE: Reorganize Index, Database Integrity check, Update Statistics required for System Databases

    muthukkumaran (11/8/2010)

    1.Backup --yes (Except tempdb)

    2.Reorganize Index --no

    3.checkdb --yes (Except tempdb)

    4.Update Statistics --no

    What about MSDB ?

    November 8, 2010 at 6:38 am

    #1247626

  • RE: Rebuild Index - Loghshipping

    Our Secondary server is more often in recovering or stand by state and we made it by restoring the full back up of primary one. after that sequence Tlogs from...

    November 7, 2010 at 10:23 pm

    #1247508

  • RE: Issue while configuring Log Shipping on SQL 2005 Enterprise

    Did you check the the log_shipping_alert job (which get created when we use wizard) ?

    November 4, 2010 at 6:22 am

    #1246477

  • RE: Select * from a table with one billion rows failing

    RPSql (11/3/2010)

    Select * from a table with one billion rows failing with following error (SQL 2005 SP3 HF11)

    An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException'...

    November 3, 2010 at 11:03 pm

    #1246382

  • RE: Performance Issue

    you can also set profiler trace and check other child SPs which might be cause of bad performance.

    November 3, 2010 at 10:59 pm

    #1246381

  • RE: Rebuild Index - Loghshipping

    sqldba_icon (11/3/2010)

    but indexes are used on queries based on statistics and statistics are stored inside master database of local server. Am i missing anything here?

    In simple language i would...

    November 3, 2010 at 10:52 pm

    #1246378

  • RE: Rebuild Index - Loghshipping

    Yes, the operation is fully logged, so the indexes on the secondary server will be rebuilt automatically.

    However, we don’t recommend that you rebuild indexes often for a log shipping scenario...

    November 3, 2010 at 10:34 pm

    #1246371

  • RE: Selective Index Maintenance

    You can also set a maintenace task or job to rebuild/reorganize the only required indexes OR might be on the required database instead of selecting all DBs

    November 3, 2010 at 5:40 am

    #1245925

Viewing 15 posts - 1,186 through 1,200 (of 2,463 total)