They separate tables into logical groups or application subsets that can be used as security boundaries if implemented correctly. Some might say that having to schema qualify everything would...

Initial recovery of the database through roll forward/rollback operations would be one thing.

Yielding in CLR is a good thing, as documented by the CLR Integration Team Blog on MSDN:

SQL Server 2005: CLR Integration : Who says tough guys never yield?

By properly yielding...

Change it. You can't decrypt the password for the login unless you have a lot of time to wait for some kind of brute force tool to crack it...

What you could probably use is a Client Configuration Alias that sits client side and allows you to easily change the SQL Server without having to reconfigure a bunch of...

I'd recommend reading the following blog posts from Paul Randal about this:

How to tell if the IO subsystem is causing corruptions?

Example 2000/2005 corrupt databases and some more info on...

There are multiple connect items for the VIEW ANY DATABASE prevents users from viewing databases they have access to as well issue. I'd recommend that you vote on Erland's...

No it would only show the current instance, it wouldn't have the other...

I can't believe that Steve linked to a partner and left his own site out of the mix. :blush: Just kidding you know I love you Steve. :kiss:

Anyways...

To find the number of instances open the SQL Server Configuration Manager and count the number of Database Engine services listed. You can also find it out by looking...

I got my start by accident. I was a Application and Business Analyst that ended up needing to query the database to find the scope of a problem and...

What are the top 10 wait types for the SQL Server?

SELECT TOP 10 *

FROM sys.dm_os_wait_stats

WHERE wait_time_ms > 0 -- remove zero wait_time

AND wait_type NOT IN -- filter out...

The numbers you posted sound normal to me for SQL Server. It sounds to me like you don't understand how SQL Server uses memory. Take a look through...

Generally speaking, no you can't, this has been a thorn in the SQL DBA's side for a while. Why exactly do you want to go backwards in patches? ...

A quick trick that you can use with anything that SSMS does is to start a profiler trace that has the RPC:Starting and SQLBatch:Starting events in it, and set a...