michaelmwelch's Q&A profile

• SQL Server MDX Query never finishes

  I am populating flatfiles from MDX queries run i SSIS against AS databases. I have ran in to problems with MDX queries returning large resultsets that never finishes. The query performed is purchase calculations over different time periods for each member in the customer dimension. There are 6-8 calculated members created and the customer dimension contains about 3,5 million members. When query is run, after 1-2 hours the server stop allocating memory and starts to get data from cache in intervals. In the end of each interval, memory is dropped. In perfmon it seems to be no activity during long periods I have given it as long as over 3 days without any result. Server is 8 x 64bit cpu with 16 gig memory. Some help in this ...Show All

• SQL Server How to execute a Package?

  Hallo I created my first Package and i am not able to deploy it in my SQL server. I created a Development Utility and in the OutputPath i got a *.dtsx and a *.SSISDevelopmentManifest file. When i run the packaage (*.dtsx) it works but when i try to install the package with *.SSISDevelopmentManifest it just genereates a folder in the selected Folder (...\Microsoft SQL Server\90\DTS\Packages\) and no more. What am i missing Hi soanfu, When using the Deployment Utility, a directory is created in the Microsoft SQL Server\90\DTS\Packages\ folder. This happens regardless of where your package gets deployed. If the package gets deployed to the file system, the dtsx file will be copied into this dire ...Show All

• Visual Studio Team System Mapping information could not be obtained from User Name Mapping?????????

  Hi, my connection to TFS works randomly. For a while I can connect fine, but for a while I can't. If I check the events I can see the following: Mapping information could not be obtained from User Name Mapping. Any ideas why this is happening Hi xavito, Are you the only user that is experiencing these issues, or are other users of your server experiencing similar problems -Matt ...Show All

• Visual FoxPro Bug in VFP9 : Sys(2020) doesn't return the total size of the default disk

  According to Help, Sys(2020) return the total size of the default disk. This is true in VFP5 and VFP6 (the ones I have), but not in VFP9 In VFP9, Sys(2020) return the total free size of the default disk. This is a known issue. It has changed in VFP 7, 8, 9 to read available disk space. Use Diskspace("c:",1) to get total disk. ...Show All

• Visual Studio How to read/set Windows Forms Designer properties from Add-In

  I faced with the following problem. I would like to make possibility to change GridSize, ShowGrid and SnapToGrid values, which available for user from Tools-> Options -> Windows Forms Designer -> General, from my add-in. The main problem that I cannot get the property. I tried to it this way: EnvDTE.Properties properties = dte.get_Properties("Windows Forms Designer", "General"); but get "Invalid Index" COMExeption. As I understand, there is no "Windows Forms Designer" category, but how to get such property Please advice. See my article HOWTO: Getting properties from the DTE.Properties collection of Visual Studio .NET. at: http://www.mztools.co ...Show All

• SQL Server database log file size

  I want to ask what are the impacts if I limit the file size to certain MBs and will it report (File is full) or overwrite old data when the file reachs the assigned size Jassim, Perhaps you are referring to an auto grow capability of data and log files. By default database files are created with auto grow option. Each time a file reaches it's full capacity it gets resized, by the specified amount (either fixed size or percentage). This operation has some negative impact on the database performance, so in general it should be avoided. The autogrow functionality is primarly useful in systems that are not closely monitored by an adminstrator, for example embedded applications. So if you set the initial log size to be bigger, y ...Show All

• Visual C++ error C2065: 'PCACTCTXW' : undeclared identifier

  I did convert an application from vs6 to vs8 and then i got this error (seems a little like the DWORD_PTR thing...) Where could be the problem ------ Build started: Project: HydrotelKernel, Configuration: Debug Win32 ------ Compiling... [ ... ] // i'm skipping this part of the building... way too long AdoDatabase.cpp  WINVER not defined. Defaulting to 0x0502 (Windows Server 2003) AdoRecordset.cpp d:\program files\microsoft visual studio 8\vc\atlmfc\include\afxcomctl32.h(32) : error C2065: 'PCACTCTXW' : undeclared identifier d:\program files\microsoft visual studio 8\vc\atlmfc\include\afxcomctl32.h(32) : error C2146: syntax error : missing ')' before identifier 'pActCtx' d:\program files\microsoft visual studio 8\vc\atlmfc\include\ ...Show All

