rod_r's Q&A profile

• SQL Server Query much slower on 2005 compared to 2000

  We have a database developed using SQL Server 2000. We are in the process of testing it on SQL Server 2005. So far i've not done much testing but it has become apparant quickly that quite a lot of queries are performing much slower in SQL Server 2005. I am currently trying to figure out why a particular query is not performing well. One SQL Server 2000 it runs in around 6 seconds. On SQL Server 2005 it takes around 50 seconds. The query is this... SELECT StartBase, StartPoint, PickupPoint, PickupInstructions, SingleJourney, Destination FROM vwJobs WHERE StartDateTime BETWEEN '2006-09-01' AND '2006-09-23' vwJobs is a view in our database. The view includes many UDF's and also has a UNION which combines two seperate table structures ...Show All

• Visual Studio Team System mapping and opening from source control without Solution

  How can you get a project out of source control to edit if it does not contain a solution file We have many projects in TFS and they do not contain a solution file. There seem to be no way to get these projects back out of source control under the checkin/out policies. I do have some with solutions that I also can not seem to do anything with after the initial check in. Other can not open them either. They get a solution file but nothing else. We have tried 'get latest version' and put them on our local machines (which is where we want to do the edits) but they files are never locked for check in/out (ie no lock pic by the files) How does this work We are attempting to implement TFS but there seem to be a lack of good, material ...Show All

