Check out this article:

http://www.mssqltips.com/sqlservertip/2995/how-to-hide-sql-server-user-databases-in-sql-server-management-studio/

With SQL 2008 R2 and higher you don't really need to enable this traceflag.

You can get the same (and more) information form the System_Health extended events session which logs...

Using locking hints should only be done as a last resort.

Optimizing the query and indexes should come first. Also using READ_COMMITTED_SNAPSHOT isolation level can help.

This article may help you on...

With the little information you gave I can't really tell what's the problem, but this link might help you.

http://stackoverflow.com/questions/515273/reporting-services-total-and-percentages-for-each-row

You could open a query window in SQLCMD mode and then use the following syntax

:CONNECT Server\InstanceName

USE DATABASE

GO

EXEC STORED PROC...

Sorry If I wasn't clear enough but what I meant is this:

c4ntaloop (7/8/2013)

---

Definition of resource pool taken from msdn website is, it represents a subset of physical resources available...

The licensing question depends very much on your current license, especially running on VmWare.

About your second question, since you're using Standard Edition you need to restart the server in order...

mJai (7/7/2013)

---

Dear All,

My current SQL configuration is SQL 2008 standard edition (Vmware virtualized 2 node failover cluster) on windows 2008 R2 .

Whenever I run my SQL backup the CPU shoots...

Correction:

User can only see tables where they have any permission on, doesn't have to be "Select".

I don't think you can disable the expanding option, but users can only see those tables, which they have select permission on.

So unless you give select permission to either...

Yes, you still have to give DB access to the logins.

User-defined server roles simply offer you a more granular option to defeine server permissions,but you still have to set...

Configuring the max\min server memory is...

Check the maintenance plan history or the Maintenance plan logfile if you have one configured.

Jobhistory won't give you the error details.

In the SSMS menu look under "Tools>Options" for Fonts and Colors.

There are no color themes available, but you can configure any part you like.

Let me google that for you

http://lmgtfy.com/?q=sql+server+security+and+permissions