AndyJ_PS's Q&A profile

• SQL Server sp_executesql From App's Dynamic SQL Causing Performance Problems vs. Query From SSMS

  Okay, so I came across an odd performance issue that I'm wondering if some guru can help me out with. I have a query that uses a paging algorithm that uses a paging algorithm and a table variable, then gets a page of data based on a join to that table variable. Here's a simplified query using the algoritm: --declare table variable... not shown for brevity --make sure we only store the least amount of records possible SET ROWCOUNT ( @pageNumber + 1 ) * @pageSize --insert into table variable INSERT INTO @TableVariable( Key ) SELECT key FROM table WHERE whatever = @p1 --we only want one page of data SET ROWCOUNT @pageSize --now get the page of data from the table SELECT key FROM table WHERE whatever = @p1 AND [Table ...Show All

• .NET Development load any number of dlls for plugin rather than hardcoding the assembly/type.

  The following code successully loads into a panel what was previously an .ocx - now a dll. assembly1 = Assembly.LoadFrom ("TrackPanel.dll") Dim t As Type = assembly1 .GetType ("TrackPanel.Panel") Dim c As Control = CType( Activator.CreateInstance(t), Control) Me.PanelContainer.Controls. Add (c) What I want to do is load any number of dll's from a specific directory rather than having to hardcode each one given the following ildasm layout. (at least for this particular dll) namespace TrackPanel class TrackPanel.Panel method MyName() ' returns a string I am thinking that with so many supporting dlls (axhost/interop/etc) required for side by side mechanisms, I really need to use a config file ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How will it be the content creation for XNA??

  Hi people, I want to know if XNA will provide it's own tools for content creation, or what formats will it support (COLLADA, .X). And what about a GUI System, will it have one Jim Perry wrote: Just a guess, but XNA isn't a content creation system so I doubt it would include tools for it. You'd have to use Max or other packages and bring the content into your project. I guess in too...... ...Show All

• Visual Studio Express Editions User Searches 2 fields to find a database record in application.

  Hi, I am learning Visual studio 2005 Express Suites (very new learner). I am attempting, in a form to have a user type in a first name and last name into a text box each, then click a button to find a person in the database. The associated database fields are: StudentID, StudentFirstName, StudentLastName (StudentID is a foreign key in a a couple of other tables). The text box field names are: TxtBFirstName and TxtBLastName. The button name is: BSearch There seems to be a way to do this type of search through the bindingsource [studentsbindingsource] where I click the little arrow, choose "Add Query", click "Query Builder", then edit the SQL query. I am confused as to how to phrase the WHERE clause - basically it would ...Show All

• Smart Device Development Inserted/updated/deleted records from application were not preserved permanently in Mobile database, .sdf file?

  Scenario: Iinserted or updated records from query analyzer to local Mobile database (sample.sdf) were preserved in permanently. If I insert, update or delete records from application using basic insert/update statements, inserted/updated records are loading to grid still I close the application. Every time execute non-query get succeeded and non query returning number of records inserted or else. Problem: Once I restart application, I couldn't see the inserted/updated records on application display grid. Then I came to know that inserted, updated, and deleted records from my application were not preserved in mobile database ( .sdf database attached to solution explorer and add to solution by selecting add -> SQL Mobile database ...Show All

• .NET Development accessing a properties PropertyInfo

  I want to access a property's PropertyInfo without knowing it's name, I can do this if an accessor invokes another method via putting the following code in the invoked method. string caller = new StackTrace.GetFrame(1).GetMethod().Name; string pName = caller.Name.SubString(caller.Name.IndexOf('_')); PropertyInfo info = <this>.GetType().GetProperty(pName); As a result the same method can be readily invoked by accessors of different properties and the method can do its work based on the property name, type, custom attributes etc But I also want to do something similar in an associated method that is not invoked by an accessor - but by a method in another class, which has an instance of the properties declaring class. If I were ta ...Show All

• SQL Server Problems with neural net viewer, lift chart and predictions still ocurring in SP2

  Greetings, I have a mining structure that I am using to perform a text-mining classification task. The mining structure contains three models: a decision tree, a naive bayes and a neural network. Both the decision tree and the naive bayes models process without any problems, but I am having significant difficulties with the neural network model. Initially when I processed the model, processing would fail altogether with the following error message: "Memory error: Allocation failure : Not enough storage is available to process this command" This was remedied by taking the steps prescribed in http://support.microsoft.com/kb/917885 (I upgraded to SQL 2005 SP1 and applied all available hotfixes listed in http://s ...Show All

• Smart Device Development I Have a problems to use a certificate into me code in Windows Mobile 2003

  In me application to windows mobile 2003, i was needed use a certificate conection to webservice. In me Project add a new Item Class and copying the example code from "X509Certificate.CreateFromCertFile Method", but in the code section " X509Certificate.CreateFromCertFile(Certificate)" VS2005 displaying this message "CreateFromCertFile is not a member of System.Security.Criptography.X509certificate.x509certificate". What is the problem the Compact framework not support this method how can use a certificate in me application Please help me. That is the part of the sourcecode UrlAllz = "https://www.lkxsoftware.com" If Ramo = "2019" Then AplicaAllz = ":55 ...Show All

• Visual Studio Express Editions Automatic end brackets

  I am using Visual C# Express. Is it possible to have it automatically put an end bracket in when I enter a beginning bracket for instance, when I enter: for(int t = 0; t < something; t++) { Then when I press enter, it automatically puts the end bracket in, and puts my cursor between them. I have looked through all of the options, and haven't found a feature like this. It would be very helpful. SharpDevelop does this automatically, and other than that one thing, I like Visual C# Express much better. If anyone has any ideas, I would appreciate it. Have a look at this post. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=753176&SiteID=1 Scott ...Show All

• SQL Server Does "Current time member" on the KPIs designer do anything?

  The "Current time member" on the KPIs designer is poorly documented and that's an understatement. Does it actually do anything or is it unfinished code Has anyone else come to the conclusion that KPIs in SSAS were never "finished" We've found numerous holes in the way KPIs have been implemented. Hi Terry, The Associated Measure Group property is intended as the mechansim for specifying valid dimensions. I would be interested to hear if you've tried this and still found it to be inadequate. Please explain this comment " KPIs can't be formatted as percents without the status and goal calulations blowing up" as I'm not aware of any issues here. We actually do have support for dynamic ...Show All

• Visual Studio Express Editions Can I store the first column of a dataset in a string array?

  Hi! Ok, so I figured out how to populate a dataset with data via an XML file and bind it to a datagridview. But now I need to fiigure out how to retrieve the data set index and first column into a string array. The cell in the first column contains the filemame (minus the extension) of a graphics file. I need to modify the filename so I can open it in a picturebox. Any ideas well if the datatable (which is in a dataset) contains this column, you also need to specify the row number (0 based index) you want to get the data from. Example, I want row 1 of data with the filename column value back: Dim filename as String = theDataSet.Tables(0).Rows(0)(" columnName ").ToString() this will return me the value of the co ...Show All

• SQL Server cannot create jobs on x64

  Hi all, Just installed sql 2005 x64 (DB Server + Client Tools incl. management tools) and encountered the following problems: 1) Could not create jobs Getting Error: Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent. JobObjectKey '. (Microsoft.SqlServer.Smo) Tried several different job types always same result Installing SP1 does not help Any help is highly appreciated TIA Dan Please post this to the " SQL Server Tools General " forum. Thanks, Peter Saddow ...Show All

