sweetcheeks's Q&A profile

• SQL Server Do Table Value Functions eliminate parallel execution plans?

  In the SQL 2005 help doc on the table data type, it states " Queries that contain table variables do not generate parallel query execution plans. Performance can be affected by the presence of very large table variables, or table variables in complex queries. In these situations, consider using temporary tables instead. " Does the use of a table-valued user-defined function incur the same penalty, since it is returning a table date type Thank you, I finally understand! ...Show All

• .NET Development cant not save data to my Sql database

  MyTable; Table Name: Words WordsID int PK(1,1) , Word nvarchar (10),Threes nvarchar (1000) Allow Nulls,Fours nvarchar (1000) Allow Nulls,Fives nvarchar (1000) Allow Nulls,Sixes nvarchar (1000) Allow Nulls,Sevens nvarchar (1000) Allow Nulls My Proceedure; ALTER PROCEDURE addWord @Word nvarchar (10),@Threes nvarchar (1000),@Fours nvarchar (1000),@Fives nvarchar (1000),@Sixes nvarchar (1000),@Sevens nvarchar (1000) AS INSERT INTO [Words]([Word] ,[Threes] ,[Fours] ,[Fives] ,[Sixes] ,[Sevens]) VALUES (@Word ,@Threes ,@Fours , @Fives ,@Sixes ,@Sevens) RETURN My Function; public sta ...Show All

• Visual Studio Express Editions help with Visual Studio Web Developer, Layout

  OKay I don't know if this is a common problem or if it's just my machine, but When I use Microsoft Visual Basic.Net at Work and Visual Studio Web Developer beta at home, Now The problem is in The Beta Edition, When I add things to the screen, When I create a new Web Form, ex: aspx Page, And Drag tools or items onto the page they default to the top left of the screen.  Now in .NEt I am able to place the tools from the web form Anywhere on the page.  I Can't figure out if this is my only option to display things in a page format from the top left in Beta or is anyone else having the same problem, Is this the default, Can I change it, ...Show All

• SQL Server Error in the Metadata Manager

      I'm attempting to deploy a new solution on AS 2005 developer edition.  Apparently, a previous, unrelated solution deployment has a problem, and this prevents me from deploying mine.  I've cleaned up the data directory, tried all sorts of options, but still I get the same thing.  Here's the error: Error     1           XML parsing failed at line 2, column 0: A document must contain exactly one root element. . Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\ \E:\SQL 2005\MSSQL.2\OL ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Why does my window go blank after a resize?

  Just as a quick test too see if I understood how directX initialization works attempted to creat a new DX window using windows forms from scratch. But I have a problem... Can anyone explain to me why the triangles rendered in the following code disappear permanently when ever i resize the window I have comparable code that doesn't disappear when I resize but after hours of comparing I just can't see why one code works and this one doesn't. namespace DXTest { public partial class DXForm : Form { private Device myDevice; private PresentParameters presentparams; protected CustomVertex . PositionC ...Show All

• SQL Server Fit dataset on one page

  Hey guys, Let's assume I have dataset with two columns (A,B) and it has 100 records. I'd like to split this dataset on the same page with 25 records in every column. Side by side. Example: ColA ColB ColA ColB ColA ColB ColA ColB 25 rec 25 rec 25 rec 25 rec What should I use and what properties I have to play with Thanks. Just a quick drop answer: - I asume regular column format does not work for you because you want  balanced columns and RS gives you unbalanced ones. - I asume you have a static format= always 100 records, always 25 records/column, or alike. In t ...Show All

• Visual Studio Team System Installing Test Agent and Controller

  I have the TFS Beta 3 Refresh and the trial of VSTS. I'm looking for the latest and greatest Load Test Controller and Agent, but I can't find them on either of these images. The only instance of the controller/agent I can find are on the en_vs_2005_test_load_agent_beta2.iso. Is this the latest version of the apps and will they work with Beta3 TFS/vs 2005 Thanks There is an instance of the Load Test Controller/Agent on the trail VSTS.  Just make sure you have the configuration set to remote instead of local . . . they can be found in a load test project. ...Show All

