Viewing 15 posts - 17,521 through 17,535 (of 22,214 total)
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...
May 6, 2009 at 12:43 pm
Based on the name, vWorkflowTransition is a view. That means it's probably hitting both tables and maybe more.
May 6, 2009 at 12:34 pm
Alvin Ramard (5/6/2009)
May 6, 2009 at 8:24 am
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...
May 6, 2009 at 7:45 am
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...
May 6, 2009 at 7:41 am
pushpa.kumari (5/6/2009)
Hi,text datatype can have maximum length of 8000.
I think you should break your dynamic query into 2-3 parts.
Text doesn't actually have a limit that low. Large Objects, LOB...
May 6, 2009 at 7:11 am
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...
May 6, 2009 at 7:08 am
Dugi (5/6/2009)
Grant Fritchey (5/6/2009)
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.
Yep, my friend...
May 6, 2009 at 7:06 am
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.
May 6, 2009 at 5:40 am
Yeah, I was wondering the same thing. Can you post the two execution plans, the good one and the bad one?
May 5, 2009 at 3:33 pm
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...
May 5, 2009 at 1:21 pm
RBarryYoung (5/5/2009)
May 5, 2009 at 11:58 am
RBarryYoung (5/5/2009)
Alvin Ramard (5/5/2009)
David Burrows (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.
Lucky for the OP that is was not Jeff, Pork Chops...
May 5, 2009 at 9:16 am
You're way too nice Lynn. I would've walked away. If I need people yelling at me when I'm trying to help, I can go home & help the kids with...
May 5, 2009 at 6:58 am
Luke L (5/5/2009)
May 5, 2009 at 6:53 am
Viewing 15 posts - 17,521 through 17,535 (of 22,214 total)