• Visual Studio Team System TFS access problem

  Hi, I've seen a thread on this issue, but it was old and didn't apply to my problem, so I decided to post a new thread. So I installed TFS in a single-server configuration (following the installation documentation to the letter), put it behind an ISA 2004 firewall and created some publishing rules so it could be accessed from outside clients. I can successfully connect to it, but when I try to create a new project, it fails when trying to contact SharePoint services on the same machine. I'll paste the exception message from the log: (I will mention that the computer name is not the same as the external DNS name)   ---begin Exception entry--- Time: 2006-10-10 20:07:44Z Module: Engine Event Description: TF30162: Task "Sha ...Show All

• SQL Server How "NOT" to expire the ReportSession and ControlID in the request

  This question is related to VSTS and above parameters in the request. Question is: A script created with VSTS for testers has hard coded values for ReportSession and ControlID in the requests, These IDs are expired after some time and scripts fails to run after few hours. Can some one tell me how to set the session expiration time on these ID's in the Report server so I can increase the value to 60*24*365 (1 year) this would solve my problem with hard coded values in the scripts for above mentioned IDs. Thanks for the comment Russell. After making the change to 525600 (1 year) if I set it back to defalt would that clean up the Temp DB for any sessions that were kept. Reason I need this value big is because these ID's are hard c ...Show All

• Windows Forms Reference Paths in publish screen

  Hi All, What is the use of Reference Paths tab in properties screen of a project Thanks. ...Show All