Forum Replies Created

Viewing 15 posts - 10,681 through 10,695 (of 49,552 total)

  • RE: Lazy Writer Activity

    Clean pages aren't moved to disk. The only pages that are written back to disk are dirty pages, so the lazy writes/sec measures the total number of pages per sec...

    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

    December 10, 2013 at 3:10 am

    #1672233

  • RE: Moving a database log file when recovery model is Simple

    dan-572483 (12/9/2013)

    Security may be a factor as this was a new drive created because the old drive used for SQL log files was no longer large enough. But...

    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

    December 9, 2013 at 2:10 pm

    #1672131

  • RE: Select from table and alter result

    declare FindFragment cursor for

    SELECT object_id, '['+name+']' FROM #IndexFrag WHERE (avg_fragmentation_In_Percent > 5) and (avg_fragmentation_In_Percent < 40) and (name not like 'null')

    Or don't spend time re-inventing the wheel and use http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

    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

    December 9, 2013 at 9:01 am

    #1672010

  • RE: SQL Log

    It won't.

    Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/

    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

    December 9, 2013 at 8:02 am

    #1671960

  • RE: Unexpected data rollbacks _ Tool needed

    I stand by what I said earlier. Sounds like some process is logging in every couple of days and updating the table to old values. Check logs, set up a...

    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

    December 9, 2013 at 8:00 am

    #1671958

  • RE: Debug an Insert Statement

    What are the definitions of the two tables?

    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

    December 9, 2013 at 7:45 am

    #1671946

  • RE: Unexpected data rollbacks _ Tool needed

    A rollback could not cause that unless you had a transaction open since November (and if you had, you'd have known by now due to the blocking and the tran...

    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

    December 9, 2013 at 7:45 am

    #1671945

  • RE: Do columns have unique object IDs?

    Why? Unless you're dropping and recreating tables, the object id and column id will remain the same. They don't change at random times for no reason. If you're frequently dropping...

    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

    December 9, 2013 at 6:57 am

    #1671923

  • RE: Timing Issue

    Code please (and maybe use people's names not their forum status?)

    SQL won't skip lines in a procedure so there's something odd going on, possibly stuff failing silently.

    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

    December 9, 2013 at 5:23 am

    #1671897

  • RE: Do columns have unique object IDs?

    Columns are uniquely identified by the combination of object_id (for the table) and column_id. They don't have a single unique ID of their own.

    The only time a table's object_ID can...

    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

    December 9, 2013 at 4:32 am

    #1671878

  • RE: Timing Issue

    Igor's not the OP.

    Tina, any chance you could post the definitions of the procedure having the problem? Also, consider putting PRINT statements or using RAISERROR to raise informational messages 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

    December 9, 2013 at 4:04 am

    #1671871

  • RE: Restoring Master DB from a StandAlone server to a Cluster

    To restore master you need to take the server down, restart it in single user mode, restore then restart again. Running scripts to create logins requires no downtime at all....

    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

    December 9, 2013 at 3:37 am

    #1671857

  • RE: Timing Issue

    twin.devil (12/9/2013)

    IgorMi (12/9/2013)

    Yes there is TRY .. CATCH in T-SQL - http://technet.microsoft.com/en-us/library/ms175976.aspx

    Regards,

    IgorMi

    ahaan nice, thats why your procedure is in the silent mode 🙂

    Igor just said there is a try-catch construct...

    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

    December 9, 2013 at 3:33 am

    #1671855

  • RE: Restoring Master DB from a StandAlone server to a Cluster

    I generally recommend not restoring master from one server to another. Script the logins, server-level roles and permissions and linked servers and apply on the new server.

    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

    December 9, 2013 at 3:29 am

    #1671851

  • RE: Space Required For Index Rebuilds

    Jeff Moden (12/8/2013)

    Since the files that I'd be rebuilding the Clustered Index on would not have any modifications or new inserts in progress, it might just work if I apply...

    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

    December 8, 2013 at 11:49 pm

    #1671802

Viewing 15 posts - 10,681 through 10,695 (of 49,552 total)