The RPC protocol is used when a client calls a procedure on a server. In SQL terms typically when an application server makes a procedure call against the database you...

Here's a great set of articles I found very helpfull.

http://www.mssqltips.com/tip.asp?tip=1687

http://www.mssqltips.com/tip.asp?tip=1698

http://www.mssqltips.com/tip.asp?tip=1709

http://www.mssqltips.com/tip.asp?tip=1721

There are a few gotchas around virtual SQL Server names if you have multiple named instances. If you intend runing Reporting...

Once the SQL Server Service has started, it is technically able to accept connections, but it takes a few seconds to attache the databases and make them available. This means...

You rproblem is in this section of the code

To use the dm_exec_sql_text function you need VIEW SERVER STATE permissions. See http://msdn.microsoft.com/en-us/library/ms181929.aspx?ppud=4

You can fix it by making the...

You're correct, my statment isn't true in all...

For a small number of rows you won't see any signifiacnt performance diference, but as the rowcount goes up you will find temp (#) tables perform better than table variables...

I've followed up on this and it looks like this is a bug in SQL 2008 R1 and R2.

I'd be interested to know if anyone has checked their 2008 SSRS...

sandhyarao49 (4/28/2010)

---

When Lock pages in momory in enabled for the account which runs under sql server, then this info should be logged in the server logs--

To my Knowledge and...

To extend my earlier post, the default setting is ON. I...

GP-395290 (3/20/2008)

---

Maybe if you could let me know when SQL Server would think it's optimally better to lock a page rather than a row that might help me understand. I...

Sounds like a round about way to do this. You could just create a small test database on the new drives. If it works SQL can see it and you...

Thanks all for the replies. None of the documentation is really that explicit. I've worked out that you can set this up and for each SQL Instance on the cluster...

They had...

Henry Treftz (2/11/2011)

---

Can I set up an active, active cluster such that if there is a failover to a single server one instance of SQL Server gets significantly more resources...

On of the event recorded in the default trace is the Data File auto grow event (trace_event_id = 92). So without all the complex sluthing you can look here and...