-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
sys.configurations – It has server side configuration value name – Name of configuration name value – current value of the… READ MORE
|
http://blog.flimatech.com/?p=1291 READ MORE
|
DBA_TAB_MODIFICATIONS view contains tables that were modified since last time statistics was gathered on the table. It contains the number… READ MORE
|
SET STATISTICS TIME [ON|OFF] – Tells how much CPU time and time taken to parse and compile and also the… READ MORE
In SQLServer TRUNCATE TABLE can be rolled back when within a transaction. TRUNCATE still doesn’t log each row when it’s… READ MORE
|
Using the SELECT statement below one can list notications that occur for jobs scheduled on SQLServer. SELECT –Job name sj.name… READ MORE
— SQL server version SELECT @@version output: Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright… READ MORE
Information on sysjobhistory Information on sysjobs — shows job history with the most recent one to show the most recent… READ MORE
|
http://msmvps.com/blogs/ad/archive/2006/10/27/Run-Command-Shortcuts-for-Adminstrative-Tools.aspx READ MORE
http://www.dba-oracle.com/t_x$ksmlru_x$ksmsp_shared_pool_monitoring.htm READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 