GilaMonster (1/18/2011)

---

Lee Forst (1/18/2011)

---

Grant, another question if I may. What happens in the case of a proc that has conditional branching? For example, the proc has a major...

I still get my answer;-). What type of login are you using?

Grant Fritchey (4/5/2011)

---

It sounds like you're experiencing what is known as bad parameter sniffing. There are several ways to fix this before you get to plan forcing. That should be...

When you select the option "Be made using this security context" what login are you using? If you using windows login it will not work since there are couple more...

Any suggestions?

thanks everyone

Thanks. I tried this out , two things:

i) Sometimes i receive this error "Msg 8152, Level 16, State 2, Procedure sp_lock, Line 42

String or binary data would be truncated.

"

ii)...

Luk (3/27/2007)

---

1. Developers handle only few tables. These tables are rebuild/reindexed on a regular schedule.

2. Our raid configuration iskind ofbad. It's still RAID5, and I've been trying to upgrade it,...

Thanks. I am not sure what you meant with your second comment "instance will go down is node is lost" wouldnt the sql engine failover to other node ? I...

default trace is enabled

CirquedeSQLeil (3/23/2011)

---

Thanks to this question I decided to write a blog post on the topic. I presented three different methods to get the same data.

You can read it at:...

I am still stuck here? Any ideas ?

Lowell (3/22/2011)

---

ok answering my own question, I definitely do not want the serverproperty;

what i foudn that since one of the first things SQL does on startup is create a new...

I am interested to know last time a database was accessed Pleas.e

just realized someelse posted the same question here http://www.sqlservercentral.com/Forums/Topic1082117-146-1.aspx