Sarah97's Q&A profile

• SQL Server Most time consuming SQL Queries

  What are the types of queries that are most time consuming...which may easily lead to expired time out etc...thanks Regards Alu Thats a whole different world. If you want the quick win for the MDX side you can compare that with the aggregation on the OLTP side which is not pre-aggregated and therefore has to be done at runtime. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Audio and Video Development Unsetting an 'actioned' button

  Below is my js and markup. This is a basic button test with three states: normal, focused and selected/actioned. The test works, but I want a slightly different behavior. Right now when a button is pressed/selected, it stays actioned (in appearance) until I focus on another button. What I'd like is for the button to revert back to focused. I've tried setting it to that state in the js, immediately after I jump in the title, but what happens then is I never see the action state. I'd like the button to stay actioned for like a second. To give it that pushed look/animation. markup ##################### < xml version="1.0" > <root xml:lang="en" xmlns="http://www.dvdforum.org/2005/ihd" xmlns:style=&q ...Show All

• Visual C++ Failure to repaint

  I have to make an animation - looping a few thumbnails on a dialog. For this i first bitblt the thumbnails on a canvas and then bitblt this canvas onto the dialog. But I also need to have a combobox on the top above the canvas. But whenever I minimize the dialog of move it, the region above the canvas gets all blotted and doesnt repaint. I am doing all the animation in my OnPaint() and am also calling the Invalidate(). I cannot call UpdateWindow() as this slows down my whole app. I hope someone can help me with this. Is there is way by which i can throw the combobox on the canvas Any help would be appreciated. Rahul Make animation using timer. In OnTimer function write the following code: // set ...Show All

• SQL Server buckets or quartile

  Hi all, Dreaded moment has come:) I need to produce a report against MSAS 2005 with quartiles buckets, meaning that besides actual value of the measure, it needs to display following: Value 1st 2nd 3rd 4th X Min - Max Min - Max Min - Max Min - Max ------------------------------------------------------------------- 80 85 - 95 75 - 85 55 - 75 12 - 55 where 1st is range of values of top 25% performing entities and so forth. It's supposed to be sliceable by any hierarchy in the cube. I tried to use TopPercent 25%, but never could get it work in calculated member. Any idea, comment, reference highly appreciated. Thanks Extendong your example with emp ...Show All

• Visual C# Identify Serial ports

  Hi , I write an application in C# 2003. this program should list all the available serial ports on the computer and display it for the user. I tried with MSComm and AXMSComm to identify the Serial ports. But this components have only a function by the name of “commport” that return the index of one port to be used. Is there any way to identify all the serial ports and theirs name Thanks for your help /Babak If you are running v2 then the SerialPort class will give you the list of ports. For pre-v2 you can use WMI to get the ports. The Win32_SerialPort class defines a serial port. Query for all of them to get the entire list. For more information on using WMI refer to MSDN and search the forums. It is a popul ...Show All

• .NET Development selecting a child

  Hello, I want to find a single node by name. I'm using the SelectSingleNode method of the XmlDocument object the problem is that when the XML contains child elements of type comment this method does not work. Is there a way to find a node by name if there are comments node in the xml Thanks, I can see here many answers, but not to my question. I'll give my xml: <XML> <!--Comment--> <Child name="firstChild"/> <!--Comment--> <Child name="secondChild"/> </XML> when I use xpath expression to select the child named "firstChild" it doesn't find anything. when I remove the comments - it does work ...Show All

• Visual Studio Problem to install sp1

  During install of sp1 on Windows2000 I get the following error: Error 1305: Error reading from file c:\winnt\installer\a8075.msi. Verify that the file exists and that you can access it. The file exists and is accessible ao what can I do /Peter ...Show All

