David_G's Q&A profile

• SQL Server ROLAP and partitioning questions

  I have done all my dev work on a new AS database and now I need to start tuning processing/partitioning for deployment in production. The database needs to be able to drill down to leaf level and so I have implemented a fact dimension to do so. Testing with this dimension as MOLAP yields a 2.8 GB for 20 days of data partitioned by day. With the same partition scheme, if I change the dimension to ROLAP, the database goes down to 124 MB. With MOLAP, after the cube is processed, it opens nearly immediately in browse or in Proclarity by opening the cube. Good performance, but too big. With ROLAP, it has been "Loading..." for over an hour. Good size, but terrible performance. Is this normal behavior My guess is that since it is ...Show All

• Internet Explorer Development How to replicate the default download process in Internet Explorer?

  Hey there, I would like to know how I can call the default download function of IExplorer. I implemented a custom download manager using the IDownloadManager interface because I needed to get some specific information about the file being downloaded. However, I don't want to override the whole download process. I just needed to intercept it, get the necessary information and let it carry on with the default process. Currently IExplorer is calling my IDownloadManager::Download() function everytime use clicks Save in IExplorer. Can anyone show me how to call the default process, or to replicate it Which means, open the save as dialog, download it and show the current progress dialog if necessary. Thanks a lot!!! Hi It only takes o ...Show All

• .NET Development parameterized query performance/speed issue

  Hello all, I am running a query on a SQL 2000 table with roughly 50 million phone numbers stored in varchar format. I am converting from an old asp page to asp.net and have run into an interesting issue. The old asp page had a query similar to the following, with varPhone always representing a string variable. "SELECT * FROM dbo.AllNumbers WHERE Phone='" & varPhone & "'" This query ran in under 1 second. When converting to asp.net I decided to take advantage of parameterized queries and used the following: "SELECT * FROM AllNumbers WHERE Phone=@Phone " Using a parameter coded as follows: dbCMD.Parameters.AddWithValue("@Phone", varPhone) This query took 7 seconds to finish. ...Show All

• Visual Studio 2008 (Pre-release) is it possible to specify relative URI in xaml

  hi guys. is it possible to specify relative URI in xaml. It's possible. To be sure that you're clear about what the URI is relative to, you might want to investigate Pack URIs. See: http://msdn2.microsoft.com/en-gb/library/aa970069.aspx Presumably you are asking this question because you want to link from XAML to a XAML page. If so, you can't really avoid the question of how it is that you are deploying your application and/or pages. That influences what's advisable or possible as far as relative paths between XAML pages. See http://msdn2.microsoft.com/en-gb/library/aa969776.aspx ...Show All

• SQL Server How to Delete Files on Maintenance Plan

  Hello, I am creating a Maintenance Plan in SQL Server 2005. The 'Back Up Database Task' has the choice 'Create a sub-directory for each database' as SQL Server 2000 does. But when I add a 'Maintenance Cleanup Task' I do not see a choice to delete files on subdirectories. Looks like it only deletes the files from the directory I specify. So, looks like SQL Server 2005 is removing some functionality already available in SQL Server 2000. Is there a way to delete those files without needing to specify each directory I do not see any documentarion about xp_delete_file either. Thanks, Ben Nevarez I will echo the sentiments above that this is a major headache. Before reading this thread I had alread ...Show All

