MIKEDBA's Q&A profile

• SQL Server SSAS 2005 Memory configuration on 64 bit

  Hi all: Another one for the specialists. We are currently running SSAS 2005 on a twin-CPU 64-bit box with 12 GB of RAM. The cube is particularly huge in size and some queries can really hit the server bad. However, after a point of time, SSAS 2005 begins to page and that brings the whole server down to run slower than a yesteryear 386. So my question is : Is there a way I can influence SSAS to use more RAM, rather than paging awa ...Show All

• .NET Development Registering events dynamically with a remote object

  Ok where do i begin... well i am trying to come up with a solution to allow me to register event handlers with an event dynamically. Consider the following code if (aEvent.Name.CompareTo("getFilesCalledEvent") == 0) { Delegate myDel =Delegate.CreateDelegate(aEvent.EventHandlerType, this, "EventCalled"); aEvent.AddEventHandler(this, myDel); } As far as im concerned this should register the method EventCalled contained in th ...Show All

• Windows Forms Argument Exception

  Why would this not work Any help would be appreciated. Platform is Windows CE buildComboBox(_patientDs ,"--Select Patient or Create New--",cboPatient, "SelectedItem", "intEpisodeID"); Fails here cb.Items.Add(new CValue(strInitialValue, -1)); private void buildComboBox(DataSet ds, string strInitialValue, ComboBox cb, string SelectedItem, string ValueMember) { try { cb.DataSour ...Show All

• SQL Server Default value for lookup

  How can I specify a default value to return into the lookup field for Lookup Transformation - if the value did not found on the Reference Table Do I have to this another way (after doing the lookup) /Yossi D. Perhaps you could go to the Advanced tab and adjust the lookup query SQL to return a default value. (I haven't tried it.) Or Set the error option to ignore, so your rows that failed to return a value just f ...Show All

• Architecture Drive mapping issue

  I have installed Windows XP professional and in My Harddisk i have three partitions ,namely c:.d:,E:,apart from this i map network folder to drive to f:,but when i do that and then i insert my usb Mass storage ,it get displayed in the device manager but i dont see it in the "MY Computers". whereas if i dont map anything to drive f: and then if i insert my usb mass storage ,then it shows up as drive f:. is this a microsoft bug or im mis ...Show All

• Windows Live Developer Forums Does MS support these forums? Search api question...

  Greetings, I wanted to ask something. I have 3 websites on the same IP (shared hosting), I have 1 AppID for each website but all requests are coming from the same IP for all 3 sites. Do I have 10,000 queries per day total or 10,000 for each site I tried this question on the Live Search development but nobody answered this past week. I've also mailed microsoft but no reply from there to :/ I'll very much ...Show All

• SQL Server Properties affected by Expressions

  Hi, is there any way to see which property is changed/affected by expressions If not that would make things really complicated because you look at a property and it seams to be OK but the task doesn't do what it's supposed to because "behind the scenes" the setting is changed by an expression... Thanks, Take a look at the updated UI for the File Watcher Task. I expose the expression instead of the property when set. Hope MS implement some ...Show All

• Visual C# Program doesn't Terminate

  I've made a program that has a thread that continuously receives the bytes from a server via socket. The code is like this: data = new byte[1024]; receiverThread = new Thread(new ThreadStart(Rec)); receiverThread.Start(); public void Rec()   {    while(true)    {     try     {       recv = client.ReceiveFrom(data, ref remoteEP);    ...Show All

• Software Development for Windows Vista Register Windows Vista SDK Beta 2 in Visual C# Express

  Hi folks, I recently installed Visual C# Express. No I downloaded and installed the current Vista SDK. How do I register the SDK now with my Visual C# Express, so that I can add references, etc. The corresponding tool for registering the SDK seems to be working only for Visual Studio 2005 or C++. Not the express edition. Can anyone help please Thanks and best regards, Christian. You don't need to ...Show All

• Visual C# plz help re-write vb code to c# code

  hi i am new to c#.net, currently on MSDN library page learning the "New DataSet Features in Visual Studio 2005", I saw this chunk of code which is writen in vb.net, because I am learning c#.net, can any one plz help me translate this code into c# so that I will be able to understand the code better. thx in advance, the code is here: Partial Public Class NorthwindDataSet Partial Class OrdersDataTable Protected Sub ValidateNewRow(ByVal sen ...Show All

• Visual Studio Sample web site printing from Crystal report viewer - print mode ActiveX

  Is there an online site that has sample reports that I could see directly. We are having trouble printing and I would like to see a web site with crystal reports using the Crystal reports viewer, Active X that will allow me to print to my local machine. LOL, I sometimes feel that is where Business Objects should be directing me. At least then I would have fun instead of trying to pull partial information from 10 ...Show All

• SQL Server Users for encrypt and decrypt purposes only

  Hi there, Using symmetric keys and certificates in SQL2005, can one assign users permission to only decrypt or encrypt data Reason would be say data capturer and data reader type roles. I tried to create some with the GRANT CONTROL and GRANT VIEW for certificates and definitions on Symmetric keys, but havent been to successfull. Would be great if someone here can offer some advise on it, and if it's possible using SQL rights. thanks ...Show All

• Visual C++ VS 2005 Having problems after installation...Kernel.h with MFC

  I ordered VS 2005 Pro 180-Day Trial and I just started to try my old code peaces withit..I was having an error...then I decided to make a new project and wanted to walk like step by step...I tried to create various versions of MFC applications but I am still gettin the same error message... Output is like this -------------------------------- 1>Compiling... 1>stdafx.cpp 1>d:\program files\microsoft visual studio 8\vc\incl ...Show All

• Smart Device Development Windows Mobile 2005 - Can you reset/clear Database (EDB) sync flags/count to avoid sync with ActiveSync? Serious Bug in WM2005!!

  Hello All, On Windows Mobile 2005 - Can you reset/clear Database (EDB) sync flags/count to avoid sync with ActiveSync   I found a serious BUG with WM2005 because the replication values (bit based) APIs are non functional... Use for this is any type of application that would Backup the PIM (Contact, Tasks, Appointments) and any other databases and restore the database back to it's original value...  Currently there appears to be no wor ...Show All

• .NET Development How can I gen connection string in config file from server?

  Please help me ! How can I get connection string in web.config file from server when Remote Object has been registed on IIS The code details: Remote Object: Imports System.Runtime.Remoting Imports System.Runtime.Remoting.Channels.Http Public Class CustomerObject Inherits System.MarshalByRefObject Private m_strConnectionString As String Sub New () m_strConnectionString = System.Configuration.Config ...Show All