I have been bitten badly by this bug.:-)

I was recently trying to copy db mail settings from one server to another and somehow managed to mess up the "good" profile...

Thanks both; yes, I did not consider the obvious option of adding the OPTIMIZE FOR hint directly in the code:

SELECT ...

...

OPTION (OPTIMIZE FOR (@UserId = 4))

I will try that now.

If...

The weirdest thing; the SQL stmt is actually enclosed inside a "SELECT * INTO #tempTable FROM ..." statement.

As soon as I included that as well, it worked:

EXEC sp_create_plan_guide

@name = N'guide__procName',

@stmt...

I'm not familiar with this particular error, but I have seen appdomain errors in the past as being caused by the SQL buffer pool taking up all available memory on...

Thanks all!

Since my post three and a half years ago, I have had the chance to use IGNITE extensively and am now a devoted fan. This tool has become an...

opc.three (3/27/2012)

---

I include msdb it in my index maintenance job. It does not require downtime, it may just block other processes while the indexes are being rebuilt...a normal side effect...

Thanks both for your suggestions.

I'm also looking into some large indexes that over the last couple of months have hardly been used for seeks/scans/lookups (<10) but have undergone millions of...

Christoph D (1/12/2011)

---

Seems like a good way to go but keep in mind to do a complete rebuild once in a while, reorganize won't "refresh" the Fillfactor (except if you...

Thanks, I'll need all the luck I can get. 🙂

Revenant (2/17/2012)

---

Jeffrey Williams 3188 (2/17/2012)

---

It makes sense to test as you have outlined.

I am thinking that you won't find much in the way of usage of the transaction log. ...

I would agree on this one. I would just go the route of altering the column; this statement is supposedly best optimized to handle this sort of change.

Related it to...

After reading through this article - http://www.sommarskog.se/grantperm.html#certcrossdb - I think I will go with certificates, specifically a certificate shared in common by the 2 databases that I need to work...

Thank you all for your replies.

Anyone else? I would be interested in a few more replies, just to get a better feel of what people are doing out there.

Thank you all for the suggestions, we are considering all these options.

Sorry, I don't follow, can you...