Forum Replies Created

Viewing 15 posts - 14,026 through 14,040 (of 49,552 total)

  • RE: fetch tables most often queried

    polkadot (3/5/2013)

    If user names are in several of the system tables and DMVs, are you saying that they are not joinable to the index usage system table? Is there...

    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

    March 5, 2013 at 2:47 pm

    #1593660

  • RE: T-Sql Logical Query

    Google for 'Gaps and Islands' Itzik Ben-Gan

    He's written a huge about on several ways to get this kind of result.

    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

    March 5, 2013 at 1:49 pm

    #1593648

  • RE: fetch tables most often queried

    polkadot (3/5/2013)

    So user names are not logged in any system tables, right?

    User names are in several of the system tables and DMVs.

    And profiler would have to be...

    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

    March 5, 2013 at 1:48 pm

    #1593647

  • RE: SQL SERVER database encryption.

    qur7 (3/5/2013)

    OK, I think I get it now, so as long as the database is up , i can take a new backup with a new password and restore 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

    March 5, 2013 at 12:56 pm

    #1593626

  • RE: fetch tables most often queried

    polkadot (3/5/2013)

    Lowell, or Gila, or someone!, would you mind also telling me which system table I can join to the sys.dm_db_index_usage_stats table to get names of users or userids that...

    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

    March 5, 2013 at 12:46 pm

    #1593621

  • RE: TabLock and TablLockX Confusion

    Tablock -> take locks at the table level. If the statement would normally take shared locks, that will be a shared table lock. If the statement would normally take exclusive...

    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

    March 5, 2013 at 10:59 am

    #1593568

  • RE: Row level locking

    This is a Microsoft SQL Server forum, if you have Sybase questions I'm sure that you'll get better answers on a Sybase forum.

    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

    March 5, 2013 at 10:16 am

    #1593556

  • RE: Row level locking

    The allow_row_locks column in sys.indexes for the clustered index.

    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

    March 5, 2013 at 9:36 am

    #1593535

  • RE: SQL SERVER database encryption.

    If the database is online, the password on the certificate backups is irrelevant, you can take new backups with any password you want (see Books Online for details).

    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

    March 5, 2013 at 8:58 am

    #1593518

  • RE: Rebuild or not ?

    Rebuild if you can, reorganise if you can't.

    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

    March 5, 2013 at 6:38 am

    #1593444

  • RE: Does a SP get precompiled?

    Arjun Sivadasan (3/5/2013)

    Thanks Gail. For an SP, there can be multiple entries in the dm_exec_query_plan DMV even without SP recompilation is what this implies, right?

    No. A procedure has a single...

    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

    March 5, 2013 at 6:00 am

    #1593434

  • RE: Performance Issues when backing up BI db's

    Backups are pretty much an IO bound operation. Check the latency and throughput on the drives.

    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

    March 5, 2013 at 5:19 am

    #1593420

  • RE: Move Database From One Server to Other

    Why not just take a backup, copy the backup across and restore on the other 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

    March 5, 2013 at 4:36 am

    #1593406

  • RE: Does a SP get precompiled?

    A single piece of dynamic SQL will not cause the entire procedure to recompile. At worse, the dynamic section will compile each time, but that depends on a number of...

    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

    March 5, 2013 at 4:22 am

    #1593398

  • RE: Query Performance & Optimization tips

    Bit of a large question. Entire books have been written on the subject. Literally.

    http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    http://www.amazon.com/Server-2012-Query-Performance-Tuning/dp/1430242035/

    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

    March 5, 2013 at 4:20 am

    #1593397

Viewing 15 posts - 14,026 through 14,040 (of 49,552 total)