in

SG SQL Server Usergroup

The Premier web platform for Microsoft SQL Server professionals in Singapore
All Tags » Tips and Tricks (RSS)

Browse by Tags

  • Do you want to know when was the last time your tables were accessed ?

    Please run the following query to know that WITH LastTableAccess ( [object_id] , readDate , writeDate ) AS ( SELECT [object_id] , last_user_seek ,NULL FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID () UNION ALL SELECT [object_id] , last_user_scan ,NULL FROM sys.dm_db_index_usage_stats WHERE...
    Posted to Tips and Tricks (Forum) by pethiraj on 06-26-2008

  • Progress Monitoring Of SQL Server 2005 System Maintenance Activities

    Hello Everyone, Do you know that SQL Server 2005 provide us an way to monitor what’s the current progress ( Percentage Complete and Estimated Completion time ) of some of the maintenances we do regularly. Following are the activities that can be monitored: DBCC CHECKDB DBCC CHECKTABLE DBCC CHECKFILEGROUP...
    Posted to Tips and Tricks (Forum) by pethiraj on 05-26-2008

  • Quickly compare rows to determine if anything changed

    Quite frequently, you have to load data from another system. One of the biggest hassles during this process is determining which rows have changed in order to apply updates to only that subset of rows. You could create a very complicated process that joins the primary key and then proceeds to check,...
    Posted to Tips and Tricks (Forum) by Pom on 03-22-2008

  • Querying I/O Statistics

    To view I/O statistics for database and log files, use fn_virtualfilestats. The arguments for this function is ([Database ID], [File ID]) For example: To obtain the I/O stats for the TempDB database file the syntax would be SELECT * FROM ::fn_virtualfilestats (2, 1) To obtain the I/O stats for the TempDB...
    Posted to Tips and Tricks (Forum) by Pom on 03-22-2008

  • Create your own hotkeys

    In the SSMS, go to the Tools menu and choose Options. Under Environment, choose Keyboard and you should see a list of possible hotkeys. Three are predefined: ALT+F1 will execute sp_help Cntl+1 will execute sp_who Cntl+2 will execute sp_lock You can add your own commands to be executed for any of the...
    Posted to Tips and Tricks (Forum) by Pom on 03-13-2008
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems