sgGeordie's Q&A profile

• SQL Server Incremental Update

  Good afternoon, I was wondering if someone could help. I'm busy researching into SSAS's capabilities, specifically Incremental Updates, however this would be the first time I'm working on SSAS, so I don't know where to begin. I've read through the BOL July 2006, and it explains that you have to enable this option; however to me it's not very clear. I followed the steps outlined in the Book; however when I go and update the source table, the partition does not update automatically. Could anyone please let me know if there is a website detailing how Incremental Updates work, and also how to set it up correctly Thanks Colin. Great, Thanks Thomas. I'll give it a bash and let you know if I manage ...Show All

• Windows Forms Solution Explorer Shows Form as Standard Class

  VS2003 I have a form that now display as standard .cs file in Solution Explorer. The form still compiles and runs correctly, but now I lost the design-time support for it. Any ideas The form generated using the IDE. It's just a regular about box. I think something got out of sync in my Debug Configuration. After switching mode to Release and bebuilt the solution, the form now showing up correctly. ...Show All

• Windows Forms ListView is not showing groups

  I am using VS 2005 and trying to show some strings in ListView in Three groups. I have tried creating groups both by code and desingner. No one works. Can any one point out some reason. The ListView is using 'Details' style. But I have tried with 'List' style as well. Have you tried Sean's code It is missing a crucial statement, what did you do to make it work ...Show All

• Visual Basic AudioPlayMode WaitToComplete fails

  My .Computer.Audio.Play( "c:\mymusicx.wav" , AudioPlayMode.WaitToComplete) The above works for .wav files where the music is fairly continuous, but when there are quiet gaps (about 6 secs or more) between songs within the same .wav file, the statement exits during the first quiet gap, rather than continuing to the end of the file. (Players like Itunes play the .wav file correctly to the end). I have Visual Studio 2005 v8.0.50720.42 Hoping someone can explain this. thanks for suggestion, but the problem happens with an explicit .wav file. I created a test .wav file by recording the C major scale from a keyboard. Each note was held for about 1/2 second, with a 5 second ga ...Show All

