BuzzBar's Q&A profile

• SQL Server Calculated members are unbelievably slow

  In general. Need help what are the top items I must check My client is Excel Pivot table I have one cal. member [NAV] from one fact table  I am getting POSN TOTL CURR NAV BAL PTFC and OWNSHP PRCNTG cal. mem [NAV] formula is below Iif (([Investment]. CurrentMember . Level . Name = "Investment Cd" or [Investment]. CurrentMember . Level . Name = "Investment Type Cd" ) and ([Investor]. CurrentMember . Level . Name = "Investor Type Cd" or [Investor]. CurrentMember . Level . Name = "Investor Cd" or [Investor]. CurrentMember . Level . Name = "Investor Desc" ) , [Measures].[POSN TOTL CURR NAV BAL PTFC] * [Measures].[OWNSHP PRCNTG] , Iif ([Investment]. CurrentMember . Level . Name = "Investment ...Show All

• Software Development for Windows Vista SqlTrackingQuery requries access to Types

  Hi, I would like to know the need for the SqlTrackingQurey API requring access to the workflow and activity types. This would be very inconvinient if all the types have to present on the Client systems which monitor the state of the workflow. I would expect the Tracking Storage to contain all the necessary information related to the workflow and activities and not rely on the types to be present in the Client application directory / Gac'ed etc. Rgds Giri I noticed this a long time ago and mentioned it in a previous thread (see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=213369&SiteID=1 ) I do agree it is inconvinient. Basically it works fine (and transparently) as long as the appl ...Show All

• Visual C++ How do you set the name of a thread in C++?

  This is something that I've been able to do in linux development, but I have not figureed it out in Visual C++. I've noticed that the thread list contains names, however they are always the same and I cannot seem to find the way to name them. This is not an MFC application. Currently, I'm using _beginthreadex to create the thread. See the following article: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vsdebug/html/vxtsksettingthreadname.asp ...Show All

• Windows Forms Get datagridview to respond to hotkeys

  How can I get my datagridview to scroll vertically according to hotkeys pressed If I press R2 then scroll down to row2, row3, etc. I'd like to be able to set the hotkeys and get the datagridview to respond. Thanks for any help. Right click your project, select "Add" -> "Class" to create a class, name it "myDataGridView", add following code into the class, build your project, then you'll find a myDataGridView control on your toolbox in the IDE, use it as the standard one. Code Snippet class myDataGridView { protected override bool ProcessCmdKey( ref Message msg, Keys keyData) { const int WM_KEYDOWN = 0x100; const ...Show All

• SQL Server Writeback Partition

  I have create a writeback partition. I want to test on it by update the cell data. However, I don't know how to update the cell data. I use Sql Server Mangemnet Studio to Excel Pivot table to browse my cube. Hi Mosha Pasumansky i try to excue UPDATE CUBE STATEMENT in SQLMS but it doesn't work actually the update cube statement is work but when i commit the transaction then server response error message as below "Errors in cell writeback: The cell writeback operation cannot be committed, because the 'Internet Sales' measure group does not have a write-enabled partition." My statement BEGIN TRAN update [Adventure Works DW] set ([Order Date].[CalendarYear - CalendarSeme ...Show All

• Windows Networking Development Setting up FTP on Server 2003

  .................................................. This forum is NOT for Windows trouble-shooting questions: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=152532&SiteID=1 acturaly you may get more answers from related forum ...Show All

• SQL Server rigid vs. flexible when doing full process

  Given the assumption that the cube is small enough that we'll always do a full process on the cube... Is it fair to say that there will not be a difference in MDX query performance depending upon whether all attribute relationships are rigid vs. flexible I know flexible vs. rigid impacts performance when incrementally processing dimensions. And I know it impacts aggs... as I understand it aggs involving flexible relationships are stored separately from aggs involving rigid relationships. I'm trying to validate whether aggs are stored less efficiently because of flexible relationships... and exactly what impact on query performance this will have. Hello. The performance guide pointed to at the top in this discussion group will h ...Show All

• Windows Live Developer Forums Suggestion: Viewing email directly in Messenger

  I am looking into a more easier and faster way to get to view my email from MSN Messenger. The waiting time from messenger to internet explorer to loading of my live mail and finally actually viewing it is taking too much time. this process usually take around 1 min of my time which can be fustrating at time. Maybe something that shorten the process or actually integrate MSN Messenger with live mail viewing capability. :) ...Show All

• Visual Studio 2008 (Pre-release) Cannot re-initialize ResourceDictionary instance. Error at object 'WinFXTestApp.Window1'

  When I started new AppDomain and inside it used Application.LoadComponent(uri). uri = {WinFXTestApp, Version=1.0.2382.39668, Culture=neutral, PublicKeyToken=null;Component/window1.xaml} I got XamlParseException: "Cannot re-initialize ResourceDictionary instance. Error at object 'WinFXTestApp.Window1'." bei System.Windows.Markup.XamlParseException.ThrowException(String message, Exception innerException, Int32 lineNumber, Int32 linePosition, Uri baseUri, XamlObjectIds currentXamlObjectIds, XamlObjectIds contextXamlObjectIds, Type objectType) bei System.Windows.Markup.XamlParseException.ThrowException(ParserContext parserContext, Int32 lineNumber, Int32 linePosition, String message, Exception innerException) bei System.Wind ...Show All

• Visual Studio Express Editions array of data

  How to create an array of data that i read fr the serial port so that i can manipulate the data later Thank you for the link. In fact, i want to plot a real time graph using paint event. Once i buffer the data received into an array (an array of data bytes i received fr serial port, to store the data byte by byte to the array), i want the array of data buffered to be made available to the timer event, which is the event responsible for my real time graph plotting. ...Show All

• .NET Development Using Delegates to call a function at runtime

  How can I write a command interpreter that calls functions when the function name is stored in a string Function CommandProcessor(sCommand as string, ParamArray sArgs() as string) as string dim objFunc as <Delegate> = GetFunction(sCommand) return objFunc(sArgs) End Function ..if thats possible I would also like to extend it to count the parameters and then call the function with the correct number of parameters... select case objFunc.NumberOfParameters case 1 return objFunc(sArgs(0)) case 2 return objFunc(sArgs(0), sArgs(1)) At the moment I have a whacking great case statement with over 2000 commands, and its causing a hit to process the case statement. thanks ...Show All

• SQL Server How to change standard saving folder?

  Hello, My english is not the best, but i will try my best. I want to change the saving folder for the database from my systempartition to my datapartition (from c:\blabla to d:\mydata), but i dont know how. I can see the folder but it is in gray font and unchangeable in the server configuration tool. Greetings Thomas To change the default database locations (for ALL future databases) right-click on Server Name (in Object Explorer) -> Properties -> Database Settings you'll see 2 lines under " Database default locations " Data: PATH_NAME Log: PATH_NAME hope this helps ...Show All

• SQL Server trigger- get row number from inserted/deleted

  I need to add the row number or record number to the 'inserted' and 'deleted' tables in a trigger. Among other things, I have tried- SELECT 1 as rowId, i.* INTO #ins FROM inserted i if @@ROWCOUNT > 1 --if multiple rows, set row number begin SELECT @pkWhere = coalesce(@pkWhere + ' and ', ' where ') + PKF.colName + ' <= i.' + PKF.colName FROM #primaryKeyFields PKF set @strSQL = 'update #ins set rowId = (Select Count(*) From #ins i' + @pkWhere + ')' exec (@strSql) end -the above sets rowId for every record to the total instead of sequential. Keep in mind that this code is used to create a trigger for any table, hence I cannot specify any column names literally. This SHOULD be simple... right ...Show All

• Visual Basic !! HELP !! Extracting frames in a video and comparing them THANKS ALOT!

  Hi, I need help in my project here. my project mate did this in C++, which no one else in the grp knows and so i need some help if anyone knows how to convert it to VB, if possible. The program is supposed to pick up a unattended object (like a bomb) and send an alarm (to like SMS or a PC). so it works like that. (what i understand he said, & seeing the C++ code). capture a background start capturing video average frames (eg. 10), so small movement is not picked up (think so) if pixels are the same for too long ( xx frames) - something isn't moving then send alarm he used C++ and open CV http://www.intel.com/technology/computing/opencv/ , http://www.cs.iit.edu/~agam/cs512/lect-notes/opencv-intro/index.html the things needed are a di ...Show All

• Windows Forms handling exceptions

  I am developing a desktop app in net 2.0 and i d like to know what's the best practice for handling exceptions!!! I ve heard abour Enterprise Library , but I hope to get others solutions. Regards Joseph This is a cut down version but you should get the picture.... Note how I handle this exception in the previous post, catch the bespoke and throw a new one of the SAME TYPE of the original so the root cause is thrown back to the calling code. Public Class BespokeException Inherits System.Exception #Region " Fields " Private m_type As ErrorType Private m_message As String Private m_exception As ErrorHandling.Exceptions.BespokeException #End Region #Region " ...Show All