-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
http://blog.flimatech.com/?p=1291 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
By querying msdb.dbo.backupset and msdb.obackupmediafamily one can see backup history like start and end time, type of backup, location of… 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
By calling msdb..sp_get_composite_job_info or msdb.dbo.sp_help_job one can find the current jobs running on SQLServer. Example: exec msdb..sp_get_composite_job_info @execution_status=1 Or exec… READ MORE
To disable to trigger that are enabled in cases when loading data manually in a particular schema or table can… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 