Jkumar's Q&A profile

• SQL Server Memory dropping

  We recently had a problem with our memory dropping on the windows taskbar to under 2 gig. We are running SQL Server 2005 in a 64 Bit environment with 16 gig of ram. Most of the time the memory was around 13-15gig. When it dropped that low our server's CPU utilization went to 100% and stayed there... Has anyone else had or heard of this problem Thanks, Bret. There are a number of potential causes for this. However, with the description you provided, it is hard to understand what could be causing the problem. You should view some of our webcasts on Performance Troubleshooting and tuning. You can find them here: http://www.microsoft.com/webcasts/ http://www.microsoft.com/sql/techinfo/even ...Show All

• Windows Forms Tab Spacing in List Boxes

  I would like to change the effective spacing of tab characters (chr(9)) in list boxes. Does anyone know how to do this This would allow me to align text in a list box in a tabular manner without using monospaced fonts. As it is, the default tab spacing (8 em spaces ) is too large. Technically, it is possible. You can send the LB_SETTABSTOPS message to the Windows listbox control. The P/Invoke is very difficult though. A much easier way to accomplish this is to use a ListView control in Details view... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA/Xbox 360 memory management heads-up...

  I was just browsing through some docs on the 360's heap manager, and it turns out it is a compacting mark and sweep collector rather than the generational model used on the desktop... So... what's the deal regarding: Large block allocation (will it have a large object heap like the desktop version ) GC pauses times (do all threads halt during GC) Rico Mariani recommends a heap size equivalent to the Gen 0 size on the desktop, i.e. ~cache size. That seems way too small unless we are dumping lots of game data into unmanaged memory! Andy. We actually do allow C# unsafe code blocks on Xbox, including arbitrary pointer arithmetic. You just don't have any way to P/Invoke into native code from the managed san ...Show All

• Software Development for Windows Vista Workflow Persistence, Idle Workflows and External Events

  I've been doing some thinking about how the default workflow persistence services work and how it affects those of us writing complex event-activities (i.e. IEventActivity implementations), and I was curious about something. I was reading Paul Andrew's comment on how the default workflow persistence service will only load persisted workflows that are "ready to run", and how it worked with locking when multiple runtime instances across a farm were using the same persistence database (all very informative stuff). However, what I'm not quite clear on yet is what the "readiness to run" of a persisted workflow is determined. Could someone expand on this a little bit Here's what I'm trying to find out: For example, if an act ...Show All

• Software Development for Windows Vista SOAP toolkit doesn't install on Vista

  I have an application that makes use of the MS SOAP toolkit on many of my customers XP machines and when upgrading to Vista the SOAP toolkit no longer works. It appears the registry entries for it are no valid. When the installation for the toolkit is tried cetian DLLS are not getting registered propertly. We cannot move the application to make use of native .NET SOAP and need to get this to work and I was wondering if anyone has run into this Thank you Peter and I am aware that MS does not support SOAP toolkit but at the moment we cannot change over to using the web services of .NET on Vista and still need to use the SOAP version until we migrate the app using SOAP to .NET. The problem we are having has to do with the installation o ...Show All

• Windows Forms Unicode encoding

  Hello, I have a .NET 1.1 Windows Forms application using SQL Server 2000 database with the default Latin collation. Are these the steps i need to take to make this application to accept , save and display an Asian language like Japanese . 1) Change the collation of database to JAPANESE_UNICODE 2) Change all varchar to nvarchar, text to ntext, char to nchar 3) Prefix all strings with N in SQL queries. Are there any other steps required Thanks, CR. ...Show All

