BobP - BIM's Q&A profile

• SQL Server distinct count with multiple partitions?

  We analyze much of our data using distinct measures. Some of the underlying sources - i.e. daily page views are heavy and have millions of rows a day. Because of this I've created daily partitions to only process the incremental data that's arrived. However, I'm curious - how does distinct count perform when it needs to rollup over multiple partitions IE Say it's Dec 25th, and I have 25 unique partitions for each day of December thus far. Internally, how do the distinct measures correctly accumulate the unique instances of my measure Are there any significant performance concerns to be aware of Arjun: Make sure you are on at least SQL 2005 SP1 QFE rollup, preferably SP2 CTP2. There were a couple of bugs ...Show All

• Internet Explorer Development IE 7 opening to Run Once page with error on it.

  I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. The error appears to be a web page error I copied what was displayed for the error Line 56 Char:2 Error 'windows.external' is null or notan object Code O URL:http://runonce.msn.com/runonce2aspx ...Show All

• Windows Forms I need a .NET 1.1 Windows Form app, but I don't have the tools...

  I am in need to create a small, simple Windows Form Application in .NET 1.1. The problem here is I do not have access to any tools except for the Visual Studio 2005 Express Editions. Can anyone redirect me to some place that I can download a tool to develop my Windows Form Application in .NET 1.1 Basically what I need it to do is this: if (System.IO.Directory.Exists("C:\\WINDOWS\\Microsoft.NET\\2.0\\") { //... } Any advice is greatly appreciated.. the only way to create a .NET 1.1 app is to purchase the Visual Studio 2003 product, or use notepad and manually type out and compile code using the installed .NET 1.1 framework compiler for C#/VB.NET ...Show All

• Visual Studio Team System Use The TFS Object Model API To Set CreatedBy And Other Restricted Fields

  Hi, I am trying to write a tool to migrate all of our current bug tracking system data across to TFS and am trying to find a way of setting the CreatedBy/CreatedDate fields via the API and also set the State/Reason fields without having to follow the transition rules. I have read in a previous thread that there is meant to be some sort of way of bypassing these restrictions (although the thread is now a year old and wasn't very clear on how it can be done). Could someone please shed some light on how/if this can be done via the object model or even some other way if necessary Also, I have also read that there is meant to be some XML format that can be used to import work items into TFS, if someone could elaborate on this it would be a lot ...Show All

• Visual Basic Clearing all TextBoxes on a TabPage

  I want to write a small routine to clear all text boxes on the presently opened TabPage. Please help. I am using VB.NET 2003. K.Rohit wrote: Paul, It is not clearing the TextBoxes. It sounds like you might have TextBox controls nested within other controls. Try this snippet Dim toVisit As New List(Of Control) toVisit.Add(Me) Do Until (toVisit.Count = 0) Dim cur As Control = toVisit(0) toVisit.RemoveAt(0) For Each child As Control In cur.Controls toVisit.Add(child) Next Dim tb As TextBox = TryCast(cur, TextBox) If tb IsNot Nothing Then tb.Text = String.Empty End If Loop Let me know if that works ...Show All

• Visual Basic Converting a string into required date format in vb.net

  Hi friends, I want help in converting a string which contaions 5 numbers,into a required date format for the code below: dim strDate as string dim objdate as Date strDate = "60727" //6 as yy 07 as mm & 27 as dd strDate = strDate.Substring(0, 1) & "-" & strDate.Substring(1, 2) & "-" & strDate.Substring(3, 2) objDate = Date .Parse(strDate) while executing it returns 6/07/2027 which means 27 as year while i want 27 to be a date. and format should be exactly 2006-sep-27.So plz help me regarding this code. the formatting is done when you call the ToString() of the date object, giving it the format type ...Show All

• Visual Studio Express Editions Need help please

  Hi im new here and in need of some help. i had downloaded Visual Basic 2005 Express edition, and used it for a couple of months, i need it for a college unit i was compleating. but its been ages since i use dit again. now it asks me for a registration key!!!! how and where do i get this registration key i have checked all my e-mail and have recieved nothing, and now im stuck, i have no idea on what to do, because i now want to remove the program from my computer because its taking up 588mb and i dont even use VB anymore. but it wont remove, could this be because of the registration key you see VB does not even open, as soon as i try and open it a message box appears asking for the registration ...Show All

• Visual Studio JIT debugging from remote PC

  Hi, I'd like to do remote-jit debugging; ie: The software runs on a PC without VisualStudio, but with the remote debug components installed. The remote debugging works fine: I can remotely attach a Visual Studio 2003 debugger to the process and debug it. Now, what I'd like to do is to attach my remote VisualStudio 2003 debugger only AFTER an error occured ... (JIT debugging) Is that possible Thank you for any help Stephane ...Show All

• .NET Development Wireless API and samples question WinXP with SP2

  I needs search all avable network and connect to selected in WinXP SP2. I've found Native Wifi do all that I needs, aslo it have patch for Windows XP SP2. Also I'we read that samples how it works are in SDK. I've downloaded this: http://www.microsoft.com/downloads/details.aspx FamilyID=22b58b6c-8f98-40d0-880d-c3339c5da01e&DisplayLang=en but thereis no WiFi samples found. Where I can get them If it possible only WiFi without others. may be someone have another samples can search and connect networks under winXP SP2 If this problem can be sloven through registry tweaks -I'll be plasured much for that info (I've found only preconnected networks there). Summary questions intrresting in: 1. Any samples depends ...Show All

• Visual C++ Managed code compilation

  I know Native C++ makes a more resource efficent program than C#.NET or VB.NET; I also am pretty sure it makes a more efficent code than Managed C++ (correct me if I'm wrong) What I would like to know is if functionally equivalant managed C++ code is more efficent than C# code Thanks in advance. well I know C#, VB, and C++ so I am willing to use whatever combination gets me the best performance lol this thread is becoming a mess, wouldn't calling the dll use extra resources ...Show All

• Visual Studio Tools for Office Vsot - Outlook - The macros in this project are disabled. How to enable macro in outlook

  I was testing my VBA codes in outlook. Everytime I run the code the following error would come up. The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros. I tried uninstalling Outlook and reinstalling. It doesn't help. How do I enable the macros in outlook. Macros in word works fine. Help thanks Which Outlook Version XP and 2003 should be: Tools->Macros->Security: set to medium so you get asked if you want to activate macros. -- SvenC ...Show All

• Windows Forms Need help updating data to multiple tables

  My project has a two tabbed form. One tab contains a bunch of text boxes bound to a "ContactInfo" table in my database. The second tab contains a bunch of text boxes bound to a "AlternateAddress" table. Each table contains a contactID column that is a primary key in the "ContactInfo" table and a foriegn key in the "Alternate Address" table. I have two binding sources. The contactInfo binding source is looking at the dataSet.ContactInfo. The alternateAddress binding source is looking at the contactInfoBindingSource.altAddressContactId_fk. This works for viewing the data and I can make changes to the contactInfo table by first getting it's changes and then doing: contactInfoTableAdapter.Update(data ...Show All

• Windows Forms Module msxml6.dll failed to register.

  I have a Windows Forms solution with many managed projects, and a few unmanaged projects. I have a deployment project that works, except that it gives an error "Module (app directory)\msxml6.dll failed to register. HRESULT -2147023782..." If I hit continue, the installation finishes, and the application works fine. How can I get rid of this error The MSXML6.DLL file does not appear in the list of files for Application Folder, although it is a dependency of one of my unmanaged projects. The target machine has the XML6 Parser installed, so I don't need Visual Studio to deploy that file. Dave Karthikeyan U wrote: Try this. Open File sytem editor of the Setup project., set 'Register' proper ...Show All

• .NET Development Debugging using STA

  In my program I have to use STA. How can be Mdbg used with STA I'm running Mdbg in MTA thread that starts a new STA thread and opens a WPF window. This works. But only one time. If I close this window and then start this thread one more time, I get exception from WPF, that says, that I'm trying to access object from other thread. ...Show All

• Visual Studio Tools for Office Dynamic Controls Within An Outlook 2007 Form Region

  my users can setup a list of user defined fields. i need to add a control to my Outlook 2007 form region when it loads for each of UDF's that my user has setup. is this possible thanks. p.s. i have tried placing the following code within my form region constructor, but it does not populate the text property. Outlook. OlkTextBox dynamicTextBox = new Outlook. OlkTextBox (); Form.Controls.Add( "Forms.TextBox.1" , dynamicTextBox, true ); dynamicTextBox.Text = "Hello world!" ; You need to use the Outlook.* controls, which are specifically designed with the features they need to function properly on an Outlook form surface. ...Show All