Search results for query: *

Thanks for post. I read through this and a number of other pages but I find a bit difficult to find a site that really helpps you read the log. I have learned a lot about deadlocks and what there are/how they happen but understanding the log has been a little tricky...do you have any other...

Hi again, Can someone help me understand how to probperly read the information in a deadlock... ResType:LockOwner Stype:'OR' Mode: IX SPID:68 ECID:0 Ec:(0x51913598) Value:0x5b081bc0 Cost:(0/0) Victim Resource Owner: ResType:LockOwner Stype:'OR' Mode: IX SPID:68 ECID:0 Ec:(0x51913598)...

Sorry but I have another small question...When the deadlock is logged is this always a big deal? CES

In the QA I can see the table under the DB but when I run: USE DB SELECT * FROM [DB].[dbo].[sysobjects] WHERE id = 2037582297 I get no records. Is it possible that there is a big problem here? Maybe corrupt table? CES

Hi, I also tried running that command on the other id and it returned a different table than when I query the sysobjects table...are you able to clearify what I am doing wrong? CES

Thanks for the reply!! When I run that I get the table that I suspected...can you tell me why that id does not come up in the sysobjects table? CES Also, do you have any suggestions of where to get more info on understanding this log reading?

Hi, I am loocking into deadlocks and am logging the events now...I have found an event that I cannot seem to find the corresponding table by the ID given...in one of the occurances: ResType:LockOwner Stype:'OR' Mode: X SPID:63 ECID:0 Ec:(0x4408B5B8) Value:0x5c5785e0 Cost:(0/0) Victim...

Thanks for the suggestion...I just went looking for a book at lunch and couldn't find an appropriate one. I'll check this one out. CES

Thanks! Do you have any suggestions of where to look for performance issues? I am currently looking into Deadlocks and I will add the parameter -T1204 to output deadlock info to the log file. I see that it outputs the DB and Table involved but I need a way to find the SQL involved by either...

There are only 893 rows...this was just one of the samples. I was also doing some reading on the fill factor and plan to adjust the fillfactor on the tables as per the rule of thumb that I found...100% for Low Update tables, 50%-70% for High Update tables and 80%-90% for everything in between...

The fill factor is currently 100 but I am looking to optimize the SQL Server performance. This is an old poorly written DB and I have been asked to look at it and attempt to optimize it. I first found that it was badly fragmented and figured it was a good place to start. If you have other...

Here is one table: DBCC SHOWCONTIG scanning 'FSBO_Notify' table... Table: 'FSBO_Notify' (585769144); index ID: 1, database ID: 15 TABLE level scan performed. - Pages Scanned................................: 4 - Extents Scanned..............................: 3 - Extent...

Hi, I am trying to defrag a table that is 50% fragmented and it doesn't seem to be working. I found out it was fragmenetd using DBCC SHOWCONTIG and after I run DBCC REINDEX I get the same results. Any suggestions why I might be seeing no improvements? On one of the tables I am trying to...

Thanks for the suggestion Sheco! I will look a little further into this but so far I can't seem to get this to work with compressing images. Thanks for the replies. CES

Sorry... Thank you for the replies... I cannot change the format of the file, it must stay in doc format. If you have an image in a word doc and right click it, you can select Format Picture and then click Compress....then All pictures in document. This shrinks the doc size. Picture still...

Hi, My problem is that I have these Word documents that are too large in size, upwards of a MB. These documents have images in them. I can manually go in an right click an image inside the document click Format Picture then click Compress... then select all pictures in the document and save...

Hi, Is anyone able to shed some light on this error... The RpcImpersonateClient call failed with the following error: No security context is available to allow impersonation. Any ideas of how I can go about fixing the problem? CES

I found exactly what I was looking for on the microsoft site... http://support.microsoft.com/default.aspx?scid=kb;EN-US;q309535 This link is a step by step for validating XML by a Schema. Hope this can help someone else. CES

Hi, I am brand new to XML and I was wondering if someone has some sample code to validate and XML file against a schema using VB to get me going? CES

Thanks again for the reply. I guess what I am really not seeing is how I can create an xml document and then validate it programatically useing php for instance. All I really need to get me going is a very basic xml doc and a very basic schema. Then maybe directed how I go about validating...