• Visual Studio MSBuild Tasks Community VSSGet?

  With the MSBuild Community tasks ( http://msbuildtasks.tigris.org/ ), does the VssGet task allow you to pull the code as of a certain date and/or label Thanks! ...Show All

• Windows Forms Detecting .NET 3.0 installation

  I have created a setup with a launch condition to detect .net 3.0 installation. For this I added a registry search to the setup project and set the below properties for the registry search: Regkey: SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.0\Setup Property: INSTALLSUCCESS Value: 1 Root: vsdrrHKLM The setup project has the default dependency of .NET 2.0 Launch condition. In a machine that doesn't have both 2.0 & 3.0, the setup checks only for 2.0 and continues with the 2.0 download. In a machine that has 2.0, it is not checking for 3.0 installed. I want to check both 2,0 & 3.0 installations. Please ehelp with this. Thanks. Do you use specific .NET 3.0 features The only difference between 2.0 and 3.0 is ...Show All

• Visual C++ xhash and swap error

  Building and running the following code in vc8 in release build makes my unit test application crash. Why anyone typedef stdext::hash_map<std::string, int> HashTable; HashTable x, y; x.insert( std::make_pair( "1", 1 ) ); x.insert( std::make_pair( "2", 2 ) ); x.insert( std::make_pair( "3", 3 ) ); x.insert( std::make_pair( "4", 4 ) ); x.insert( std::make_pair( "5", 5 ) ); x.swap( y ); x.insert( std::make_pair( "1", 1 ) ); x.insert( std::make_pair( "2", 2 ) ); x.insert( std::make_pair( "3", 3 ) ); x.insert( std::make_pair( "4", 4 ) ); x.insert( std::make_pair( "5", 5 ) ); ///< C ...Show All

• Windows Forms How to play a video fullscreen?

  Hi all, I'm using VB 2005 and want to play a video in fullscreen mode. I've read lots of articles about it and now i'm confused. I've read about DirectX and Windows Media Player 9 and 10 and 3rd party tools, and now I don't know which one to choose I did not find any comparison overview to see the (dis-)advantages of each solution. I still need to generate the videos so I don't care about the format supported as I could create avi, mpeg, divx or whatever is supported. Maybe someone could post a recommendation what to use Many thanks! Just use WMP, by referencing system32/wmp.dll. The player has a property for a FullScreen mode. If you need to render the video by yourself then you will need DirectShow ...Show All

• Visual C# Copy file to folder

  string cpath = listBox2.SelectedIndex.ToString(); string cpath2 = cpath + "temp"; if (cpath.Substring(cpath.Length-3,3).ToLower() == "xml") { File.Copy(cpath, cpath2); } I have a listbox of folders and when i click a folder the files appear in my listbox2...i want to select one the files click by button and that file is copied to my c:\\temp folder.....I am getting the exception that my start index must be less than zero....any help...thanks! Tryin2Bgood wrote: string cpath = listBox2.SelectedIndex.ToString(); that should really be if (listBox2.SelectedIndex==-1) { return; } String cpath = listBox2. SelectedValue ; You SHOULD use my code from above however als ...Show All

• SQL Server ---Problem of realization replication through WEB---

  Hello There is a following mistake at replication through WEB A security error occurred I try to go through IE which user has specified in the master of creation of the subscriber, in a diagnostic mode https://Servak/Replication/replisapi.dll diag And all works, all certificates fulfil correctly who did not collide{face} in what business WHERE TO DIG Sorry, I dont understand from your reply whether the name of the server on the certificate matches the one on InternetURL in the merge agent. I see in the job that you have: 'https://repl/ReplWeb/replisapi.dll' Is the certificate issued to machine "repl" Is there domain name also on the certificate If so, please try u ...Show All

• .NET Development System.BadImageFormatException after SP1

  Hello all, I have a considerable problem of late. I have a service whick our company counts on to report Dynamic IP addresses of our customers back to a central database, I have recently made some configuration updates to this service and it's corresponding GUI and recompiled it. I now receive the following error: System.BadImageFormatException This occures when I try to install the service. I have done a search on it and I found some documentation relating to this issue and static variables and partial classes, but I also found a note it was slated to be fixed in SP1 because it was a bug in the compiler, well that concerns me even more being that all was fine with my service till I installed SP1. Anyone have any thoughts I am kin ...Show All

• SQL Server Subscription Question

  Is there an easy way to change the owner on an email subscription We recently had an employee leave the company that had many subscriptions. The person who was going to do her job also wanted those subscriptions. I had to delete the old ones and set up the new ones for the user. Is there an easier way to just do that all in one place I think the best way is to send e-mails to a group instead of an individual. Then simply manage the e-mail group instead of the subscription. Best regards, Juran ...Show All