wsaunders's Q&A profile

• SQL Server Are stored procedures more performant than on the fly sql?

  Hello. I've read the other day (don't remember where :( ) that there is no performance advantages on executing stored procedures than executing sql strings made "on the fly". It said that both operations are precompiled on first execution, and then cached to posterior executions... Is that correct Thanks in advance, Matias Satya, your answer is a bit confusing.... are you saying that Stored Procedures ARE faster then on the fly SQL or are you saying they are NOT my understanding is that they ARE especially when the SQL is more complex. This is not the only reason to use sprocs however, other reasons are improved security, improved maintainability and modularity, etc. cheers, ...Show All

• .NET Development Image Upload Recommendation

  I have developed a client/server application using a PocketPC2003 device and a local Windows PC. One of the features of the application is the ability to take pictures and assign them to a record.  I'm able to upload the record to the server quite simply using sockets and a message system I've developed(using xml), but I'm a little stuck with the best way of sending the images. Currently I'm trying to investigate configuring a local website (as I need to send updates to my server as well), and being able to send/receive files within the website (simply because the customer will want to view the images on remote sites) But I can't quite figure out the best way to transmit my images up to the server. Really, I'm just looki ...Show All

• SQL Server Visual C++ 2005 (C++/CLI) - Newbie with ADO

  Hi, I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database. For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine... When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratc ...Show All

• Visual Studio Team System Huge STS_Content_TFS log

  Hi, I have a TFS database with some (small) projects in it. The sts_content_tfs database has a log file with a size of 48 GB. Is this normal How can I shrink this file, i'm running out of diskspace Thanks, Perry HI Perry, Dennis is absolutely correct. The database is used by share point to store the files on project sites. You can read following article on truncating the size of transaction log in SQL Server. http://support.microsoft.com/kb/873235 Hope this helps. regards ...Show All

• Visual Studio 2008 (Pre-release) Where can i get information about Attributes, etc.

  Hello, where can i read about attributes that exists for an element For example: for the button element, there is sure more attributes but where can i read about them all Does exist a reference manual with attributes/elements and small code samples or something like that < Button Click = " ButtonOnClickedHandler " Name = " MyButton " Width = " 50 " Content = " ClickMe! " /> cya To get the list of attributes in Visual Studio you need to install this: http://www.microsoft.com/downloads/details.aspx FamilyID=935aabf9-d1d0-4fc9-b443-877d8ea6eab8&DisplayLang=en The offline help is included with the Windows SDK that you can download f ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Question: 2D development for both widescreen and standard on 360

  If you want a 2D game to run on 360 for both widescreen and standard TV sets, would the easiest solution be to 'center' your game to fit a standard TV and have verticle bars on either side for people using widescreen What resolution should you develop your game in so it doesn't end up being stretched when running on a 360 Thank You. Something to be aware of when targetting HDTV resolutions is that at 1280x720 you can fit a whole 32 bit rendertarget and depth buffer into the Xbox embedded framebuffer memory, which is 10 megabytes. 1920x1080 requires 16 megabytes, so you have to render your scene in parts. This is generally easy to do (there's lots of magic in the drivers that takes care of things for you) but can cause complicat ...Show All

• Visual Studio Tools for Office Can't Remove VSTO project reference in VBA

  Hi, I have created a an Excel 2003 VSTO action pane project. The actionpane works internally and accesses webservices within the domain. The user can use the task pane to access secure data and manage non-excel calculations utilizing the networks resources.. Here is the problem. This works great internally, but if a user wants to email this spreadsheet to a client/customer that does not have VSTO installed VBA code does not work correctly. The intent will be to use VSTO to "prepare" the spreadsheet, then send the spreadsheet to the cutomer. VSTO itself will not work when the Excel document is received by the customer...which is fine, however the non-VSTO vba code will not work because of the missing VSTO reference. The use ...Show All

• SQL Server message lost

  Hi... My service broker was working...all of a sudden it stopped working...so i figured out destination queue was disabled and I set it as ALTER QUEUE SERVERQUEUE WITH STATUS = ON , RETENTION = ON , ACTIVATION ( STATUS = ON , PROCEDURE_NAME = usp_OnReceiveMessage , MAX_QUEUE_READERS = 5 , EXECUTE AS OWNER ) Also altered my database for trustworthy after going through some posts previously. Now the message is sent...i dont see any message in my tranmission queue but i dont receive the message in destination server. When i checked endpoints... select * from sys.conversation_endpoints I see the last message with st_desc as conversing... how do I solve this... Thanks, Pramod ...Show All

