I should apologize. I read the silly thing several times unfortunately I missed the fact that I failed to commit transaction 1 at all. To much copy and...

Unfortunately no. It is definitely set to automatic startup.

I have heard that sometimes services won't start if a required service hasn't started up yet. Is the SQL Service...

I've checked the windows application log pretty carefully from the shutdown point through the point the instance was brought up manually. It came up manually with no problems and...

Thomas Abraham (7/11/2012)

---

Thanks Kenneth for a very good question. It was well written and explained. (Only improvement to code would be to alias computed columns.) And, with a short amount...

I want him to be able to alter/create any SP in the database, but ONLY sps. No functions, views. No modifying tables etc. I've done this in...

Thanks again for all of the help. Here is my final query. There are probably better ways to do it but this appears to get what I need.

;

WITH...

Ok, so now I'm having a really bazaar error. I'm trying to use the CROSS APPLY to get the query plan and for some reason I'm getting an error...

The compile time is a specific work problem. I'm trying to prove to my boss that turning on OPTIMIZE FOR ADHOC WORKLOADS is a good idea.

I have...

Great, I appreciate it. I'll see if I can find/create one today and post it if I can. XML is one of those things I plan on learning,...

I hate to ask, but I just don't know enough XML yet. Do you have a query that will pull the compile time out of the plan XML?

If for...

If it succeeds when you are using a SQL login and fails when you use an AD login then it sounds like you are having a "double hop" problem. ...

ivycool2012 (5/24/2012)

---

Unfortunately its a slightly different problem. My user can't even open the Management node without getting the error "The user does not have permission to perform this action." She...

ankitb (5/21/2012)

---

Kenneth, nice to hear you guys are considering virtualization for your databases. Do you guys have a corporate policy defined around what the virtualization solution (VMware, HyperV, etc) would...

Most of our servers are not virtual, and the corporate directive is to virtualize them all. We have noticed some issues with performance, and make sure you know what...

Here is how I would do it. I in SQL 2008 R2 you can have as many JOINs as you have resources to deal with them. 3 is...