-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
In Oracle there is CREATE TABLE…AS to backup table into a new table and the syntax on SQL Server is… READ MORE
To find sessions that are blocking a session and blocked session, one can run the following SQL which works on… READ MORE
http://support.microsoft.com/kb/319942 READ MORE
In Oracle Using MINUS and UNION ALL one can compare 2 tables to find differences in data in the tables.… READ MORE
In SQLServer 2005 one can connect to the SQL Server with a special connection called “Dedicated Administrator Connection” called as… 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 following T-SQL one can create differential backup or make it part of scheduled job. declare @datetimestamp varchar(20) declare… READ MORE
|
Run the following SQL to find permissions granted on individual objects on the database select case when p.protecttype = 205… READ MORE
By executing the store procedure sp_spaceused ‘<table>’ one can find the space used by a table. The store procedure returns… READ MORE
In Query analyzer — prints job name, step name, start time and end time of each step in the job… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 