TheOneFD's Q&A profile

• SQL Server Fuzzy Grouping: Any success with > 3 million records?

  I have tried to process > 3 million Fuzzy grouping records on two different servers with no success. 3 mill works but anything above 4 mill doesn't. Some background: We are trying to de-dup our customer table on: name (.5 min), address1 (.5 min), city (.5 min), state (exact). .8 overall record min score. Output includes additional fields: customerid, sourceid, address2, country, phonenumber Without SP1 installed I couldn't even get a few hundred thousand records to process Two different servers - same problems. Note that SSIS and SQL Server are running locally on both The higher end server has 4GB RAM, the other 2.5 GB R ...Show All

• Visual Studio VS IDE crashes when debugging in managed or mixed mode

  I have a c++ project that uses a .NET 1.1 assembly as a com object. It is loaded with CoCreateInstance. If I debug in native mode it looks like everything works okey, in managed mode the application crashes with no errors or anything, and in mixed mode Visual Studio crashes. Something that looks somewhat suspisous to me is that it looks like .NET framework 2.0 assemblies and debug symbols are loaded. For example: 'MyApp.exe': Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\fusion.dll', No symbols loaded. 'MyApp.exe': Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\msvcr80.dll', PDB format is obsolete. 'MyApp.exe': Loaded 'C:\WI ...Show All

• SQL Server SSIS and Notification Service

  Does anyone know if the SSIS can integrate with Notification Services In which ways Thanks! Take a look at Michael's blog post on calling SSIS programmatically: http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx I believe Notification Services can call a web service when a condition is met; the web service could run the package. ...Show All

• SQL Server RTM Integration Services Job

  When I try to create a job step of type SQL Server Integration Services Package I get an error: =================================== The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI) ------------------------------ Program Location:    at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.Microsoft.SqlServer.Management.SqlManagerUI.IJobStepPropertiesControl.Load(JobStepData data)    at Microsoft.SqlServer.Management.SqlManagerUI.JobStepProperties.typeList_SelectedIndexChanged(Object sender, EventArgs e)    at System.Windows.Forms.ComboBox.OnSelectedI ...Show All

• Windows Forms Open a file using default application

  Hello, Back in VB6, I used the ShellExecute api to open a file using it's default application. In other words, .XLS files would open in Excel, .DOC files would open in Word, etc. The call looked like this: Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, _ ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long I realize this may be a stupid question, but is there a better/easier way to do this in .NET I find it hard to believe that the old method is still the preferred way ...Show All

• Visual Studio Express Editions Checking if application is already running

  I have added a context menu item to my application. The problem is that, if it is already running and I right click a file, another instance of the program opens up. How can I check if the program is already running, and if it is, how can I pass control to the existing instance Thanks in advance. Thanks to everybody who replied. I now have a lot to read, but I'm sure I will find answers there/ ...Show All

• Visual Studio 2008 (Pre-release) How to apply multi Transforms to Canvas.RenderTransform?

  Hi guys, I using Canvas UIelement to draw a rectangle with size (200,200). I want to move the rectangle to point (100,100), rotate with angle 45 degree and scale it with 50%. I can not apply multi transform to Canvas' RenderTransform property one time. Please help me to do it soon... Thanks, You need to group the transforms in a transform group. < Canvas Width = " 200 " Height = " 200 " Background = " AliceBlue " > < Canvas.RenderTransform > < TransformGroup > < RotateTransform Angle = " 45 " /> < Tra ...Show All

• Visual Studio Tools for Office Deploying Excel Smart Doc Solution to WinXp(Office 2003 NOT PRO) & Win2K(Office 2003 Pro): VSTO 2005 C#

  Hello I have deployed a SmartDoc solution to a clients machine (WinXP) and I have installed all the prerequisites and setup the security properties and when I run the Smart Doc excel file I cant use the SmartDoc pane (Document Actions _Other Tasks Panes). I have tried to search for it and no luck and i dont get any errors. The funny part about all of this is that I have another identical machine(Win 2k) and I have used the same deployment steps as in the WinXp machine and I am able to use the SmartDoc solution. Any ideas any body I know it is like searching for an exotic fish in a desert.   *   Uninstall and ...Show All

