stensby's Q&A profile

• SQL Server Imrovenment MAX

  In my cube I have following calculation Max (([Dim Date].[Daily Date]. CurrentMember . lead (29) : [Dim Date].[Daily Date]. CurrentMember ) * [Hour24]. Children , [Sales]) but this calculation is very slow can I improve this calculation I have read this cool articale ( MDX Performance Hints ), but I don't understand how I can apply for my calculation. Thank you These recursive, moving window calculations are not easy to optimise. If you have any useful higher level in a hierarchy (maybe weeks ) you might be able to tune this calculation similar to tuning a YTD calculation. If you have time in your processing window another option would be to calculate a "Max 30 day ...Show All

• SQL Server tsql for database , size , free space or used space in database

  hi, i want to know how to find out database size Use stored procedure: sp_spaceused Results: database_name database_size unallocated space ------------------------- --------------------- -------------- AdventureWorks 1143.00 MB 128.34 MB reserved data index_size unused ------------------ ------------------ ------------------ ------------------ 184992 KB 88264 KB 89456 KB 7272 KB ...Show All

• Windows Forms Bug? An item with the same key has already been added

  After added a button onto a ToolStrip. The button image is default to System.Drawings.Bitmap, if click on the "..." button and try to change it, a dialog box pops up with the message "An item with the same key has already been added". So far, I have to change the image programmatically. -Jillaint As per this post it seems to be a bug in Visual Studio 2005: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=91862 In addition to removing the extra Resources.resx file as suggested I found that the Resources.resx that remains must be in the Properties folder. Good Luck! ...Show All

• Visual Basic Correctly exit application

  Which is the right way of exiting an application by clicking on an exit button I used the following code but someone is complaining that my application hangs out when he clicks the exit button. Private Sub btnExit_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles btnExit.Click End End Sub > I thought END was the main way or is that only okay for a single FORM project Anyone using "End" should be bound, beaten, tared and feathered, IMHO. ...Show All

• SQL Server Newbie Question

  Hi I'm working with SQL Express, and this is my first experience with DB, so I'm still learning. I made a rather stupid mistake, and I'm not quite sure how to get out of it. In the process of trying to fix a problem, I changed the default DB in my account to one that it can no longer connect to - for a reason unknown to me. (once I get this cleared up, I'll ask about that.) Now I can't login properly to SQL Express, b/c it can't connect properly. please help thanx Jeffery hi, yiu should be able to connect via a system administrator login, bot WinNT trusted authenticated (login in in Windows as a local administrator) or standard SQL Server authenticated (if you enabled mixed security) provid ...Show All

• SQL Server install the database to any sql server from cd

  hi friends can any body help me install the my database directly to the sql server without going to the sql server and running the script ...Show All

• SQL Server Executing Package Question

  Hi, Simplification of setup: - SQL Server Box with Enterprise Edition of SQL Server 2005 - Workstation with the client tools (Managment Studio, Business Intelligence Studio, etc) SQL Server 2005 installed running Windows XP 1. Am I right in saying that I need to install the SSIS service in order to run this package on my workstation from the command line, the Execute Package Utility tool, or through Management Studio 2. I can however execute the package on my workstation in the Business Intelligence Studio without the SSIS service installed, correct 3. Assuming I need to install the SSIS service on my workstation, if I execute the package via the command line or the Execute Package Utility utility, will it run on my local machine or on the ...Show All

• Windows Live Developer Forums Has anyone implemented a rectangle zoom?

  This question probably isn't clear -- some maps allow users to drag a rectangle on the surface of the map and then onmouseup the map zooms to the area within the rectangle. Has anyone implemented this If so are you wiling to share a code sample Thanks. ..and for those of you without a middle mouse button (or hate using it as much as I do): ALT-left click does the same thing. :) ...Show All

• Windows Forms Update fields upon saving

  What would be the best way to update an editor and edit date column upon saving so that only rows that were changed would have those columns updated after the save. You may try the use the Controls collection to get a certain cell and set it value. Or if you bind the datagridview to a datasource, you can also change the value in datasource. Help this is helpful ...Show All

• Visual Studio Team System Importing schema causes full crash in CTP5 (but worked fine with CTP4)

  I had just upgraded from CTP4 to CTP5 and am now having crashing problem (full crash, have to restart VS) trying to import a schema. It was not never a problem importing this same schema in CTP4. Any ideas Thanks Yep. The same problem. Full crash on Import or Database Schema Compare. Without any error output - just closes VS. Worked on CTP4. Pretty small amount of objects. SQL 2005 Server & project. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Really, REALLY strange "bug" with Vector3

  For my ray tracer, I created my own Vector struct that pretty much wraps a Vector3. The thing is, I used to have just three floats; X, Y, and Z. Now I just unioned them with the Vector3. For some reason, rendering time cut down by about 15% (i.e. from 10 seconds to 8.5). I removed the Vector3 and it went back to being 10 seconds. ...Wtf Is there a hidden type constructor with Vector3 that makes it much more efficient I'm not even using any of the Vector3 methods for my transforms and such. Could anyone tell me what the hell did I stumble into Hello again Reading the above verbatim, you seem to have wrapped a struct in a class If this is so, the class will be allocated in the heap, whereas ...Show All

• Smart Device Development VS 2005 PocketPC Cab File Creation

  I am using the Visual Studio 2005 Beta. I am trying to figure out how to create a cab file for deployment. The old option to "Build a cab file" from VS 2003 doesn't seem to exist in VS 2005. If anyone can assist me, I would appreciate it very much. Thank you. Does the service pack for VS2005 fix the 262 file limit in Smart Device CAB files that exists now ...Show All

• Visual Studio Express Editions Deserialization error End of Stream Encountered before...

  Hello, I am hoping I will end my struggle here. I have confidence in you ;) I am serializing a hashtabls in my sql database in a field of type "image" with length 16. The serialization goes fine. later on in the code, I try to retrieve the value in the image field in a byte array as such: //***** code snippet begins object param = row["Parameters"]; // this is the field that has the serialized value. byte[] myBParam = (byte[])param; // cast it to an object. //***** code snippet ends and then I try to deserialize to make sure that I can retrieve my original hashtables, so I do this: //***** code snippet begins Hashtable myOrigHt = (Hashtable)Deserialize(myBParam); // Which goes to this me ...Show All

• Visual C++ Linker Error with STL on Release Mode

  Hi, I'm using Visual Studio 2003. Each time I use some STL library like string, fstream... I get many linking errors but only when compiling in Release mode. I get LNK2001 and LNK2019... I've been looking in the forum for some answers but I don't get it right. PLEASE, HELP Code will generate this error message if it references something (like a function, variable, or label) that the linker can’t find in all t1he libraries and object files it searches. In general, there are two reasons this error occurs: what the code asks for doesn’t exist (the symbol is spelled incorrectly or uses the wrong case, for example), or the code asks for the wrong thing (you are using mixed versions of t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Research: If I was to create a character for a game, how would we get developers to actively develop it?

  Hi. I work for a marketing company and we are wanting to launch a new product in 2007. We have a character which we want to create a game around, but believed we could do this by giving developers the tools from which to create their own game. I had lined this up for Xbox as I had believed that it was an easy platform from which to create a game, but am now slightly confused. If we did want developers to do this, with the possibility that we would then sell the winning game....how would we go about doing this Thanks a million M I agree with George, a contest for hobbyiest developers using Microsoft XNA Game Studio would probably be the best option for what you're asking. However this does depend on your time-scale. Microsoft hav ...Show All