Enhancements to the lock manager in SQL Server 6.5 provide row-level concurrency for INSERT operations. Properly implemented rowlock increases the speed of multi-user INSERT operations. Insert rowlock (IRL) is OFF
Similar to GzipServlet, this tip uses header information for tuningoutput of our servlets; this one allows you to check the header ‘Accept-Language’. If your user has set some language preferences
You can mark an ASP page with a transaction support property, just as you can do with a registered MTS component. An ASP scripting object thus can serve either as
Question: The Enterprise Manager (or whatever it’s called now) shows all the systems tables when you navigate down to the tables in a database. How do you hide the system
Question: How do I convert a character string into a time field? Data is being read in as 12:10 and I need to calculate response times based on this field.
Question: I have a Web page that lets the user query my database and return results in groups of 50 records. I know how to do the first SQL statement
Question: Is there a “best” way to design VB/ASP apps to deal with SQL (7.0) security? For example, in a WAN environment and a Web application where the app needs
Question: I can’t remember the reason for the efficiency of the SQL query. I thought that the results of the query are sent to a “client,” as opposed to the
Question: I have a table below: Name idJohn 40Mary 50Peter 15John 40Peter 15John 40 How can I query to get who appeared most of the times in the table? (In