• Visual Studio SKU011.CAB solution

  Go into Registry Editor (Start, Run, "regedit"). Go to HKEY_LOCAL_MACHINE, Software, Microsoft, Office, 11.0, Delivery. There should be only 1 directory under Delivery, which is your DownloadCode (mine was 90000409-6000-11D3-8CFE-0150048383C9). Select that directory. On the right side of the screen, right-click on CDCache. Change the value to 0. honestly works with out a hitch. I followed your directions but was unsuccessful!! There is as you indicate only 1 directory under delivery but the number differs from yours - however on the right side of the screen under DownloadCode that number is the same as yours. I am puzzled as I was under the impression the directory under Delivery would be the same as the number on t ...Show All

• SQL Server Error deploying Analysis Service Project

  Hi, We are following the Analysis Service Tutorial and when we tried to deploy we got these errors: Error 1 OLE DB error: OLE DB or ODBC error: Login failed for user 'PASCAL\CEZAR$'.; 42000. 0 0 Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'Adventure Works DW'. 0 0 Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Time', Name of 'Time' was being processed. 0 0 Error 4 Errors in the OLAP storage engine: An error occurred while the 'CalendarYear' attribute of the 'Time' dimension from the 'Analysis Services Project1' database was being processed. 0 0 Error 5 OLE DB error: OLE DB ...Show All

• .NET Development XML,XSLT and ASP.net

  Hi, I need to render the XML document in a ASPX page, using XSLT. I am not able to handle multiple if conditions in the xslt file. I have rendered the choice as a dropdown in the XSLT. But I should place a condition, on the value 'Yes' in the dropdown, the checkbox and the label should appear.. This is my XSLT file. <xsl:choose> <xsl:when test="$choice='Yes'"> <xsl:for-each select="question/choice/question"> <xsl:if test="@type='lbl'"> <asp:Label Cssclass="styletextsublabel1" runat="server"><xsl:value-of select="@value"></xsl:value-of></asp:Label> </xsl:if> </xsl:for-each> <xsl:if test="@type='checkbox'"> <asp:Checkbox runat="server" Cssclass="stylepadding"> <x ...Show All

• Visual Studio Team System Data Compare - Not all tables available

  Hi all, when I make a new data comparison, I don't get all the tables that I have in the source database. Can someone tell me what can I do. Thanks in advance. P.D.: Sorry for my English. Unfortunately yes. If a table does not have primary key / index, there is nothing to compare against. Thanks Victor for your feedback. ...Show All

• Visual Studio Express Editions msgbox

  how do i use the if then to act on whichever button was pressed, like the yes no for example you would be looking at the dialog result of the MessageBox. This is the way of doing so: if MessageBox.Show("Message", "Caption", MessageBoxButtons.YesNo, MessageBoxIcon.Question) = System.Windows.Forms.DialogResult.Yes then 'the user pressed the yes button else 'the user pressed the no button end if to give the MessageBox the buttons, you need to look at the MessageBoxButtons enumerator, it supplies you the buttons that you can show to the user. The MessageBox also returns a DialogResult, the value returned based on the user's choice and you look at the DialogResult ...Show All

• SQL Server SQLRUN_SQL.MSI is not valid for Service pack 1 SQL 2005 command line REINSTALL

  Hello, I have recently tried to run this command line utility for SQL Server 2005 - "start /wait \sqlfoder\setup.exe /qb INSTANCENAME=myinstance REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[password] SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI" Unfortunately I recived an error stating the "Installation package for the product SQL Server 2005 (64bit) cannto be found. Please locate a valid SQLRUN_SQL.MSI". Which I couldn't find anywhere., so.... I created a fresh instance on my 2005 server, held back on installing SP1, and ran the command line again. This time it worked. My best guess is that the installation scripts check the version header on the MSI file during install and display a compatibilty error t ...Show All

• Software Development for Windows Vista InfoPath 2007 and Workflow .net

  Hi All, I need some assistance with integration of InfoPath and MOSS 2007. In particular Workflow. I am trying to find samples with InfoPath triggering Workflow. Here is a simple scenario I am working on. Ive tried using Sharepoint Designer to work through it but unsuccessfully. InfoPath Form – Request Includes name, personnel number, leave date from, leave date to and reason text. Workflow - <= 10 days, send email to single manager for approval. Workflow - > 10 days, send email to two managers for approval. ASP.NET Form – Approval Custom application for performing approval. Shows details of request and option to Approve/Decline including reason text. Workflow – send emai ...Show All