• Visual Studio 2008 (Pre-release) How to server a document from Sharepoint?

  I have a piece of code that will be a list of documents from a document library, but what I need to know is once I have my object ready to go, how do I use WCF to return that document to a requesting ASP.NET site The sample sharepoint code is as follows: SPSite site = new SPSite("http://server:12345/sites/Name/"); using (SPWeb web = site.OpenWeb()) { string docLibName = "Shared Documents"; string viewName = "All Documents"; foreach (SPFolder f in web.Folders) { foreach (SPFile file in f.Files) { file //!Here is the file that I need to return!!! } } } This code will run as a WCF method requested by an ASP.NET application, how do I then use t ...Show All

• Windows Forms Migrating application from Access/SQL to C#/SQL - Combo box issue

  I've been tasked with converting all of the Access apps that have been used as frontends to SQL to web-based applications written in C# that will also act as frontends to a SQL server. While I've been successful in moving most of them, I've run into an issue with C# combo boxes. Briefly...in Access the client has a form used as a frontend to SQL to add registration information to. It has many combo boxes where they are tied to other single column tables (lists basically) to ensure the integrity of choice in the dropdowns. These combo boxes have some options set so that only what shows in the dropdown list can be picked and nothing else can be added. A user can also choose not to select anything of course and it would simply reflect a nu ...Show All

• Visual Studio Express Editions Problem with Mouse_down and Mouse_leave on items

  Hi I have put this code on my label and this is not working. Private Sub label1_MouseDown( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles label1.MouseDown label1.Font = New Font(label1.Font, label1.Font.Style Xor FontStyle.Bold) End Sub Private Sub label1_MouseLeave( ByVal sender As Object , ByVal e As System.EventArgs) Handles label1.MouseLeave Label1.Font = New Font(label1.Font, Label1.Font.Style Xor FontStyle.Regular) End Sub When I move the mouse cursor on " label1 " , the font style must be cahnged to " Bold ", and when the mouse leave, the font style must be changed to " Rregular ". Thanks Shady ...Show All

• Visual Studio Team System Logon to TFS

  Our Team Foundation Server is set up to join an Active Directory domain so that users need only log on to the domain once. Recently, one of our developers changed her domain password as required. But since then, she is prompted to log on to TFS everytime she starts up Visual Studio 2005. Is this expected Is there a way around it I did and i got a fast answer to this. Thank you My new thread is : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1174536&SiteID=1 ...Show All

• Smart Device Development Doubleclicking the touchscreen?

  I have been unable to get Double-clicks to work with a touchscreen. I am calling ModifyStyle with CS_DBLCLKS, that doesn't seem to be working. Does Windows Mobile 5 actually support double-clicks Amit Ranjan wrote: You would need to register windows class with CS_DBLCLKS style. Hope it helps Thanks and Regards Amit I am doing that via ModifyStyle() (ref: original post) ...Show All

• .NET Development DW20.exe issues

  I have a web site and everytime I make a reference to my business/datalayers it times out and I can see DW20.exe running in task manager, If i remove all references to my business/datalayers my web site runs fine. My web app was working fine up until this morning. Everything is coded in 05. Has anyone else experienced this issue and if so what did you do to fix it I was having the same problem everytime I started SharePoint. I ran the .Net installer again and told it to repair the installation and everything was fine after that. ...Show All

• Visual Studio 2008 (Pre-release) Strange problems with many WPF elements.

  Hi, We are experiencing very weird problems when we have alot of WPF elements, in a Canvas or another panel, for example. With many WPF elements we are talking about 100. Sometimes the elements don't seem to get renderd at all, and our adorners are displaced when scrolling or zooming in and out. It works fine when we have a smaller number of elements. Any ideas Thanks! / Joel I had somewhat similar problems. I was able to fix the ones in XPS by following code as shown below: .......... Size sz = new Size (8.5 * 96, 11 * 96); fixedPage.Measure(sz); fixedPage.Arrange( new Rect ( new Point (), sz)); fixedPage.UpdateLayout(); .................. Another one was the WPF ...Show All

• .NET Development Search an Access database while typing information in a textbox

  Hello! Here's the situation: I've created an Access database containing several product's names. I have binded the database with my application. Here's what I want to do: I want to type the first letter of a product's name and on a particular list to be shown all products starting with that letter, after typing the 2nd letter the list shall contain product's name starting with those two letters, etc. I hope you can give me a little clue! Any help appreciated! You dont really want to continually search the database as this is a severe performace hit, you would be better searching an offline copy of the data, the feasibility of this depends on just how much data there is. I presume in your access datab ...Show All

• Visual Studio Express Editions Listbox Question

  PROBLEM SOLVED - Thanks for looking - Got a friend to tell me Hi there, This is the probably the first time I have used a listbox, so I need your help. I've already got it to populate off a textfile using streamreader. Now I want it so when you one/double click a certain line in it, it will get the text from the line which is selected without knowing the tab number. Thanks, AliQ - AKA Listbox noobie not sure what you mean. To get the item the user clicked on in a listbox, implement the selectedindexchanged event (double click listbox) then you can show the item they chose. Example.... private sub listbox1_SelectedIndexChanged(byval sender as object, byval e as eventargs) handles listbox1.SelectedIndexChanged ...Show All

• SQL Server Deploying packages with SQL Server based configuration

  Hello, We have been conducting some testing regarding package deployment and SQL Server based configuration. It seems there is a problem that was documented in an MS Feedback entry ( https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=126797 ) I searched for a viable answer, work-around, or hotfix that would address this issue but found none. The jist is that a package that uses SQL Server based configuration must have an xml-based configuration entry to "re-point" the SQL Server based configuration connection manager to the deployment target server. We cannot use environment variable or registry as this is against internal policy. The problem is that even though the xml based config i ...Show All