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: Could you please give me a simple explanation to what stacks are? How do they work and what are their related features? Answer: Stacks are temporary resting places for
Question: I am using Exchange Server 5.5 and Outlook 97 on about 30 workstations. I use a public folder to store shared contact info. On all but two of the
Question: If I just want to see some data from a table, is there some SQL syntax to prevent 2 million rows from coming back without adding conditions on the
Question: I’m having a problem writing a SELECT statement that will compares a date stored in a table against the current time. This is for a calendar on a Web
Question: How do you list available tables and their schemas from an SQL query? Answer: There is an owner in the database called INFORMATION_SCHEMA who has a bunch of objects
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