Forum Replies Created

Viewing 5 posts - 16 through 20 (of 20 total)

  • RE: TSQL to detect update statistics

    as the solution you asked....only...

    you can put below code in your if else condition to avoid that situation

    SELECT sqltext.TEXT,

    req.session_id,

    req.status,

    req.command,

    req.cpu_time,

    req.total_elapsed_time

    FROM sys.dm_exec_requests req

    CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

    WHERE req.command like '%update statistics%'

  • RE: SQL Server Databases Synchronization

    if your second DB is standby. you can also refer log shipping or transaction replication as per your current setup

  • RE: Moving a couple of SQL Jobs from one machine to another

    you can use powershell scripts commands to move all your jobs by a single job on server.

  • RE: Performance Issue on View using Union All

    if its scan going on your query that means you can further look for indexes to create. plus also update the statistics.

    also try tuning adviser recommendation for whatever query you...

  • RE: Incomplete Backups

    1. check is it really a full backup?

    2. check for compression option in maintenance plan

    3. check for table data in last in case of nothing solve the purpose(previous backup after...

Viewing 5 posts - 16 through 20 (of 20 total)