• SQL Server Question: About RDA.SubmitSQL

  I understand RDA.SubmitSQl is for Submitting SQL statements for execution on a database in Microsoft SQL Server on a remote server. What if I sumbit a Query like this : RDA.SubmitSQL("Select Max(CustID) From CustomerTable"); So can I get this value back to my local client to use Please help me out. Thanks. James RDA.SubmitSQL does not return you any result set. It only returns whether the execution succeded or failed and nothing more. You should be using RDA.Pull in the above case like: RDA.Pull("MaxValueTable", "SELECT Max(CustID) FROM CustomerTable"); Of course, I agree that you will have a pain/perf-hit of CREATE (internally by RDA) and DROP (b ...Show All

• SQL Server Trouble with Package Configuration

  Hello I'm having trouble setting different variables in my configurationfile. I've a "Send Mail Task" and apparantly I cannot change subject, if subject contains other variables For instance. "User-defined Search Result: Succes - Order no.: " + (DT_WSTR, 10)@[OrderExtract::order_id] If I look in the .dtsConfig it shows: User-defined Search Result: Succes - Order no.: 0 , and even when I try to change User-defined til Userssss-defined it has no effect. Am I doing something wrong Kind regards Janus, DK The reason your configuration file change is having no visible effect,is because the configured Subject property of the send mail task is later overriden by the expression ...Show All

• SharePoint Products and Technologies Changing applicaiton pool account

  A mistake was made during setup and an actual user account was used for the application pool acount. If I simply go to SharePoint application pool and change the identity to Network Service the SharePoint web site show "Cannot connect to the configuration database." How can it be changed now Which account should be used for administration application pool Your help is appreciated. You should run the application pool with a user account - create a system user (for example sys-SharePointAppPool) and use it for the application pool. But since that account needs access to the databases, you should also go into SQL and give it security permissions to the database manually. ...Show All

• SQL Server can't install a CLR stored procedure

  I have written 2 CLR stored procedures. I have a local copy of our database to which I was able to successfully deploy them. When I changed the connection string to our production database, it fails when I try to deploy. It gives me an error... EXTERNAL ACCESS ASSEMBLY permission denied on object 'server', database 'master'. I've logged onto the database server and set trustworthy on for that particular database. I also tried... CREATE ASSEMBLY UpdateJobAdSearch FROM 'I:\DLL\Candidate.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS Candidate.dll is the stored procedure dll. I also read on http://msdn2.microsoft.com/en-us/library/ms345106.aspx about doing something like.... USE master GO CREATE ASYMMETRIC KEY CandidateKey FROM EXEC ...Show All

• Visual Studio 2008 (Pre-release) Content Loaded Event for FlowDocumentReader

  Hey all, see if you can figure this one out: I am dynamically building custom content blocks and adding them to a FlowDocumentReader at runtime. I then need to loop back through them and selectively change the background color of the blocks (highlight) based on a preferences file that is persisted to disk. I can do these things just fine and the app works great except that I'm having a problem when the number of blocks added to the reader is so great that the reader has not completely loaded the blocks yet when the code is executed to highlight them. Obviously, there is an Object Reference error because the FlowDocumentReader is working asynchronously to finish loading all of its content and the block to highlight has not been loaded ye ...Show All

• .NET Development Large payloads and memory allocation

  I have a web service method that returns a fairly large payload - around 70MB of xml. The client application break on receive with the OutOfMemory exception. Now, I understand that even though my workstation has 2 gigs of RAM it doesn't mean that all of that is available to my application. But how do I know how much memory IS available How is the memory allocated How can I calculate the hardware requirements for my scenario I'm glad that you found it helpful. I realize that I said "OutOfMemoryException" and then sent you the SocketException. The truth is that half the time the error is on the server and then I get the "out of memory" when I try to load the XmlDocument from large file a ...Show All

• Visual Studio Express Editions Visual Basic Express Edition E-book

  Where in the registration portal is the link to download the e-book for the Visual Basic Express edition. Can anyone please help me. I am a beginner. Any ideas or recommendations woud help. Hello I just wanted to ask Can the e-book be redistributed as said by the EULA I never read that EULA... Email me knvb1123@gmail.com Keehun Nam ...Show All

• Visual Studio Express Editions Newbee needs help creating COM dll

  Hi, I want to try to create a COM dll for database transactions. I going to use it in my ASP (VBScript) project. Does anyone know where I could find a tutorial for this Thanks! You can do it in C#, although I'm not sure if the Express edition supports it. Start reading here ... ...Show All

• Visual Studio Express Editions VCSExpress Database Explorer does not have SQL Server 2000 option ?

  Hello, I have recently installed Visual C# Express ( VCS Express ) and also Visual Web Developer Express (VWD Express). In VWD Express` Database Explorer, I can connect to the following five data sources :- - Microsoft Access Database File - Microsoft ODBC Data Source - Microsoft SQL Server - Microsoft SQL Server Database File - Oracle Database But in VCS Express` Database Explorer, I only have two data source options listed - Microsoft Access Database File - Microsoft SQL Server Database File Is it possible to connect to SQL Server 2000 from VCS Express` Database Explorer Thank you for your time and for responding, Best regards, James hi, i don't have any sqlserver2000 data ...Show All