Daivagna Nanavati

ENABLING GZIP FOR FASTER DOWNLOAD OF WEB PAGE. Zombi note :The HTTP/1.1 protocol allows for clients to optionally request the compression of content from the server. The standard itself specifies two compression methods: “gzip” and “deflate” Both are supported by many HTTP client libraries and almost all modern browsers. Enabling gzip at IIS Manager At IIS Manager (inetmgr.exe) open Web Sites Properties, at Service tab mark Compress application files & Compress static files. Zombie note :You need to right click the web sites rather than going into specific site and click properties of perticlar website. Now you need to edit one xml file as below c:\WINDOWS\system32\inetsrv\MetaBase.xml file. Zombie note : Before Editing Metabase.xml file stop IIS Services or enable Direct Metabase Edit at Web by going into the peroperties and WEB02 dialog box will appear and check mark the “ENABLE DIRECT METABASE EDIT.” Edit Metabase.xml with text editor and locate the following lines: HcFileExte

1) How to remove duplicate records from a table? delete from tmp where rowid not in(select max(rowid) from tmp group by tmpno) 2) How will you copy the structure of a table without... a)Without Data : select * into temp2 from temp where 1=2 b)With Data : select * into temp2 from temp c) SELECT TOP 0 * INTO Test1 FROM Test 3) RE: how many column maximum we can add in one table a... The column length is dependent up on the type of statement we are using: It will be 4,096 for select statement 1024 for insert statement. The number of foreighn key maximum we can use in a table is 16 and we can link with 253 tables. 4) What is the difference among "dropping a table" and "truncate" Dropping table the structure of table as will as row of table . but truncate table delete all the row of table but structure of table remain same we can apply where condition on it . delete work like truncate the table but we can apply where condition on it. Truncate can't roll back d