Hognose's Q&A profile

• SQL Server How to design this cube?

  Hi, I have a question on designing the fact table. There are 2 tables in my database: OrderHeader,OrderDetail. And the OrderDetail table has different lines for different product. If the OrderDetail table is the fact table, how can I get the measure on how many orders we have I cannot simply use count(orderno) as the measure because the field,orderno, is duplicate in the OrderDetail table, and analysis services don't support "count di ...Show All

• Visual C# Using WebClient / Calculating transfer rate

  Morning Folks, I've been trying for the last 2 days to figure this one out with no luck.. so here goes.. As you can see in my code pasting below, i have a file thats downloaded in the button1_click event, i count the time between download start and finish, all this works fine.. now im wanting to show the download rate, and for the life of me, i cannot figure out how i can do this.. you'd think there would be some method or something bu ...Show All

• Smart Device Development Unable to run compact .net application on some PPC devices

  We are having trouble running .Net applications on an iPAQ rx1955. We have installed Compact .Net ( I thought all Windows Mobiltiy 5.0 devices came with Compact .Net). And when we run a simple Hello World application compiled for either 2003 or 5.0 they do not work. They do nothing. The thiking icon flashes for a few seconds and then nothing else takes place. We have had other people with this problem on other HP devices and never found a soluti ...Show All

• Visual C# When is a VS Express due that runs on the released .NET 2.0?

  Title says it all. We now have .NET 2.0, on which VSE beta 2 will not run, so we need an update asap. Regards,   Guido Guido  - Yes, you should absolutely be able to run your Beta 2 Express applications on the released version of express. HTH, Karen ...Show All

• SQL Server how to use sqliostress.exe on remote server?

  Hi, Can anybody help me with the command to use sqliostress.exe on a remote machine. I have, SQLIOStress /Fc:\temp\Stress.mdf /Lc:\temp\Stress.ldf /N /S3072 /I32 but how do I mention the remote server to test this utility. Regards, zia I am trying to calculate the IO operations and stress on the NIC card. Therefore I have to run it on remote server. thanks. ...Show All

• Visual C++ aspell compilation problems

  Hi, I tried to post on the forum but it kept coming up with an internal error so i was wondering if you could help me with the following:I have recently been trying to compile aspell (a spell checker written in c and c++) in visual studio .NET (2003) which has taken forever but i managed to get it to compile a dll now. When i come to add this dll file into another project which will be using the methods from this dll it keeps giving ...Show All

• Visual Studio Express Editions Properties.Settings gives error :"0, 0 is not a valid value for Int32"

  Happens everytime, don't know why... Take a form... In properties: ApplicationSettings...Location...new...opens up a standard window to pick a New Application Setting...Take the default value 0;0 or make that anything you want and then somehow that 0;0 turns into 0,0. Now when I edit it in the Settings.settings and type in 0;0 instead of 0,0 ...pop-up says cann't convert 300;00  to an instance of System.Drawing.Size... Am I missing somethi ...Show All

• SQL Server install SQL Server Express

  when installing SQL Server Express on XP home edition it hangs wilst searching for IIS compnents I tried to install the just released (11/7) SQL Server Express 2005 on Windows XP Home with SP2.  It again stopped with message "detecting installed IIS".  The requirement says WinXP Home with SP2 is support.  What's wrong with this thing   ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is DirectX good enough for creating modeling tools?

  this may seem a silly question. yet all the modeling tools i see on the commercial market and free tools use opengl. is this choice due to opengl having the ability to be used on no windows OS or is directx not upto the task well i wasn't aware of 3dsmax having a choice. :) i was curious because i wondered about creating my own tools and would prefer to stick with directx. yet was a bit worried by the choice for ...Show All

• SQL Server Process Throttle?

  Are there any new “process throttling” capabilities in SQL 2005   A customer of mine noted that that Oracle and others have a way to watch for and protect the system from processes that run out-of-control…taking up too many resource (CPU, Memory) from the rest of the system.  He didn’t see a way to do it in SQL 2000 and is hoping that 2005 has a solution. Thanks! Kevin Remde SQL Server 2005 added MAXDOP option to ...Show All

• .NET Development Exception Handling DO NOT WORK!! Help Please!@!

  Hi. I want that you think with me... When i put a try-catch exception handler block in an application what i expect from it i expect that it will handle the error and begin the normal flow of the application. Now, you aswer me, why it doesn’t work in this scenary : I have one Form1 (Project > Add New > Form, nothing different), and another Form2 and one Form3. i’m proud of my creativity for names. Form1 : private void Form1 ...Show All

• Visual Basic Highlight Items in ListView

  My name is Yuriy. Please advise. I have a ListView .(Report style, 20 columns,0 to 3000 rows). I need highlight some rows based on values in some column(In my case 6 column) This is my code: Dim iLine As Integer Dim y1 As Long Dim y2 As Long Dim iPicLines As Integer Dim LineHeight As Long Dim PicBox As PictureBox ListView.Parent.Controls.Add "VB.PictureBox", "PicBox" Set PicBox =ListView.Parent.Controls ...Show All

• .NET Development Dynamic Addition of User Controls but no WithEvents

  Image Approval System: I am utilizing user controls to populate a Panel with Images. Each of these user controls contains an image(blobbed from SQL), a button, a few labels, and a checkbox. On the main page's pageload I am populating the panel based on a query from the Request() string. I am dynamically creating the user controls using: Dim thumbnailcontroller As ThumbnailControl.Thumbnail = LoadControl("thumbnail.ascx") thumbnailcontroller. ...Show All

• Visual Studio 2008 (Pre-release) TabControl and ItemTemplate

  Hi, I want to create a tabControl and I want to specify an ItemTemplate for each TabItem. (with Feb CTP) But this xml code doesn't work. < TabPanel Width = " Auto " Height = " 350 " x:Name = " MyTabPanel1 " RenderTransformOrigin = " 0.5,0.5 " > < TabPanel.Resources > < DataTemplate x:Key = " ContentDataTemplate " > < StackPanel Orientation = ...Show All

• Visual C++ This application has failed to start because the application configuration is incorrect

  Hi, I am just starting programming using Visual C++ 2005 Express Edition. I have had some limited practice in other languages and older versions of C++, so I have some idea whats going on but not much... Anyway I made a short program which perfroms a bubble sort on an array of numbers which the user enters (I know its nothing to write home about but its a start), it works fine on my PC and when I sent it to a freind who also had VC++ 2005 Expre ...Show All