Viewing 15 posts - 17,506 through 17,520 (of 22,202 total)
RBarryYoung (5/6/2009)
Grant Fritchey (5/6/2009)
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly...
May 6, 2009 at 2:59 pm
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
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...
May 6, 2009 at 12:53 pm
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.
May 6, 2009 at 12:50 pm
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
Viewing 15 posts - 17,506 through 17,520 (of 22,202 total)