• Windows Forms DataGrid View - Ctl+0 to null out a combobox column

  I have a DataGridView which has a DataGridViewComboBoxColumn column named "Assigned To" which allows users to assign tasks to a user of the system. The DataGridView is databound to a DataTable called "Tasks" and the "Assign To" dropdown is databound to a table called "Employees". The linkage between the two tables is employee_id. I would like the users to have the ability to un-assign a task. I am having problems setting the "Assigned To" value to null. I had two solutions to accomplish this: 1) Let the user hit "Ctrl+0" to null out the assign to value 2) Add a blank item i ...Show All

• Visual Studio How Can I add some data to specific page ??

  Hi I have report and I know it's only 3 pages …. If I need to add some text data to page 2 .. How can I do that Means How can I add text information (maybe from Parameters) to specific page .. Like only page 2 And thanks with my best regarding Fraas Otherwise place the textobject in the section where you want. Rightclick the object. Go to Format.Enable the supress option and click 'X-2' (formula Editor) and write 'pagenumber<>2'. Hopefully it will help you ...Show All

• SQL Server VSA vs. VB.NET

  The Script Task uses VSA (Visual Studio for Applications) for scripting which some people refer to as VB.NET. I think that VSA is a subset of VB.NET, but not identical in all respects Do you know of any URL's that document the differences bewteen these languages TIA, Barkingdog I believe that VisualBasic.Net in VSA is the full monty and I could not find any references that suggested otherwise. Is there any particular issue causing you problems Donald ...Show All

• SQL Server Analysis Services 2005 Drillthrough

  Is there a way to replicate the same behaviour of Analysis Services 2000 drill-through into Analysis Services 2005 This new version allows drill through only to cube data and not to the source data (SQL Server for example). I don’t want to load cubes with detailed data that I don’t need for making calculations, but I want to let this details to be visible to users only with drill-through analysis. Thanks.     Dear Deepak, I'm doing some tests with degenerate dimensions for DrillTrhough and have some more questions: 1 - If I have a cube with two partitions (for t ...Show All

• .NET Development Publish app and other files

  Ok, I have gone through and made a sample application and now I want to publish it.  The app has several ASCII text files that it uses and I need to get these files published with it.  The clickonce publish seems to get the app installed ok, but I also need to get the text files published out as well.  How can I do this You need to add the files to the solution and in each file's properties pane select Content and Always Copy. Note: You also might need to check your Application Files under Publish to make sure that they are included in the list of files to be published. ...Show All

• Visual Studio Team System How to hook build engine to get sources from another server?

  Hello all, I want to interoperate the TFS with a server using VSS as repository. How can I go about it Environment: Presently clients are on VS .net 2003 IDE and server has VSS as repository. The project uses .NET 1.0 framework. What I want: I have introduced TFS server m/c which i want to get the project sources from the VSS server and build them. So, how can I hook build engine to get sources from VSS server Thanks in advance. Nike   We will definitely consider this integration for Team Build later, but for this release (RTM), I am afraid this will not be supported. Thanks for the suggestion Nike. ...Show All

• Windows Forms making application threadsafe

  Hi, I have a multithreading application in which I am using a control to which I add datapoints to plot a graph. There are various functions in the application that adds or remove points in the control, and these functions can be executed by more than one thread at a time, as  a result I get multithreading error randomly , such as   Syst ...Show All

• Visual Basic What are the new keys for F2 and ShiftF2?

  In VS2002 you could jump to the definition of a variable with F2 and back to the previous location in the edit window with ShiftF2. What are the new keys for this Tosch All keyboard settings are customizable. try Menu>tools>options>environment>keyboard. View.NavigateBackWord View.ObjectBrowser ...Show All