jim5400's Q&A profile

• SQL Server Parameterized MDX Query Performance Issue in SSRS

  Hi, I'm having issues with a reasonably complex MDX query used in a Reporting Services report. I have executed the query and traced activity on the SSAS box and have discovered that there is a major difference in performance between the parameterized query and the exact same one but with 'hard coded' values. The difference we are talking about is from a couple of seconds (hard coded) to minutes when parameterized!! The key difference is that the parameterized query is causing litterally hundreds of thousands of Query Dimension events (EventSubClass : 1 - Cache Data) to occur against one of the dimensions (the Date dimension to be exact). This dimension is not even large with only a few hundred leaf level members and about five levels ...Show All

• Software Development for Windows Vista what can i do to render video(from mobile built in camera CCD)to a memory

  Hi: I am a newbie,i want to capture the video into memory for example: a buffer (not a file),but i don't know what to do also,i  thick  it may works,if i write a filter named CSample(derived from CTransInPlaceFilter),and use  the CSample::Transform(IMediaSample *pSample) then implement pSample->getpointer(pbuffer); 1.does the pbuffer filled with sample from upstream . If the method is not correct please tell me. 2.Is there any document that can teach me step by step thank you! I was faced with this same requirement (also on WM5) and solved this by extending CTransformFilter to build a transform filter which then fired callbacks at my main app each time it re ...Show All

• SQL Server Do I HAVE to have IIS installed to use SQL Server Express 2005? and do I have to install SQLE2K5 on a server?

  Hi, I'm an absolute beginner trying to learn SQL and Visual Basic/Visual Web developer. I've downloaded SQL Express 2005 and want to install it on my laptop (Dell XPS, 2gb Ram) so that I can start doing the tutorials (for SQL and VB/VWS). I dont want any connection to the internet - i only want to have it on my local pc. I'm confused as I 'm sure I read that I dont need to have the IIS service running, and that it wont require a server...however, I keep reading that IIS, and a server is a MUST, and for installing SQLE2005. I'm so confused, and frustrated that I dare'nt install SQLE2005... ...Can anyone put me out of my misery All advice greatly appreciated. SQLEB Hi, If you hav ...Show All

