hrubesh's Q&A profile

• SQL Server Simple Yes/No Question Regarding Inferences

  I was looking up information regarding SQL when I came across this on a website ( http://www.dbpd.com/vault/9801xtra.htm ): 19. Redundancy is good. Provide as much information as possible in the WHERE clause. For example, if the WHERE clause is WHERE COL1 = COL2 and COL1 = 10, the optimizer will infer that COL2 =10. But if the WHERE clause is WHERE COL1 = COL2 and COL2 = COL3, then optimizer will not infer that COL1 = COL3. Is this true for SQL Server Thanks - Jason "DiZASTiX" DiZASTiX wrote: In Re Adamus: All birds have wings. All flies have wings. ================================= Therefore all birds are flies. <--Logically true but disturbing. The ...Show All

• .NET Development Is it still a bug in framework 2.0?

  KB article #322975 (BUG: Passing large quantities of data in .NET Remoting calls causes an unexpected exception to occur) is reported for to be a bug in Framework 1.0 and 1.1. I wanted to confirm that the bug is fixed in Framework 2.0. Anybody knows See http://blogs.msdn.com/robgruen/archive/2005/05/02/414090.aspx ...Show All

• Visual Studio Team System False Positive for rule CA1062 ValidateArgumentsOfPublicMethods

  I'm getting false positive hits for the CA1062 ValidateArgumentsOfPublicMethods rule. Here's a code sample that consistently throws a false positive: public object GetFirstValue( DataTable table) { if (table == null || table.Count == 0) return null ; return table.Rows[0][0]; } I use this style of validation check quite regularly. Are there plans to update the rule or is there a hot fix Thanks Lee Lee, This is a known false positive. Unfortunately, to be able to fix this rule to handle this situation would require a complete rewrite - something that won't make it into a hot fix or service pack. We do however, plan on improving on this rule in future Visual Studio/FxCop re ...Show All

• Visual Studio Express Editions How do I use normal C++, All I can use is Visual C++

  How do I use normal C++. The options only include Visual C++. Can I use C++ with a Visual C++ compiler Don't get it confused Visual C++ is really just the C++ compiler with some extentions. Think of it as a snazzy name to make you think it is great or something. So normal C++ programs will compile under the Visual C++ compiler with no problems. The visual part comes into it when creating Windows Forms programs. You have the resource editor available so you can see the window as you create it, rather than just guessing and seeing how it looks by running the program. Just remember when you create a project, create a Win32 Console application. This will give you a native C++ project which runs under t ...Show All

• Smart Device Development ListView Vertical Scrollbar

  Hi, I need to have a ListView only with a Vertical Scrollbar, but i don't know how! At this moment i have a listview with the view propertie set to List ! In this listview i have only a colummn, but due to its size (listview), an horizontal scrollingbar was created Does anyone knows how to solve this Thanks Searching on MSDN for PInvoke turned up this helpful article: http://msdn.microsoft.com/library/default.asp url=/library/en-us/csref/html/vcwlkPlatformInvokeTutorial.asp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem with rendering lines in DirectX 8.1

  Hi, Im using Visual Basic 6 with DirectX 8.1 to develop our software. In our program the user can choose to display graphics in 3D or 2D mode. 3D Mode works great without any problems. We have around 400 custumers and of them there been about 5 bug reports about 2D Mode. The problem for those few is that, when the model is loaded in to 2D mode, some of the line is not rendered. If the user using the zoom control or pan control it might come back. This is just happening for some few of the models. Other and maybe more advanced models are loaded and rendered correct. Its very hard for me to figure out what causes this problem, especially so few have reported this bug. I have a feeling that its might be something wrong with the displ ...Show All

• SQL Server Class Offerings Analysis

  Hi guys, I need a plan of action slides based on this scenarion below. Thanks a lot. The mission of the UCF Division of Graduate Studies is to provide leadership and services to create high-quality learning environments for graduate students. In support of this mission, the Division of Graduate Studies is client-centered and focused on providing the information and services that students need to enhance their experience with UCF and that faculty and staff need to effectively carry out their responsibilities to students. In an effort to continually improve the student experience, the division of Graduate Studies often conducts focus groups and other means by which to collect feedback from students regarding area ...Show All

• SQL Server Page Break after sub report - Not by design

  All, I have a report for a Quote print that has 1 table with 1 group in it by Quote #. The detail level is showing the line items on the quote and a second detail line for a sub report to show any notes. If the quote has 1 line on it, I am always getting a page break after the sub report even if it doesn't display anything. The report shows the following: Note each of these will contain a rectangle that the text boxes are displayed in unless it is a sub-report then no rectange. Group header 1 - Address information Group header 1 - contains a sub report for some notes Group header 1 - Opening paragraph Group header 1 - Blank line Group header 1 - contains the line headings Detail - contains the line details ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Smooth Sprite Animation (was Smooth Movement)

  I want to revive some of the discussions originally started on this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=691811&SiteID=1 I too have implemented a simple ball bouncing around the screen. This ball movement was jerky with the default settings (IsFixedStep = true). Changing SynchonizeWithVerticalRetrace and IsFullScreen had no affect. I found that setting IsFixedStep = false makes the animation smooth (~350fps). Setting IsFixedStep = true and changing the refresh rate of my monitor to 60hz makes the animation smooth. Setting IsFixedStep = false, TargetElapsedTime to 72fps and changing the refresh rate of my monitor to 72hz (the max, it's an old monitor) makes the animation smooth. This leads m ...Show All

• Software Development for Windows Vista Difference between ActivityValidator & CompositeActivityValidator

  What is the difference between ActivityValidator & CompositeActivityValidator I used ActivityValidator for custom composite activity. I didnt find any difference in using with activityvalidator (or) compositeactivityvalidator. Can you explain more with example please. Regards, Chakri. Answered on this post. ...Show All

• Internet Explorer Development Problem with cancel IE navigation by using Stop() method

  Hello, I try to cancel IE navigation by using BHO written in ATL (I use as example a PopupBlocker by codeproject) and to make IE to navigate to "my" url. But Stop()-Method returns the program to Invoke(...) and causes BEFORENAVIGATE2 event again instead of to stop navigation. The IE will be navigated to navigation cancel site and then to http:///. That is a code example that I use: STDMETHODIMP CPub:: Invoke(DISPID dispidMember, REFIID riid, LCID lcid, WORD wFlags,DISPPARAMS* pDispParams, VARIANT* pvarResult,EXCEPINFO* pExcepInfo, UINT* puArgErr) { if (!pDispParams) return E_INVALIDARG; switch (dispidMember) { case DISPID_BEFORENAVIGATE2: *V_BOOLREF(&pDispParams->rgvarg[0])=VARIANT_TRUE; m_spBrowser-&g ...Show All

• Visual C++ 0xc0000005 error running CLI "Hello World" program

  Recently got a copy of VS 2005 Pro and have been working through the ISO/ANSI(MFC) sections of Ivor Horton's Beginning Visual C++. Everything works great! I attempted to create the simple C++ CLR "Hello World" forms application and got 0xc0000005 which I understand means access denied. The program compiles but does not execute. I searched through the forum but did not see a solution that matched Any assistance is greatly appreciated. Thanks! Randy Thank you for your response. I'm not sure which code you need to see. I've included two files belows. If these are not correct please let me know which file This is from the debug window. 'Test4.exe': Loaded 'C:\Documents and Settings\Randy\My D ...Show All

• .NET Development Error: 'Must declare the scalar variable "@categoryID".'

  Hello, I'm creating a Data Access Layer in an ASP.NET 2.0 project in Visual Studio 2005 Professional. My database is SQL Server 2005 Developer Edition. After I Added a parameterized method to the Data Access Layer via a SQL SELECT statement (SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued FROM Products WHERE CategoryID = @CategoryID) I get the following error in the TableAdapter Query Configuration Wizard: The wizzard detected the following problems when configuring TableAdapter query "Products": Details: Generated SELECT statement. Deferred prepare could not be completed. Statement(s) could not be prepared. Must de ...Show All

• Smart Device Development Asp.Net 2.0 -- Which markup?

  Hi, Google offers mobile ads - they ask to specify the markup language in which the mobile website is written. They give these choices: wml (WAP 1.x) xhtml (WAP 2.0) chtml (imode, etc.) PDA-compliant html We are developing an Asp.Net 2.0 mobile web application, which of the above markup it will create.. Thanks Anzer This forum is smart device development related. Since your question is not related to smart device development, it's off topic here. If you’re having a hardware issue, please contact hardware manufacturer or reseller. If you having an issue with 3rd party software, please contact respective software manufacturer or reseller. Otherwise please post to relevant forum or news group: http://supp ...Show All

• SQL Server child members filtered as seperate columns in dataset?

  I'm doing some reports and i need to create individual results as attributes or Calculated members. I have a Hierachy called Injury with four options,A-jury, B-injury, C-injury, and O-injury. The Query builder only lets me put in the hierachy. So I need to get the "person count" (measure) for each individual one, instead of all together. And i dont want to filter in different datasets.I want them each seperate in the dataset with their values, as well as the total. How can this be done I've been scratching my head for a couple days now. This is the code i have right now. SELECT { [Measures].[Vehicle Count], [Measures].[Injury Crashes], [Measures].[Non-Fatal Injuries], [Measures].[Fatal Injuries], [Measures].[CrashCo ...Show All