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...

A URL Rewriting This article describes a complete solution for URL rewriting in ASP.NET 2.0. The solution uses regular expressions to specify rewriting rules and resolves possible difficulties with postback from pages accessed via virtual URLs. Why should we use URL rewriting? The two main reasons to incorporate URL rewriting capabilities into your ASP.NET applications are increased usability and easy to maintain (1)increased usability It is well-known that users of web applications prefer short, neat URLs to monstrous addresses packed with difficult to comprehend query string parameters. From time to time, being able to remember and type in a concise URL is less time-consuming than adding the page to a browser's favorites only to access later. Again, when access to a browser's favorites is unavailable, it can be more convenient to type in the URL of a page on the browser address bar, without having to remember a few keywords and type them into a search engine in order to find ...

Why is download speed so important? As we all know nobody wants to wait everybody in this word wants to get everything in flash…so tell me Do you like to wait for pages to download? i do not think so,and if is it so…just go through following zombie steps….. 1. Design your pages with Stylesheet(CSS), not tables CSS downloads faster than tables because: Browsers read through tables twice before displaying their contents, once to work out their structure and once to determine their content Tables appear on the screen all in one go - no part of the table will appear until the entire table is downloaded. CSS generally requires less code than tables All code to do with the layout can be placed in an external CSS document, which will be called up just once and then cached (stored) on the user's computer; table layout, stored in each HTML document, must be loaded up each time a new page downloads With CSS you can control the order items download on to the screen - make the content appear b...