Rosaria's Q&A profile

• SQL Server Example of merge ,hash and nested join

  Could Any body Please give me one example of each of three types of joins that is Merge Join Hash Join Nested join    I am not quite sure if I understood you right. You can force the join algorithm by specifying a join hint. For example, the join: /*Nested loop join*/ select * from Orders O  inner loop join Customers C on  C.fCUSTOMER = O.fCUSTOMER will be inner loop join, regardless of whether the optimizer considers it the best or not. Indeed, you can force hash or merge join either by specifying "hash" or "merge" instead of loop. Maybe you want a description of how the SQL performs those joins Or, you want ...Show All

• Visual Studio 2008 (Pre-release) Compile error

  I had the PDC 2005 LINQ Preview version installed and was able to create a LINQ console application in VS Beta 2.0. I ran into the following error in compilation "; expected" in the p declaration using System; ..... using System.Query; using System.Xml.XLinq; using System.Data.DLinq; var EvenNumbers = from p in Number where p == 4 select p; What did I miss Thank you all in advance for your help I found out what the problem was. After the installation was completed, the screen will follow with a page as the link below: C:\Program Files\LINQ Preview\Docs\ReadMe.htm. Go down to the sec ...Show All

• Visual Studio Tools for Office wordObject and Printer Tray selection

  I’m developing a windows based application in .net and I’m using Word object for maintaining and printing documents. Well, here is my problem: I managed to do the printing stuff using the word object's property itself. I picked the Bin Numbers of my printer and I assigned them like wrodObject.FirstPageTray = (int) 260; (the number for "Tray 2" I got it from DeviceCapabilities API). But still the paper is not picking from the "Tray 2" it is taking only from "Tray 1". But in order to solve this Issue I contacted HP Printer support team and they said to change the "Tray Mode" to "Cassette" from "First" in "Paper Handling Menu" of the printer ...Show All

• Windows Search Technologies WindowsSearchSafeFilter.exe takes all available CPU cycles

  Anyone seen this before After I install WDS, this process will take over all available CPU cycles, stopping me from using my system. I have disabled my On-Access AntiVirus scanning and it did not help the issue. Thanks in advance. Hi, any news on this issue It started happening to me a week ago (after a few months of WDS usage) and it practically renders my computer unusable every now and then (takes 100% of CPU cycles). For example this morning I received 2 e-mails with ZIP attachments (cca 500 kB each), and that seems to be the problem. Even if I write a new e-mail, the lag happens. UPDATE: It also ...Show All

• SQL Server Tricky Grand Total on Column Needed

  OK, I've created this query so far: Select Distinct CustomerName,                     CustomerNumber,                     FGoal AS FG,                     FSched,                     (cast(FeeGoal as numeric(30,10)) / FeeSched) * 100 AS gt from DR WHERE e='001' group by CustomerName, ...Show All

• Visual C# Keep getting exception message that Type is not marked as Serializable

  Hello, I a pretty sure that I am on the right track. I am trying to serialize a object which has a multitude of member variables. Some are collections of graphics based objects ie objects which are drawn in a view (TabPage derived). The object to the serialized also is drawn in such a view. It is like a parent object that contains other objects. I have separated code from data so that I am not trying to serialize anything like the TabPage view or Pens, Brushes.... Despite this, I am continually getting an exception when trying to serialize the object. I am being told that a view of mine OpeningsView is not marked as seriali ...Show All

• Smart Device Development Could you recommend a test tool for .net cf?

  Could you recommend a test tool for .net cf ...Show All

• SQL Server regarding sql server

  i installed visual studio2005 beta2 from my vstudio team system. when i selected complete installation, it also installed sqlserver2005 CTP. im able to access sqlserver databases from server explorer of vs IDE but i dont find any interface of sqlserver appln program. in start menu>programs>ms sqlserver 2005CTP>configuration manager... only exists and nothing else and what is the need for sql server management studio. Is it an interface for accessing sql server You can download SQL Server Management Studio Express from this URL http://www.microsoft.com/downloads/details.aspx ...Show All

