Answered here

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2127045&SiteID=1

http://www.sqlsecurity.com has a database of all versions almost as quickly as they become available. You can find your patching level there and has links to non-PSS downloads.

http://www.sqlsecurity.com

has a page dedicated strictly to patches and service packs.

Also, MS has a mailing list still I do believe but I forget where to find it and Shavlik...

Most common things big companies do are give bogus names to tables and columns making it hard to figure out what the user is looking at and even encrypting some...

I don't recall seeing anything happen with temp and backups but could be your page file needed to grow due to the amount of memory work being done at the...

Unfortunately I haven't had to find a book in some time as I have been doing. However I would goto Amazon and search thru books for C# (or C++) and...

Sorry, saw you had posted that already after I posted, forgot to look at all the pages.

Ha Ha, sure didn't.

Do you really have 300,000 to 800,000 unique connections (meaning that many people or devices) really are needing the SQL Server at that moment?

If you have 1000 users and 300,000...

They would want to do for the same reason they would using JAVA. They are writing an application in one of those languages and need to access data from a...

If you have SQL 2005 then look at reporting Services for SQL Server. As you can run it on the same server at no additional charge and it has the...

My favorite book

The Guru's Guide to SQL Server Architecture and Internals - Ken Henderson

Read thru some of my posts especially around middle of year before last and there before where the...

Note it may be there but may still have to recompile. To see if it is using a cached version you really have to use Profiler and look for Cache...

Yeah, I agree with the things said. I have been asked to perform a technical interview and have thrown things in related indirectly to the specific job as we may...

4. I depends on the type of replication you are going to use. There are 3 types:

Snapshot

Merge

Transactional

Each have requirements you must consider when considering what will work best.

If you...