• Windows Forms docking control in Framework 2.0

  Dear all, Does anyone know if .NET framework 2.0 has a docking control just like the view in the visual studio I think this new version of .NET framework should have that. Thanks. TJ There isn't a docking control included in the .NET Framework 2.0.  There is however, movable/dockable menus and toolbars. You will need to buy and make use of third party products for this functionality. ...Show All

• SQL Server Gettint error "product level is insufficient" - did full re-install of SQL 2005 Standard Edition

  Installed SQL Server 2005 Workgroup Edition on a new server for testing. Installed SQL Server 2005 Management Studio on local PC. Created a database with a single table. Trying to run SSIS and export the database to a flat file. Get the error 0xc007470fe: Data Flow Task: The product level is insufficient for component "Destination - dbexport_txt [25]" I then installed SQL Server 2005 Standard Edition on the server as an upgrade of the existing instance and got the same error. Thinking this might be an upgrade issue, I completely uninstalled SQL Server 2005, rebooted the server, and then did a clean install of SQL Server 2005 Standard Editio ...Show All

• Visual Studio Team System Best Practice of building shelved code...

  If there exists a code branch and off that branch a developer has shelved code, is it possible to build that branch using the shelved code or does there need to be a merge prior Am I correct ot think that if we really want to build a branch with shelved code, we should branch the main trunk and then merge the shelved code into the new branch and build that branch Also, can anyone point me to a best practice reference for maintaining and building code in parallel development scenarios where you have the main branch and need to develop a new feature, build this feature for testing, and finally bring this feature into the main branch. Really ...Show All

• Visual C# enums, ints and strings

  Is there any way to convert an int value into a string representing an enum value enum ViewMode { View Mode0, ViewMode1, ViewMode2, ViewMode(n) }; int vm = 2; txtViewMode.Text = ... {turn vm into a string, "ViewMode2"} Can this be done Yes it can be done. But why use enums in your case Care to elaborate why you can't use a simple array of strings :) Anyway here's how to do it. Use the static methods of the Enum class to get both value and string representations of all the entries in an enum field: enum Color { Red, Green, Blue }; int val = 1; string str = Enum.GetName(typeof(Color ...Show All

• Visual Studio Team System Work Item Queries limitations

  Hi, I have looked at the workitem queries a bit more in depth to get more flexibility and have been disappointed at first sight. Isn't there a way to query for instance all related workitems to a given workitem ID There is a way to see the amount of linkeditems or relatedworkitems but that doesn't give the flexibility of: select * from Workitems where RelatedWorkitemID = WorkItemID. For instance I have a work item of type Defect and I want to see the 4 related tasks to it. there doesn't seem to be an out of the box way with the querying language to do such a thing. It is very clear how to do this from the back end with the Loc ...Show All

• SQL Server Different Execution Plans -> Same Query, Same Database, Different SQL Server Install

  Background:  Same database, restored from development to production. Indexes up to date.  Service Pack 3 on Production.  Originally RTM on Development, upgraded to Sp4, Execution Plan remained the same. The query itself is not my concern, but that there is such a wide difference in performance between 2 boxes.  Is there a setting on the Production that might be slowing it down   My system seems to have selected a worktable, is there a way I can turn that off to mimic the server I want to optimize the queries to perform best on the Production server, which is hard to do if my server's chosing different exe ...Show All

• Windows Forms Where Did My Bitmaps Go?

  My user-interface design has always been very basic.  "Spartan" some might say.  ("Skins We don't need no stinkin' skins!")  But with all of the visual improvements to the menu and toolbar controls in VS05, I think I've come around to the idea of adding some graphics to my UI.  My first step was to add some simple icons to the main MenuStrip items that I had extracted out of the My Movie Collection Starter Kit project.  Things looked pretty good.  Instead of a big empty grey box next to my menu items, I had a splash of color.  I then had a look around in the install folders, hoping to find some "common" bi ...Show All