This is for when you restore a database and want to hook the users in the new database to the users with the same name in the SQL Server
login to the db as SA
exec sp_change_users_login 'Auto_Fix', 'UserName'
response.ContentType = “application/vnd.ms-excel”
response.AddHeader “content-disposition”, “inline; filename=” & FileName
Abyss Web Server is a compact web server available for Windows, Mac OS X, Linux, and FreeBSD operating systems.
Despite its small footprint, it supports HTTP/1.1, secure SSL/TLS connections (HTTPS), dynamic content generation through CGI/FastCGI scripts, ISAPI extensions, native ASP.NET support, Server Side Includes (SSI), custom error pages, password protection, IP address control, anti-leeching, and bandwidth throttling.
It also features an automatic antihacking system as well as a multilingual remote web management interface that makes its configuration as easy as browsing a web site.
I developed some complicated reports for my company lately, and the query can be slow up the 10 seconds. using with nolock or readpast really do the trick.
ex: reading only commited rows
select * from some table with(readpast)