Forum Replies Created

Viewing 15 posts - 11,911 through 11,925 (of 49,552 total)

  • RE: Is there a way to sort the table after records are inserted?

    Couple steps back...

    What are you trying to do?

    Bear in mind that a table has no defined order (by definition). A resultset only has a guaranteed order if an ORDER BY...

    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

    August 28, 2013 at 5:39 am

    #1645504

  • RE: Controlling Transaction log size in Simple Mode

    Ells (8/28/2013)

    Thanks.

    so thats all my plans out the window and look at Checkpoints. Would it be sensible to force checkpoints if they are not happening quickly enough?

    Usually no. If you're...

    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

    August 28, 2013 at 3:01 am

    #1645449

  • RE: Controlling Transaction log size in Simple Mode

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

    Did the transaction log not reuse the available space that was ready for reuse because it was allowed to keep growing to a very very...

    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

    August 28, 2013 at 2:13 am

    #1645434

  • RE: sys.dm_exec_sessions - High CPU

    As Erland said, something that polls the table on a regular interval, stores the results somewhere and then you'd difference the latest and previous rows.

    What are you trying 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

    August 28, 2013 at 2:00 am

    #1645431

  • RE: trigger to restrict access for changing login permissions in sql server 2008

    There is nothing you can do to stop a sysadmin from doing whatever he wants. If you add a trigger to prevent him from changing a login, he can drop...

    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

    August 28, 2013 at 1:39 am

    #1645424

  • RE: Using contig.exe to defragment an open .mdf file

    I wouldn't recommend it. One error in that defragging tool and you have a corrupt database. Better safe, stop SQL or take that DB offline, then defrag 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

    August 28, 2013 at 1:28 am

    #1645422

  • RE: Invalid object name

    You insert into Test2, but you never create it, hence the table does not exist.

    Add a CREATE TABLE statement for Test2

    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

    August 27, 2013 at 12:30 pm

    #1645307

  • RE: Do we have possibility to update system tables in SQL..

    L' Eomot Inversé (8/27/2013)

    If you ever wrote a tool to script maintenance plans in SQL 2000 you would probably disagree with yourself - it couldn't be done without updating system...

    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

    August 27, 2013 at 12:22 pm

    #1645303

  • RE: Change SQL Data Root Directory

    What, exactly, are the messages in the error log?

    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

    August 27, 2013 at 11:17 am

    #1645280

  • RE: Delete Vs Truncate difference on rollback

    L' Eomot Inversé (8/27/2013)

    I think TRUNCATE takes only a table lock

    TRUNCATE take a schema modification lock

    DELETE takes row and sometimes also page locks

    Delete can take X locks at table, page...

    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

    August 27, 2013 at 11:13 am

    #1645278

  • RE: Decimals truncated when storing decimal in a deicmal variable or colum

    You're not declaring the precision or scale of the decimal. The default is 18,0 meaning 18 digits on the left of the decimal place and 0 on the right (so...

    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

    August 27, 2013 at 10:45 am

    #1645274

  • RE: sys.dm_exec_sessions - High CPU

    Be careful with that. The CPU_time is the total time since the connection was established, not necessarily going to help much with identifying high CPU-using queries.

    Memory usage is probably the...

    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

    August 27, 2013 at 10:39 am

    #1645272

  • RE: Delete Vs Truncate difference on rollback

    Jeff Moden (8/27/2013)

    Semantically speaking, it's a difference in what gets logged.

    Indeed. TRUNCATE is more like a DDL statement, it logs in the same way as a DROP TABLE does. DELETE...

    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

    August 27, 2013 at 10:37 am

    #1645271

  • RE: Do we have possibility to update system tables in SQL..

    Jason.Reeves (8/27/2013)

    Most of the system information is now held in the Resource DB which is hidden read only (for good reason) you can't even do a SQL backup of this...

    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

    August 27, 2013 at 9:08 am

    #1645242

  • RE: LOG_BACKUP status not clearing in sys.databases

    If you've got enough activity, then the reason for the log not being reused can easily be log backup all the time, because by the time one log backup has...

    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

    August 27, 2013 at 9:05 am

    #1645241

Viewing 15 posts - 11,911 through 11,925 (of 49,552 total)