• Visual Studio 2008 (Pre-release) Smart & Lazy Scrollable List ;-)

  Hello, I'm using a gridview/listview in order to display a grid of data to the user. However the potential # of rows can be very very large. So: 1. I don't want to get the entire list. 2. If I can, I would like to avoid (first, prev, next, last) paging scheme. So I was thinking maybe I could break the list into pages and employ lazy loading. In other words, have a slot of pages (lets say 5 pages), and as the user scrolls, I move the slot of pages and proactively gather rows from the db, keeping a few steps ahead of the user. I realize that the user may scroll faster than the lazy-loader or may just jump to the end of the list (I'm not sure how to solve those problems yet: one step at a time I guess). I got 2 of questio ...Show All

• SQL Server JDBC Integrated Security problem

  Hi, I am using the latest 6/26 JDBC driver to connect to sql server 2000 server. My url is jdbc:sqlserver://hostname:1433;integratedSecurity=true;. I was getting the following errors "Invalid integratedSecurity property value:true". Any suggestion to resolve this problem. Thanks. Angel, I try the http://connect.microsoft.com/SQLServer/Feedback . It only allow me to search all existing bugs. But, I try to add new bug. ...Show All

• .NET Development querying datasets

  hi everbody, How to select specfic columns from a datatable in Dataset I want to select specific columns not all in datatable ,please help. Waiting for reply. Thanks Vrushali Hi, There is not direct way to get only specified columns from your datasource. You need to hide your unwanted columns thats the only way it seems to me. Though, you can filter your data using RowFilter shown below, but no direct way to filter columns. You either need to filter it directly from query you are passing to database, or hide unwanted column.. Also, My suggestion is not to filter columns (select columns) after filling up your dataset or datatable from database, instead its good to get the on ...Show All

• .NET Development how to zip an Xml Document

  Dear All, I found a library (name Chilkat ) through which i can easily zip(compress) xml file, but it has only 30 days evolution period, could any one please show me way how to compress xml. thanks Hi, you will have to specify the DocumentElement, the aDataSet node as the node you pass in to be zipped, that way all of the nodes will be zipped i.e. XmlTreeZipper .ZipNodeDescendants(xmlDoc.DocumentElement); XmlTreeZipper .UnzipNodeDescendants(xmlDoc.DocumentElement); Mark. ...Show All

• Visual Studio 2008 (Pre-release) Visual Brush Help PLZ!!

  Hello all, I have this ticker I made and it works fine. A ticker element slides onto a StackPanel and stops at the StackPanel's x coord divided by two. Then it pauses (timer) and then slides off the StackPanel. At that point a new ticker element slides onto the StackPanel. Like I said, works great, but when I try to VisualBrush it onto a simple 3D shape (XAML) it never slides in or out, rather is just streaches itself from huge to normal size and then when it is supossed to leave it streaches itself huge again. SO, basically the 3D shape is never empty, it ALWAYS contains the ticker element. Anyone know how to solve this Thanks, in advance, Victor Hi, Victor. The issue here is that, by defaul ...Show All

• Visual C++ Translating TCHAR to String

  Hi,   I'm trying to get directory/path from where application is currently running.  I'm using following code: TCHAR DirBuffer[50]; DWORD dwret; dwret = GetCurrentDirectory(50,DirBuffer);   BTW, I'm getting "GetCurrentDirectory" from "System::IO" namespace.  I tried in debug mode and could verify that the function was functionning properly and is giving expected result. My problem here is that I don't know how to convert the DirBuffer variable which is a TChar into a String variable.  Any clue Thanks in advance, Stephane   Take a look at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=514738&SiteID=1 Hope this helps! Thanks, A ...Show All

• Windows Live Developer Forums Getting the Direction between 2 points.

  Hi all, Let me see if i can make you understand what i need to do. I have two points (like latlong points), and i want to know if X is set 'north ou south, east or west' from the Y point. Please if you know, tell me how to do that. And also please tell me if you don't understand what i mean. Thanks Ton You mean you want to get the bearings Theres an algorithm here for doing that given lat/longs http://www.movable-type.co.uk/scripts/LatLong.html ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Quake bin release

  First release! You can move the player in fly mode only inside the map E1M1. Everything is packaged together so you don't have to download the Quake demo in order to play this. I only support playing with 360 controller for now. Its still far from complete but at least I can start working on the gameplay now that im done with the levels. For updates please visit my blog at http://perpixel.spaces.live.com/ http://perpixel.dyndns.org/~guillaume/xna_quake_release_0.01.rar I get an error when trying to run it... "An unknown error has occurred. The result code was -2005529767." at Microsoft.Xna.Framework.Graphics.Texture.Save(String filename, ImageFileFormat format) at Quake_Win32.QDraw.r_bi ...Show All

• Software Development for Windows Vista How to persist and reload a workflow instance to sql datastore

  Hi Iam new to wwf and trying to persist/save workflowinstance to sqldatastore i have looked at the samples provided with sdk.in hosting.persistance sample it uses delay activity to call OnWorkflowIdled event to persist to database and clearing in unload event.I need to persist the instance to sqldatastore and track the instances.Which events/methods to use for persisting workflow instances and how to track the instances.I would be great if any one have code sample to persist and track an instance. Thanks in advance SVNR If you are using the SqlWorkflowPersistenceService then you can configure it to persist automatically everytime the workflow goes idle, by specifying the unloadOnIdle pa ...Show All

• SQL Server How to get status for every individual Task in a package

  Hi, I have a package in which there are four tasks. I have to get the status of those four tasks and finally send a mail. I am unable to get the status for individual task. Has anyone tried this Please help. Thanks in advance. Hi, Create 'OnError' and 'OnPostExecute' event handlers for each task. In the 'OnError' event, set the error message to a variable. In the 'OnPostExecute' event, check the variable. If is it empty set the status as 'Success' or else set it as 'Failure' with the error message. In that event itself, u write the status to a file in append mode (first task should open the file in overwrite mode). Hope it would help. ...Show All

• Visual C# How to edit ico files in the solution?

  When I double click on my application icon in solution explorer, it comes up in MS Paint, not in VS.net's icon editor. I checked file associations, and ICO files were not associated with anything, so I set them to VS.net -- made no difference. Tried Open WIth.. "Resource Editor" (Is that what the icon editor is called ) get modal message box "This file cannot be opened with the selected editor". Now if I reset the application to not have an icon, and attempt to edit the ico file, it opens with paint. How do I get it back in the icon editor again Thanks in advance this seems like it would be so easy... "I'm going to deinstall .net to get rid of SP1 (Beta) and see if that helps. It's always the ...Show All

• Smart Device Development How to debug a dll during deployment

  I have added a cab project to my solution. Now I can deploy my dll and test changes in the emulator due to it. Now I want's to debug whole deployment process or simply you cn say I want's to debug the dll[It is a self registered dll] When I debug application I get this error --------------------------- Microsoft Visual Studio --------------------------- Unable to start program '%CSIDL_PROGRAM_FILES%\ctxmenu\mymenu.dll'. The system cannot find the file specified. --------------------------- OK --------------------------- What Can I do Looks like you have posted similar questions in several threads - it would work out better if there was one thread for everyone to read and determine the problem In this th ...Show All

• .NET Development Can't connect to database from web service!

  I have a web service that I am trying to get to connect to a SQL 2000 database. I have tried connecting with ODBCConnection and OleDbConnection and I am not able to open a connection with either one. The code I tried with both of these connection methods works fine in a .Net Windows Forms application. It seems to fail both times on the connection.Open() call for whatever reason. Anyone know what might cause this and a solution I can do Thanks, Michael do you have access to edit the code try { connection->Open(); command = new OleDbCommand(query, connection); reader = command->ExecuteReader(); reader->Read(); if (reader->HasRows) { this ->recurren ...Show All