Hi Perry

I want to make sure that I approach this the correct way

In your opinionm what is the best way to configure the cluster:

>> First create a 2 node cluster...

Perry Whittle (2/5/2013)

---

Firstly, read my article at this link[/url] for more info on AO groups and FCI's

SQLSACT (2/5/2013)

---

My Question: Server1 and ServerB have Shared Storage, how do I prevent ServerC...

Thanks Grant

Definately need to do some more Research and Testing

Thanks

Thanks, this is excellent

Thanks

I understand the workspace memory area (Well, I hope I do). A query will request required memory and once the query has been granted that, if it needs to, it...

I've read your Execution Plans book and I've taken a lot from there.

This particular area of worktables/hashtables is eluding me though

Thanks for your help

Grant Fritchey (1/31/2013)

---

SQLSACT (1/31/2013)

---

Thanks

Basically correct. Although, it really only matters to the internals engine. For your purposes, both are dealt with the same way. According the to the Internals...

Thanks

Basically correct. Although, it really only matters to the internals engine. For your purposes, both are dealt with the same way. According the to the Internals book, a hash...

I've had no problems with the sp_help_revlogin procedure

What I need is a script that will script out everything in the sp_help_revlogin procedure and include server level permissions as...

Great Stuff, Thanks

It would be great if SQL could single out the...

Grant Fritchey (1/23/2013)

---

SQLSACT (1/23/2013)

---

Grant Fritchey (1/23/2013)

---

There's a pretty focused set of requirements for forced parameterization to work. It's a lot more expanded than simple parameterization, but it does not include...

Grant Fritchey (1/23/2013)

---

There's a pretty focused set of requirements for forced parameterization to work. It's a lot more expanded than simple parameterization, but it does not include ALL ad hoc...

Thanks

Will give it a read

I have had a look at the execution plan and it seems that as I described is what is happening.

Where...

SQLRNNR (1/12/2013)

---

Change your order by to Avg Physical Reads. The Total Avg in that query has physical reads plus logical reads.

Starting with IO is a good start....