• SQL Server Using AMO to Update and then Process an AS 2005 database

  Using AMO, I connect to an AS 2005 database, which has the following connection string: ConnectionString = "Provider=SQLNCLI.1;Data Source=MyServerName;Integrated Security=SSPI;Initial Catalog=MyDBName" And then I do the following: amoDataBase.Process(ProcessType.ProcessFull) ‘ works properly amoDataBase.Update(UpdateOptions.ExpandFull) ‘ works properly amoDataBase.Process(ProcessType.ProcessFull) ‘ This one returns the following error: ex {"The following system error occurred: Incorrect function. . Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ' MyDatasourceID ', Name of ' MyDatasourceName '. Error ...Show All

• SQL Server Query performance on partitioned table with partitioned-index

  Hi all, I noticed that there are some big query performance difference when using partitioned-index on partitioned table vs. normal index on normal table. I posted this question again with more details and hope some gurus from Microsoft can help. I have this huge table CHECKS with over 300million rows running on SQL 2000. Since we are going to upgrade to SQL 2005, so I am thinking of partition it to make it more scalable. So I copied it over to a SQL 2005 box and partition it into about 20 pieces based on the column PDATE and named this new partitioned table as CHECKS_NEW. I created same indexes on this CHECKS_NEW table and used partitioned index for all non-unique indexes. Then I ran some queries on both tables and noticed the pe ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. A noob's first game: Shape Battles (a GeoWars clone)

  Well, I've "finished" work on my first game, which was really just a launching pad for me to experiment with XNA etc. Im quite new to game programming and have limited experience with C# (although I have exp with C and work with ASP.Net in my 9-5). I wanted to post my source code for anyone interested in checking it out, in the hopes that other noobs like myself could gain something from it. You can find it on my MSN Blog here: http://xnagamer.spaces.live.com/ Enjoy, and comments are defnitely appreciated! Thanks! Great job for your first XNA game! It totally had the feel of geometry wars, (except for the AI...that was kind of annoying). But all around, one of the more fun first games I've play ...Show All

• SQL Server how to public my cube to website?

  I have just studies SSAS, A simple question i think thanks You can also do a similar thing with older versions of Excel by creating a pivot table in Excel and then Save the sheet as HTML. Be sure to add Interactivity. This will use the Office Web Component OWC piviot table.in the HTML file. If you don't want to use Excel to publish to a web page you can use the OWC yourself in a web page. If the web page is on the Internet you will have to use HTTP connection to your Analysis Server. David ...Show All

• Visual Basic Client certificate from within a services

  Hi there, I have build a windows service wich will communicate to a web service. This web service requre a certificate for authorisation. When i run the services under "local system" it doesn't send the certificate to the web services. If i run the services under a user account it's perfectly, but this is not an option for us. How do make the services send the certificate to the web service when it is running under "local system" Thx for the reply. This example works when running in an (console) application, but when i turn the application in a services. It will add the certificate to the proxyobject but it doesn;t send it to the web-service. It looks like the windows se ...Show All

• Visual Studio Team System HELP: Accidently deleted an important project and I need it back!

  [Originally posted under Version Control but it was suggested I ask this over here because I might have a permission issue.] Hi all, Here is the deal. I was attempting to move a project in TeamSystem to another project. I had everything checked in and I had a copy on my hard drive. I deleted the project with TFSDeleteProject.exe and then went to create a new one but when I set up my new Workspace and started to add my source I found my source was no longer on my drive. Ok. So I started to freak because this was approx 3 months work for me. We have nightly backups but I had left the backup to my systems team and they only backed up the databases. So I created a new install of TeamSystem on another machine and restored the databa ...Show All

• Windows Forms DGV w/ CalendarControl

  I have a DGV with a calendar control. The calendar control works fine for those rows that have an entry in the field. When clicking on the DGV to enter a new (line) entry, the default value which was in the calendar cell from the code is replaced to a NULL value. This change causes an understandable "InvalidCastException" in trying to convert the (Null) value to a date. The default value is set at the table.column database default as (CONVERT([datetime],CONVERT([varchar],getdate(),(1)),(1))). I've also tried just getdate(). --- [I'm having a second issue with the combo filter which I'll inquire after sorting the first issue. ] All help is greatly appreciated, thanks. Code for the form is: [CODE] Impor ...Show All

• Visual C# I How to return and use a value from one method call to another

  Here is a rough scratch of my code which is much longer. Just focus on my question here, do not focus on correctness. Question/Problem: how can I pass the JAAlbum.ProductID to me second call to AddNewProduct for "Track" so that I can use its value in the call to  AddNewProductRelationship_Album_Track Right now, when I call AddNewProduct(xl, row, host, fileExtWAV, "Track", filePathSourceWAV, fileName, moveFile, sstore), the previous JAA.ProductID is lost but I need it ! foreach loop here {           if ((String.Compare(lastAlbumTitle, currentAlbumTitle,true) == 0) || (firstAlbum == 1))           {       ...Show All

• Software Development for Windows Vista How to use Oracle 9i with TransactionScope in .Net 2.0

  Hi, I want to use TransactionScope with Oracle 9i. What is difference to MS SQL Server Oracle does not promote the distributed transaction. I'm not sure of your question. Can you use TransactionScope in code that talks to Oracle 9i Yes. As for the differences between SQL Server and Oracle, look here: http://www.microsoft.com/sql/techinfo/whitepapers/sql-server-2005-oracle-pros.mspx I'm not sure what you mean by "Oracle does not promote the distributed transaction". Oracle's role is not to promote transactions - that's what DTC does. Oracle can participate in a distributed transaction. If you are referring to the PSPE capabilities of SQL Server, you are correct that Oracle has ye ...Show All

• Visual C# Add Node existing XML file

  - < RadioBar > < Genre_Genre_Country > Genre_Country </ Genre_Genre_Country > - < Genre_Genre_Country > < Title > KPIG presents Cowboy Cultural Society Radio - an American tradition since 2002 </ Title > < url > http://205.188.215.232:8028 </ url > </ Genre_Genre_Country > - < Genre_Genre_Country > < Title > Classic Heartland - Classic Country, Western, Bluegrass, Alternative Country [Dial-up] </ Title > < url > http://130.166.72.1:8008 </ url > </ Genre_Genre_Country > Genre_Genre_Favorites ...Show All

• .NET Development Missing data while reading from Excel

  I need to perform ETL -- read inventory adjustment data from an Excel spreadsheet and export it into a fixed-field ASCII file so our inventory application can import it. I have set up my C# project using ADO.NET OLE DB Jet provider. Everything seemed to be working correctly... at least while testing the application with "perfect data". If any column of data within the Excel file does not have a value within the first 9 rows (1st row is the heading), the entire column is ignored. It is not possible to modify the Excel spreadsheet prior to uploading it -- this is an automated process that must take it "as is". The first column is the part numbers, the other columns represent "why" the adjustment is being made ...Show All