S.Sriram's Q&A profile

• SQL Server SSIS and its scale-up architecture

  A simplistic question yes, but I would like to hear thoughts... SSIS is currently designed as a scale-up architecture vs. a scale-out architecture. What have people found as more important for SSIS when trying to maximize performance and throughput for an SSIS infrastructure running in production -- faster processors (e.g. 3.4 -> 3.6 Ghz), more processors (e..g dual -> quad), more memory (e.g. 2 GB -> 8 GB). The easy answer -- EVERYTHING :-), but is there one vector that is more important than the other if only once can be chosen I am assuming Xeon processors, not Itanium or anything at this point in time. Thanks... ...Show All

• Visual Basic Are RANDOM files fast?

  I'm thinking about creating a random file of 200,000 to 1 million records.  Is that a good way to create a text database   Would accessing data be quick or would I get like sequential file results    IMO, it would be hard to make a good case for using a single text file for such a large number of records (i'm assuming that's whay you mean when you say "Text Database")   You could write code which would find particular records and return them (i.e. "randomly" access the data, but I'm sure it would be very slow.  Much better to use a proper relational database ...Show All

• SQL Server Can we use User Defined Functions in Report Builder

  In a typical Database, there are tables, views, stored Procedures, user Defined Functions. We could use tables and views in designing the Report Model. We cannot use Stored Procedures, I tried that. Please could somebody tell me if we could use User Defined Functions What if a view is already using a user defined function, is the function automatically includid in the Model Design Thank you, You can use SP of course. You must set the CommandType as "StoredProcedure". You can not use functions, and they won't be included in your report. ...Show All

• Visual Studio AssemblyInfoTask crash

  AssemblyInfoTask is crashing if an input file doesn't have an AssemblyVersion or AssemblyFileVersion property set. Is this by design It'd be nice if it could automatically add a default version, or a version based on the information given to the task, to the input file. The task also crashes if you run it on a file that has the old VS2003 style AssemblyVersion attribute with asterisks. ...Show All

• Visual Studio Team System VSTS - Error creating team project (TFS30177 - Team Foundation creation failed)

  Hi, I recived this error after installing the VSTS and I tring to creat a new team project for the first time. Does any one know about this problem This is my log file: Module: Engine Event Description: TF30162: Task "SharePointPortal" from Group "Portal" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: Unable to connect to the Windows SharePoint Services at DIRECT-TAESPPWQ Exception Details: The Project Creation Wizard was not able to connect to the Windows SharePoint Services at DIRECT-TAESPPWQ. The reason for the failed connection cannot be determined at this time. Because the connection failed, the ...Show All

• .NET Development SQL in Visual Studio 2005

  I am using Visual Studio 2005 Express Edition. I have a windows form that gets info from a database. And outputs. I want to make a search capability that a user can input in a text box and the SQL query checks the database for the right row in the database and output the results chosen. In this case, docName and docLocation on my form. My SQL query for the search is not working properly. SQL statement: SELECT ID, docName, docLocation, indexDate, indexAddress, textSearch FROM tblDocInfo WHERE (textSearch LIKE '%" & TextBox1.Text & "%') When you say it isn't work ...Show All

• SQL Server Inserting multiple nodes as type xml in SQL

  Hello, I'm working with SQLXML for the first time and need help! I am working with a customer who passes a CSV from an old accounting system, from which I use XSL to transpose it to a more logical xml document, each row of the CSV matches an item node. <data>     <purchase>          ...          <order>          <OrderID>1</OrderID>              <item>             ...Show All

• SQL Server Could not load file or assembly ADODB, Version=7.0.3300.0

  I have an application broadly deployed (about 10 computers). As of yesterday, two of these computers are unable to start the application, and failing with the error below. All other computers run the application just fine. System.IO.FileNotFoundException: Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. File name: 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' I checked and ADODB.dll version 7.0.3300.0 is in the GAC in the deployment target machines. I fin ...Show All

• Visual FoxPro foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.

  foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc. I was given a foxpro program and i would like to see the code (the formulas)... i'm not sure how to do this... thank you...   Don--while I also tend to believe that VFP gives better performance than Access, I don't think your one example proves anything. How many times do we hear someone running down FoxPro because they've encountered one badly-written app Tamar ...Show All

• Windows Forms IsUpdateRequired manifest entry

  Where in the manifest can you specify that the deployment is a required update I see that in a lot of places MSDN states "When you deploy an update to your ClickOnce application, you can mark it as a required update" but it never says how to do it. I cannot find an option in MageUI to make an update required and have not been able to see a field in the deployment manifest. Does anyone know where I set this boolean value I am not aware if such boolean value exist in the manifest. But here is one that I know. The way it works is put minium required version. (mrv) Let's say app foo is versi ...Show All

• SQL Server Creating SQL 2005 Logins during installation

  Hello, We use one standard account with a password that is never given out. In SQL 2000 we had a script to extract the password in encrypted format so that it could be run as part of the installation process. That same process does not work for SQL 2005. Below is a sample of the script that we were deploying for SQL 2000 installations. ------------------------------------------------------------------------------------------------------------- -- Login: CPAPP declare @pwd varchar(50); SET @pwd = CONVERT (varbinary(256), 0x01003402EC1BDADF45C9D788C23459BC36D73E5B2B9F2F235138F6BB8D0CD2317FCBA41EB59D191801AC287A14FF) EXEC master..sp ...Show All

• .NET Development text in textbox changed?

  I'm writing a web app that has a gridview bound to a set of data. I changed the view to show the data in textboxes so the user can easily modify the data, but I do not want the data to update the database. When they click submit, I would like the old and new text posted on the next page (I'm passing the data using session varables). But, when I make changes to the data in the textboxes, the new data is not passed but the old data is. I've tried to code an ontextchange method, but can not find the correct code to get it to pass the new data. Here is a sample of the code I am using: This is the code to get the data in the textbox fi ...Show All

• SQL Server snapshot replication problem

  hi all, I grouped my tables into two publications To each publication i added my "datamart1" server as a subcriber  using the same database as a destination   I dont have problem when i create snapshot since each of the publication generates its own snapshot.   The only problem i encounter is that. when i begin to sychronize any one of the two subscription The two subscription gets synchronized.   I need to isolate each publication's syncronization to know exactly how much time would each publication take to get  synchronized in the datamart   thank ...Show All

• Visual Basic use of tool box components

  I'm a newbie with vbexp.edition. My question is how do i learn what to enter into the toolbox components that i will be using, I ask this because the short explaination given when i click the component is difficult for me to understand. I guess what i'm asking is which is for numbers and which is for text.   not sure what you are asking...but most components are type independent...however components like the textbox take your objects and tries to convert them to a string representation for disply.... with option strict off me.textbox1.text = 10 10 is converted to a string of "10" for displa ...Show All

• .NET Development Convert Integer value to byte Array

  Hello I have an integer value and byte array variable like this : int intSize = 11522; byte [] _Size = new byte [4]; How can i to convert the integer to byte array Thanks one way: _size[0] = intSize & 0x000F; _size[1] = (intSize & 0x00F0) >> 8; _size[2] = intSize & 0x0F00 >> 16; _size[3] = intSize & 0xF000 >> 24; or _size[0] = intSize & 0x000F; _size[1] = (intSize >> 8)  & 0x000F; _size[2] = (intSize >> 16) & 0x000F; _size[3] = (intSize >> 24) & 0x000F; or ...Show All