RBarryYoung (5/6/2009)

---

Grant Fritchey (5/6/2009)

---

I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly...

I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly Darth, but Darth...

Can you run a query against sys.dm_tran_locks? That will give better information. Specifically we need to see the entity_id, the object getting locked.

Triggers? Foreign Keys? Rules? Constraints?

There has to be something. You won't get a block... a block, which has a very specific meaning and refers to one process waiting on the...

Based on the name, vWorkflowTransition is a view. That means it's probably hitting both tables and maybe more.

Alvin Ramard (5/6/2009)

---

I agree with Grant and I would recommend Microsoft Visual Studio. I would pick VB over C#. You probably would find that a bit easier to...

If your users just need to read data then maybe all you need are some reports written through SQL Server Reporting Services. These can be fed through the web and...

It really depends on the business requirements. But if you're dealing with hard numbers, I'd use decimal instead of float. Float is an approximate number. This is from the BOL:

Approximate-number...

Text doesn't actually have a limit that low. Large Objects, LOB...

I agree with the use of the information_schema instead of the system tables. There've been quite a few changes in how those system tables behave, what you can, etc., between...

Dugi (5/6/2009)

---

Yep, my friend...

You can call it from the command line. If you had to do it through TSQL, you could use xp_cmdshell, but I wouldn't recommend it.

Yeah, I was wondering the same thing. Can you post the two execution plans, the good one and the bad one?

Ah, I didn't know about the linked server before. Not that it gives me an idea what the problem is, but it does toss another wrinkle into the issue.

For those...

RBarryYoung (5/5/2009)

---

Though you may not have intended offense by this it is nonetheless somewhat offensive. I could just as easily turn this around by saying that "Nobody wants to...