• Visual Studio Team System Count how many files are in a directory in Source Control Explorer

  Is there no way to count how many files are in a directory in Source Control Explorer I always have to count them manually. I can't remember if I added all new files. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. fx problem ?

  Hi all, I has few fx effect problem. Hope somebody help. Q1. How to move texture uv with fx Q2. How to create smooth effect Please give to some suggestion about create smooth effect with fx. Best Regards, Q1. How to move texture uv with fx If you're using a vertex or pixel shader then the UV texture coordinate is just a numerical input - you can manipulate it (move/scale/distort..) as you see fit. The only potential complication is you can run into dependent reads. Q2. How to create smooth effect Please give to some suggestion about create smooth effect with fx. You'll need to provide a lot more information about what you want. A smooth effect could be various forms of shading (D3D will gi ...Show All

• Visual Studio Express Editions c++ structure to vb net

  I have the following c++ struct: typedef struct { WORD idReserved; // Reserved (must be 0) WORD idType; // Resource Type (1 for icons) WORD idCount; // How many images ICONDIRENTRY idEntries[1]; // An entry for each image (idCount of 'em) } ICONDIR, *LPICONDIR; typedef struct { BYTE bWidth; // Width, in pixels, of the image BYTE bHeight; // Height, in pixels, of the image BYTE bColorCount; // Number of colors in image (0 if >=8bpp) BYTE bReserved; // Reserved ( must be 0) WORD wPlanes; // Color Planes WORD wBitCount; // Bits per pixel DWORD dwBytesInRes; // How many bytes in this resource DWORD dwImageOffset; // Where in ...Show All

• Visual Basic Query about invoking an application when an Event going to Occur

  Hai all, I need to invoke an application (developed by us - it may be anything) when we click Shutdown option or when the system one for getting going to Shutdown.Is there any provision for this thing . Thanks I believe you are asking how you can run an application when windows is shutting down If that is the case I think you can use the SystemEvents which is located in the Microsoft.Win32 Namespace. You can find more information about these events at http://msdn2.microsoft.com/en-us/library/z1bwe429.aspx You should learn about SessionEnded and SessionEnding . Try adding an event handler to a windows service that runs at startup. When you system start t ...Show All

• SQL Server still error in service listing manager....

  Hi Remus: I am using latest ServiceListingManager v1.1.3 and still getting this error.... Msg 6522, Level 16, State 1, Procedure ssb_create_certificate_from_blob, Line 0 A .NET Framework error occurred during execution of user defined routine or aggregate 'ssb_create_certificate_from_blob': System.Data.SqlClient.SqlException: A certificate with name 'CMA_sbuser' already exists or this certificate already has been added to the database.System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.ProcessM ...Show All

• Visual Studio Team System Sample TFS Projects?

  Are there any sample TFS projects available that I could load into TFS and study I'm having trouble understanding what Microsft expects me to enter in the Work Items "Scenario" and "Quality of Service". I see the templates but I don't know what info would normally populate them. TIA, Barkdingdog Having the "Duwamish books" or "Cedar Bank" application for TFS would be a great thing to get corporate groups up and running and understanding how TFS works as well as how it is like/different from previous visual Studio releases. Is there any chance we'll see this soon ...Show All

• SQL Server Can't change the name of a OLE DB Source component name

  Hi, I've created an application that create package with a dataflow. The package with the dataflow and the ole db Source was created succesfully but for some reason the name of the Ole DB Source dosen't change programmitcally It's stays with the default name "OLE DB Source". This is very problematic because I want to add another Ole Db source and the package won't load because there will be two components with the same name. Thanks. This is the Code, It's from msdn exmples: Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Module Module1 Sub Main() Dim package As Microsoft.SqlServer.Dts ...Show All

• Windows Forms WinForms Exchange Server Integration

  I was curious if anybody could help me figure out how i could add exchange server functionality to my winforms application. I would like to add an email client, as well as calendar, tasks, and contacts to my winforms program. This way the user would not have to switch out of the application to view said features...but could have them easily displayed within the winforms application. Google searching has proven frutiless. Thanks in advance, Adam Yeah...i'm aware outlook handles all this...but it'd be nice to integrate all the features into one program, so as eliminating the need to switch to another program to check these features. thanks for your reply, Adam ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Loading Multiple objects from one FBX mesh causes translation/rotation problem

  I've been trying to create a whole scene in 3DSMAX and then import the scene in one FBX file with the content pipeline. Say my seen includes only two objects a cube and a pyramid placed on of the cube. Now when I load the objects with the content pipeline the triangles position has been moved to an initial position of (0,0,0) which is no-longer on top of the cube, but is now placed w/in the cube. Now I know I could perform a boolean join in 3DS Max on the 2 objects and then they would load into the content pipeline properly... but then I would lose the ability to operate on each object independently... I could also load each object seperately and then move and rotate the object as needed.... but this method really isn't feasible for scenes ...Show All

• Visual Studio Remote debugging with VC++.NET 2003 Standard edition

  Hi, I have Visual C++.NET Standard and I'm trying to install Remote Components to a computer in which I want to remote debug my Windows Forms project. I noticed that the installation help document refers to RemoteComponents.htm for more details on installing just those remote components and not the whole VC but I couldn't find that document from the installation CD root where it was supposed to be I also noticed that in the backside description of VC package there reads that only Professional edition supports remote debugging.. does this really mean that I'm not able to debug remotely using Standard edition Thanks in advance ...Show All

• Windows Forms Two Controls

  http://www.seo-consulting.de/pages/bilder/google-video-uploader.gif Do you see the table that lists all the videos What is the name of the control I can use to get that Also, how do I make a button that has a drop down menu You can show the menu using something like: //At the top left corner of the button(constant location), offseted 20 pixels right and down buttonMenu.Show(Button1, new System.Drawing.Point(20, 20)); //Or may be at the mouse click position: buttonMenu.Show(Button1, Button1.PointToClient(Cursor.Position)); The Show method of bot the ContextMenu and ContextMenuStrip will show a context menu (that you already created and designed of course), associate it with a control (your button) at the specified location (the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Architectu "push" vs. "pull" model

  Xna.Input.Keyboard has no events OnKeyUp and OnKeyDown, so I can't subscribe any object on this events using delegates. Is any reasons - why I know that I can do this by myself (examine the keyboard state every Update and call those events), but it's an ideological/archetectural question: I don't want to "pull" keyboard every time, I need my objects to be "pushed" on a keyboard event. In general, "push" model improves scalability and maintainance of a system since It's syncronous - each object reacts the event immediatly when event call occur. My guess on this would be this - 1: Not everyne wants/needs the push model you describe. Whilst it might not be the most inneficient thing in the wor ...Show All