• Visual Studio 2008 (Pre-release) wsDualHttpBinding , IsOneWay and ConcurrencyMode.Reentrant

  Hi I can't understand which is the motive to this interface doesn't work origining a deadlock: [ ServiceContract (CallbackContract= typeof ( IObserver ))] [ServiceContract(CallbackContract=typeof(IObserver))] interface IElement { [OperationContract] void Subscribe(); [OperationContract] void Unsubscribe(); } interface IObserver { [OperationContract] void Action(); } I know that If I use the behavior attribute [ ServiceBehavior (ConcurrencyMode = ConcurrencyMode .Reentrant)] in my service class all works fine but I don't understand why Any clue Thanks in advance Javier ...Show All

• Smart Device Development MoveFile() on SD-Card

  Hi all, Can someone tell me if the function MoveFile(src, dest) works with paths that pointed on a SD-Card Example: srcpath = \SD-Card\Test\file.txt destpath = \SD-Card\Test\file2.txt MoveFile( srcpath , destpath ); DWORD error = GetLastError(); error is 3 which means "The system cannot find the path specified." Regards, Karin Mine is called "SD Card", without the dash. Someone here posted a method for getting the name of a storage card; might be worth looking for. ---Mike ...Show All

• Smart Device Development AnimationControl issues

  Hi All, In my application (C# CFNET 1.0), I do utilize one animation control. It has been running fine until I introduced a separate thread to perform background processing (BinaryReader) The problem is, the animation stop moving when the background thread is start running. The control is still active though. Because, if I try to call other form, the animation will change a little bit. I heard that animation control refer to IEnumerator and IEnumerator is not thread-friendly. Is that true Can I know on how to work around this issue Also, in Compact Framework 1.0, can I know what are the tools we can use to debug all these thin ...Show All

• Visual Studio Express Editions Excel VBA ADODB to VB 2005 Using System DSN Access Database

  This is probably basic 101 for you guys as I have searched the forums and have found no questions RE: Above. Basically I started using VBA with Excel and I would like to convert a solution to VB 2005. I'm Stuck big time with retreiving information from my existing Access Database. With Excel I would use the following to populate textboxes on forms; Sub GetProdDetails() Dim strSQLProdDetail As String, ProdCode As String ProdCode = frmProduct.cboProduct strSQLProdDetail = "SELECT Product, Desc, ShipQty, ShipWT FROM tblProducts " & _ " WHERE Product= '" & ProdCode & "'" ...Show All

• Smart Device Development device emulator is not starting in windows 2000 with sp4?

  device emulator is not starting in windows 2000 with sp4 why not please help tell the errors however you can also check some seetings make sure your emulator is installed properly check you boot.ini and check if /noexcute is writeen in the path.if its /noexecute change it to execute. is the problem i not solved then tell your errors in details. multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows 2000" /fastdetect /execute ...Show All

• Windows Forms Create a progress bar of sorts

  Hey I tried posting a question about removing paint here:  http://www.windowsforms.net/Forums/ShowPost.aspx tabIndex=1&tabId=41&PostID=19088 But maybe I should be asking how I could acheive the desired effect instead of trying somthing that might not work properly.. What I want: I want to make a splash screen for long running operations.  I don't need to know how long an operation&nb ...Show All

• Visual C++ PAGE_EXECUTE_READWRITE and the CLR -- debugging issues

  Hi -- I just compiled a C++ app with the CLR flag for the first time that I had previously only compiled to the native code platform. I did this so I could write debug information to the Output window, but I will want more extensive interaction with the managed environment in the future. In my app I allocate a piece of memory with VirtualAlloc with the PAGE_EXECUTE_READWRITE flag set and then proceed to generate some intel code to that memory. I'm finding that when I compile with the CLR flag I can no longer use the debugger to view my generated code in the disassembly window, which of course prevents me from setting breakpoints or tra ...Show All