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

XML Query in SQL Server

DECLARE @prodList xml =''



'';

WITH XMLNAMESPACES(DEFAULT 'urn:Wide_World_Importers/schemas/Products')
SELECT prod.value('./@Name','varchar(100)'), prod.value('./@Category','varchar(20)'), prod.value('./ @Price','money')
FROM @prodList.nodes('/ProductList/Product') ProdList(prod);