Viewing 15 posts - 42,121 through 42,135 (of 49,571 total)
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic626594-1291-1.aspx
December 29, 2008 at 10:47 am
RBarryYoung (12/29/2008)
Jim Russell (12/22/2008)
Do you think we could convince Steve Jones to allow .sqlplan attachments?sqlplan files can be attached as .TXT files.
Or zipped and attached, which I personally prefer as...
December 29, 2008 at 10:38 am
Jeffrey Williams (12/29/2008)
December 29, 2008 at 10:37 am
jasmineywchen (12/29/2008)
I'm using 2005 and have attached the execution plan with my reply.
Please post in the correct forum in the future. If you post in the wrong forum, people are...
December 29, 2008 at 10:35 am
Alos you need to enable the traceflag globally. If you just do TRACEON(1204) then it's only active for that session, which means you'll never see a deadlock graph as it's...
December 29, 2008 at 7:56 am
prasad (12/29/2008)
December 29, 2008 at 7:54 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic626488-9-1.aspx
December 29, 2008 at 7:53 am
Kerry Tyler (12/29/2008)
December 29, 2008 at 7:49 am
The IO warnings are just saying that you're overloading the IO system and the latency is getting very, very high.
Is the second sp_spaceused that you posted from the processcontrol table?...
December 29, 2008 at 1:43 am
I can see one potential problem right away. Activity_id in the journal table is a varchar(50), but in the query you're joining that to a decimal. That's going to cause...
December 29, 2008 at 1:37 am
guptaajay1985 (12/28/2008)
Thx sqlservercentral members for the replies:1.I have not a clean (uncorrupted) backup.
2.Yes, If I lost a bunch of rows from that table,it would be a disaster.
I hate...
December 29, 2008 at 1:20 am
And read through this - http://www.sqlservercentral.com/articles/64582/
December 29, 2008 at 1:09 am
Access doesn't have a query analyser. There's the query design too inside Access, but that's all I know of for it.
December 29, 2008 at 1:05 am
fakru.y (12/26/2008)
we are planning to tune the sp's and changing temp tables to permanent tables in the db. will it help?
Maybe. But if all you're doing is changing the temp...
December 28, 2008 at 2:09 pm
ALZDBA (12/28/2008)
GilaMonster (12/28/2008)
December 28, 2008 at 1:59 pm
Viewing 15 posts - 42,121 through 42,135 (of 49,571 total)