Enable / Disable schedules of SQL Job -Tsql

EXEC msdb.dbo.sp_attach_schedule @job_name=N'Job Name',@schedule_id=51
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_update_schedule @schedule_id=51,
@enabled=0
GO


EXEC msdb.dbo.sp_attach_schedule @job_name=N'Job Name',@schedule_id=51
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_update_schedule @schedule_id=51,
@enabled=1
GO

Iphone & Ipad patterns

IPAD Patterns

http://landingpad.org/
http://thoughtbot.com/

Pattrns
http://pttrns.com/
http://mobile-patterns.com/
http://www.lovelyui.com/

Andorid UI
http://www.androiduipatterns.com/

become the root account in MAC os X

sudo -s ---->>> become the root account in MAC os X

DTExec using runas

runas /user:abc\xyz "DTExec.exe /f \\NetworkServer\file\Package.dtsx"


dtexec /f “C:\Testing.dtsx” /l “DTS.LogProviderXMLFile;log.xml”
/Set “\package.Connections[log.xml].Properties[ConnectionString];C:\log.xml”

Row and Page Compression in SQL Server 2008

Row compression is used to minimize storage at the row level by compressing fixed-length data types.


Page compression is used to minimize storage for redundant data stored in pages.

Find max value in Excel

Cell B1=MAX(A:A)

Clone table in SQL Server

SELECT *
INTO MyNewTable
FROM MyTable