I have not read SQL Server Security, but I would still recommend anything by David Litchfield. Also take a look at The Database Hacker's Handbook : Defending Database Servers.

No, the /3GB switch is not required, although often you would include it to maximize the memory you can use.

Perhaps you could point us in the right direction of what JSP is?

SELECT *

FROM ordhed

WHERE NOT EXISTS (SELECT * FROM qcordhed WHERE ordhedid = ordhed.ordhedid)

As I mentioned in an earlier answer to one of your questions, the smallest unit of I/O that SQL Server reads from disk are extents. An extent contains 8 pages,...

One person mentioned that they thought they heard that running SQL Enterprise with 3+GB RAM on Win2003 Standard Edition using the 3GB switch is a bad thing. Has anyone...

Since you created a separate thread for this question (which was the correct thing to do of course), I have answered there, so please continue that discussion there.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=234349

Well, since non-clustered indexes are stored that way there would be no idea in having clustered indexes being stored the same way, right? If you do not want to use...

The leaf level pages of a clustered index are data pages (mtype=1), stored in logical index order.

Regarding scanning unused pages in an extent: An extent is the smallest object SQL...

Why don't you just PRINT it?

Changing the Paradigm by Scalability Experts is one of the more recent books that gives an overview of SQL Server 2005. But I expect there will be (or are already)...

Unfortunately though they will only be available until tomorrow, then they are removed. Just start using the product, and read through Books Online as much as possible. There are also...

Since the view shows data from the base tables it naturally cannot be updated without modifying the base tables. There is no solution for that. But what do you really...

Yes, looks pretty simple alright. But like I said, I really have no experience with ColdFusion so I do not know what kind of configuration you can do with it....

Well ,I'm sorry but I am out of specific ideas now. But it seems fairly certain that the issue lies within the CFM application, so you should start there.