• Visual Studio Team System How to View line numbers in SQL Editor

  Hi, In errors and warnings lists there is a line number given where the error or warning occured. When I click on the error or warning it takes me to the correct sql script but I cannot find anyway to jump to the line number or at least turn on line number in the editor. Is this possible to view line number in sql editor if so how Thanks Don SteelMillDon, Tools | Options | Text Editor | T-SQL90 | General Under 'Display' check Line Numbers THT, ...Show All

• Windows Forms Memory Usage Guidelines

  I developed an app in VS2005 and am wondering if there are any guidelines available for how much memory is safe to consume per hardware specifications. For instance, how to determine minimum hardware requirements for an application Thanks, cj ...Show All

• Software Development for Windows Vista TokenHelper depends on NetFx 3.0

  I'm ready to deploy support for information cards here at Pluralsight. Only problem is, I don't relish the idea of putting a CTP up on our public web server. Is there a version of the TokenHelper (or something like it) that will allow me to decrypt and parse tokens using NetFx 2.0 Before I go off and build this myself, does anyone know if this already exists That's a good start, it decrypts the token. I do want to stress to everyone here that it is critically important that you verify the signatures on incoming tokens, as without that, you've got no possible way to know that the right person sent you the token. g Garrett Serack | Program Manager |Federated Identity Team | Microsoft Corporation blog: h ...Show All

• Visual Studio Express Editions Threading Walkthough - Bug?

  I'm trying to learn more about threading. I tried the MSDN walkthrough " Walkthrough: Authoring a Simple Multithreaded Component with Visual Basic " - there seemed to be a lot of error messages generated, just following it step by step, and no way to determine how to fix them, or if it is pilot error, etc. Just wanted to comment. Tarey, If you are concerned about trying to fix the errors...post the code that is causing the error and the error message you are getting and I'm sure someone here will be able to help you! ...Show All

• Visual C# Keyboard shortcuts for Find - Toggle between Code behind and Markup view

  I looking for a key combination or a shortcut key (like F7) for swiching between Code behind view and Markup view, bypassing the Design view, because I rarely use it. Its realy annoying after pressing F7 from Code behind view, to wait all the visual controls to be built just to be able to switch to Markup. Thanks in advance for any suggestions. Bojidar There isn't one by default, but it's possible to write a macro and then bind a keyboard shortcut to it. This macro posted on codeproject comes close: . I modified it slightly to do exactly what you're looking for (though it makes the macro work only for C#): Code sample Change the line: OpenCodeBehindFile(activeDoc ) to: OpenCodeB ...Show All

• .NET Development IEnumerator<T> problem

  Im building a class implementing System.Collections.Generic.IEnumerator<T> but have some problems with it. Seems like the interface requires the Current property 2x System.Collections.Generic.IEnumerator<T> .Current System.Collections.IEnumerator.Current When i do this, it says the method current allready exists :( when i dont add both properties it says the interface implementation aint correct Thanks :) Could not implement the interface automaticly cause my smart tags were not working anymore after installing linq ctp ... but i just fixed it ...Show All

• Visual C++ calls to unmanaged dll to create a socket result in debug assertion

  I have an unmanaged C++ dll which is an MFC shared DLL that has functions in it to initialize sockets and do other ethernet related things. I have built a managed C++ wrapper project which is also an MFC shared DLL, compiled with /clr that calls functions in the unmanaged dll. Then I have a C# project which instantiates a member of the wrapper class to access the unmanaged functions. One of the functions in the unmanaged dll creates a new CAsyncSocket, checks to see if AfxSocketInit is successful, and if so, calls Create to create a new socket. When I call this function through my wrapper from C#, I get a debug assertion when Create is called. The call stack trace indicates that the problem is in a call to AfxGetInstanceHandle. I've done ...Show All

• Visual Studio 2008 (Pre-release) vote for extension properties

  I was playing with extension methods the other day, and I find it really exciting. The natural language expressiveness is great, epecially when creating a Domain Specific Language for an app or framework. Some uses were natural for methods, such as a Behavior-Driven Development style of testing method like: public static bool ShouldBeEmpty( this ICollection coll ) { return coll.Count == 0; } // var x = new ArrayList(); x.ShouldBeEmpty(); returns true Other uses were not so natural, where the parentheses get in the way. public static TimeSpan Months( this int number ) { var now = DateTime.Now; return now.AddMonths( number ) - now; } public static DateTime FromNow( this TimeSpan span ) { return DateTime.Now + span; } ...Show All