opc.three (9/8/2011)

---

In my opinion you have the best case scenario in terms of being able to associate every DB session with a specific person. In my experience most applications do...

All the auditing is handled by the application and oustide of SQL Server. I do keep tabs on thinsg myself outside of the apps paramaters but thats more passive...

ISSUE RESOLVED:

SOLUTION: Never Take Vendors Word Again Regarding A Problem, always verify

Back story (for the curious): A third party vendor that provides services for our accounting database pointed out some...

Thanks for the code suggestions, I will look at it when I next work on that project. As for the Unique ID nothing is done to it and the...

LutzM (8/16/2011)

---

I'm not sure if I'd go that route and update the original BankDepositNumber. I'd rather either add another column to the original table or even a separate table that...

Evil Kraig F (8/16/2011)

---

Let me break that down to what I think I understood. I'm going for the simplest format:

1) Find all accounts with a transaction on a date.

2)...

I’m not sure if the way I interpret what you are asking is right so let me give a quick break down (in pseudo code) of what happens and that...

opc.three (8/11/2011)

---

I wonder if Plan Guides would be useful here. Theoretically you could override the plan the Optimizer would use for that specific query text and that plan could be...

Whats SM MO?

Michael Valentine Jones (6/27/2011)

---

YSLGuru (6/27/2011)

---

Thanks for the link. I have a possibly dumb question though. When testing the code...

Well I do have SQL Monitor running and it is...

Sadly I haven't. That said there is some good news in this area. SharePoint has a new SP/Update coming out (may be out already ) that involves...

Heavy sigh...

I want to call them Query FRAGS instead of HINTS.

Thanks guys

Did the update have anything to do with Trace Flag 902 ? I did not see it in the list but I wanted to verify.

Gail,

i was thought so but hoped otehrwise. Thanks

BTW - I've always wanted to ask if your avatar is one of the chaarcters from the short lived Babylon 5 spin...