Search results for query: *

Did not hear back on this one. Has anyone experienced a similar issue? Thanks a lot for reading.

Hi All, I have a WCF service hosted in windows and a thick client communicating with it. I have been experiencing timeouts on certain calls as well as the following Warning in the event viewer: Error invoking subscriber. Method = <Method Name> Error details =...

Yes _ was able to solve this. I had to set the target platform to 32-bit(explicitly) in the project properties page and it solved my issue. Thanks for following up.

Hello Everyone, I have a winforms application (barebones) that I developed using VS2008/.Net2.0/WinXP. This is intended to be a prototype. The application also uses interop to communicate with a couple of legacy COM components. Everything works fine. When I copy the files over to...

it does not say "used ram" It says "Physical Usage" on the status bar at the bottom of the screen. I am assuming "Physical Usage" means "Physical Memory Usage". Yes I am using the latest version of procexp. Thanks for your help.

Hi All, I am trying to resolve some memory issues for some workstations in my company and using Process Explorer(tool from SysInternals). I am trying to understand some of the numbers that the tool uses: 1) Physical Usage - this is a number which is shown in the the status bar(bottom of the...

Is there any way to recover a deleted stored procedure in SQL Server? Unfortunately I do not have any back up of this particular database. Thanks so much everyone. R

Hi All, This might not be the most appropriate forum for this post but I am still giving it a shot. We are a mid sized development shop and will be working with multiple clients having different requirements for the same software. As a result, it is very important for us to maintain different...

Thanks guys!

Hi Guys, Either with mirroring or replication, is it possible to have different file structures in the primary and secondary servers? By this I mean, there might be 2 filegroups in the first server with tables allocated amongst those groups and possibly 4 filegroups in the secondary server...

We do have downtime allocation. But I am trying to see how people have zero-downtimes. We support the Healthcare industry which require 24/7 uptimes. Right now we are developing an enterprise product which requires frequent fixes(every 3 weeks). I am just trying to see if there is anyway we can...

How about if we get away from clustering and use mirroring instead? Thanks to both of you for joining this discussion.

Hi Guys, We are trying to decrease the downtime for our enterprise applications. I would welcome ideas from all of you on how you do database upgrades(application upgrades not system upgrades like service packs etc.) while minimizing downtimes. Is there any way you can have your users using...

Yes I tried the same syntax. But it was my bad - I was trying to make the select from the wrong database. LOL

Hi All, I was doing a select from dm_db_index_physical_stats view from our production server. Each entry has an object_id but when I try to convert them to object_name then I see the values as null. Any ideas? Thanks A Example Object Name Object ID Index Id index desctipion NULL...

Paul, I detected the missing clustered indexes but had re-created them. The problem exists even after I had made the changes and rebuilt indexes on the other columns. In fact a couple of tables where rebuild did not work(clustered indexes exists on these tables), I dropped the clustered...

That does make sense. Some of these tables might not have had clustered indexes and I think I had created them. But I did not transferred the data to a temp table and moved it back in. I had assumed that creating a clustered index on an identity column would correct the fragmentation. Is that...

Oh an important thing - I also found out recently that SP2 on SQL Server(2005) was not applied completely. This was by our System Administrator. I am not sure to what extent SP2 was successful. Just wondering if this can have an impact on index rebuilding).

I tried doing a rebuild but unless I change the fillfactor considerably, the result is the same(70% defrag).

Hi All, I am having a weird issue. I have overnite database optimization jobs which do re-indexing(we do reorgs as opposed to rebuilds). What I have seen lately is that the fragmentation does not decrease to the extent it should in case of a set of tables. For eg. if before the job...