-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
In Oracle Using MINUS and UNION ALL one can compare 2 tables to find differences in data in the tables.… READ MORE
In SQL Server 2005 using the SQL below one can make the database read-only/read-write. — set database to read only… READ MORE
sp_help Display all objects, the owner of the object and object type sp_help object ‘[store procedure name|table name|view name]’ Displays… READ MORE
In SQLServer 2005 one can connect to the SQL Server with a special connection called “Dedicated Administrator Connection” called as… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 