anukirthi's Q&A profile

• SQL Server how to improve the speed of sort?

  i have found the speed of sort is very slow in my sql (because sql is very complicated, i can't paste it on this page), how can i improve the speed of sort are there better methods thks --Comment: the last aggregate query, it spents 4.44 minutes --Start for ObjectAgg:LocalNetID,BSCID,SiteID,CellID,StrTime select LocalNetID,BSCID,SiteID,CellID, StrTime, sum([11601]) as '11601', sum([11602]) as '11602', sum([11603]) as '11603', sum([11604]) as '11604', sum([11605]) as '11605', sum([11606]) as '11606', sum([116060]) as '116060', sum([116061]) as '116061', sum([11607]) as '11607', sum([11608]) as '11608', sum([11609]) as '11609', sum([11610]) as '11610', sum([116100]) as '116100', sum([116101]) as ...Show All

• Visual Studio Tools for Office Restart Customization from within the Assembly?

  Hi, In my customization assembly, I implemented the following exception handling approach. I handle a finite set of known exceptions and the rest of exceptions are considered unknown exceptions (i.e. bugs), which should simply generate a crash dump and restart the customization, in order to avoid leaving the assembly in an invalid state. The problem is that I don't know how to restart the customization without telling the user to close and reopen the document. I tried to dispose and re-create all global objects I created in the assembly, but it doesn't help, because Word still doesn't "know" it should purge the assembly's stack. Obviously, Word internally wraps all customization entry points (all calls to event handlers located i ...Show All

• Smart Device Development Gaming Engines

  I am looking for a gaming engine to run on windowsCE. Doesnt really matter if its a full gaming engine, it has an IDE, or it just a small collection of libraries. Just wondering if anyone had any ideas Really just want something to do nice graphical applications pretty much all 2D no other real constraints apart from that at the minute. Any Opinions Start with Gaming API - Info here http://msdn.microsoft.com/windowsmobile/reference/gaming/default.aspx Manav ...Show All

• SQL Server Conditional Send Mail Task

  Hi, I want send email if certain conditions are met (by send mail task)... if compnay records does not exists in some table (returns null)... not task failure.... how do I achieve this without using Script task   does any one have an idea about it,   regards In contiuation i would like to ask another question i.e. I want to send the results of my query (complete result sets) from email task How will I able to achieve the task. ur help will be appreciated ...Show All

• Visual C++ VS2005 SP1 and Microsoft.VC80.CRT in applocal mode

  We have a problem running some of our applications in "applocal" mode since we have upgraded to SP1. We use some external libraries (we don't have the source code) that were compiled with the original VS2005. The following manifest is therefore generated: < xml version='1.0' encoding='UTF-8' standalone='yes' > <assembly xmlns='urn:schemas-microsoft-com:asm.v1' manifestVersion='1.0'> <dependency> <dependentAssembly> <assemblyIdentity type='win32' name='Microsoft.VC80.CRT' version='8.0.50727.762' processorArchitecture='x86' publicKeyToken='1fc8b3b9a1e18e3b' /> </dependentAssembly> </dependency> <dependency> <dependentAssembly> <assemblyIdentity type='win3 ...Show All

• Windows Search Technologies WDS can't search IM, other email clients?

  Hi, After reading a review that WDS is the best tool for searching my harddrives, I decided to give it a spin. Installed. Ran the indexer with the options that mattered to me, all hard drive locations, and email. Tried the search after indexing completed. Simple terms turned up some files. Immediately noticed nothing from email. OK.. so WDS only works with Outlook What a drag, I don't use that software. I do have a very large IM chat history in My Documents->My Received Files. I tried a search for text in the IM logs. Nothing comes back from WDS So.. basically, this software out of the box is not returning much in terms of useful results. I moved My Documents to G:\ which is a different hard drive from the Windows XP C:\ default. Is ...Show All

• SQL Server format issue

  I've created a new calculate member in (SQL Server Business Intelligence Studio 2005) with the following format string: "#,#0.00". This measure is displayed like this: 22,250.22 Then I created a Measure in the Cube structure menue and used the same format string:"#,#0.00" and this measure is displayed like this:0,66 --> Comma and decimal point are changed in the display of the measures!!!! Can anyone help me with this I just like every measure to use a decimal point for the decimal place or the other way round. But I want every measure to be displayed in the same format! Thanks a lot! Right click on SSAS2005-server in management studio. Select properties. Select languages/collation. HTH Thomas ...Show All

• SQL Server Connecting to SQL Server 2005 Express using IIS 6.0

  Hello, I can connect to amachine using SQL server 2000 using IIS 6.0. However, I am having trouble connecting to my server that has SQL server express using IIS 6.0. I'm using similar setting for both servers. Is there something else i have to do for SQL server express I'm not sure why this is the case. Any information that could help resolve this failed connection would be greatly appreciated. Thank you. Burhan I would make sure that the remote connections have been enabled on the server, by default this is turned off. How to configure SQL Server 2005 to allow remote conections http://support.microsoft.com/default.aspx scid=kb;EN-US;914277 ...Show All

• Visual C++ How do I print out transfer file progress in console application?

  Hi, I am trying to make a console application that download / transfer file, and I want to show the transfer progress (bytes received), but every time I use cout << bytereceived << endl; I actually made a new line. can someone help me to "rewrite" the number that has been shown in the console Thank you. Nope, that's the whole point. Using a \n will move the cursor to the next line. If you use only \r the cursor goes to the begining of the current line enabling you to write on the same line. ...Show All

• Visual FoxPro VFPOLEDB - Repeating 512 characters in Memo field

  I am working with developers who are trying to populate a VFP DBF memo field with text held in an SQL VARCHAR(4000) field. When run, the code populates the DBF memo field with the correct number of characters but when you check the content of the memo field it contains nothing but the first 512 characters of the VARCHAR field repeated over and over again. We've upgraded to the most recent version of OLE driver but the issue still occurs. The strange thing is that on the development machine the issue does not exist, even with fields using the full 4000 characters in the SQL DB, but we can not identify where the difference in configuration is! Could it be a buffer setting I need to define in the registry Can anyone help ...Show All

• Internet Explorer Development Help me Uninstall Old IE7 Beta 2 to install RC1 !!

  When I try to uninstall IE 7 Beta 2, I get an error that I can't uninstall due to a file I don't have. Now, I can't uninstall at all! Please help me!!! For support on IE7 please see the support page at http://www.microsoft.com/windows/ie/support/default.mspx http://www.ie-vista.com/known_issues.html also has excellent resources. Thanks -Dave ...Show All

• Visual Studio Team System Creating an OLTP datasource for writing reports

  As suggested on: http://msdn2.microsoft.com/en-US/library/ms159161(SQL.90).aspx I created a new data source which I have called TfsOltpReportDS and which uses the Microsoft SQL Server connection type and the following connection string: data source="(local)";initial catalog=MyProject However I have login problems. If I enter the user and password which is used for TfsReportDS then I get failed login errors when I click Apply the first time or Generate Model . If I select the option " Credentials supplied by the user running the report " to diagnose this and try to generate a model I get this error: SQL Server Reporting Services Error Logon failed. (rsLogonFailed) Get Online Help Value does not fall within the expe ...Show All

• .NET Development How to get timezone given an airport code?

  Hi, I am developing a scheduler that will allow user to input a date and time (local) and the system should automatically calculate the remote location's date and time according to different timezone for a particular area (using airport code). For example: User input --> 13-Jan-2007 15:30:00 (Singapore time) Remote destination --> Thailand (-1 hour from Singapore time) --> 13-Jan-2007 14:30:00 (Thailand time) Can anyone tell me if there is a way to achieve this in C# (ASP.NET) without consuming web service Thanks and regards, Keith. The simpler solution is to do like the windows clock : add in a combobox the 26 different time zone ( -12 to +13), cities for the text attribut and the +/- hour in t ...Show All

• Visual Basic Closing a form

  How can I tell whether a form is being closed because the user clicked the X in the form control box vs. code that performs me.close(). The two methods give me different results and I'd like to know if the X was clicked so that I can handle that specifically. Thanks, /jerry I agree with Richard_Wolf here, this is probably the only way really.   so you have a global variable on the form:   Private IsUserClosing as Boolean = false   then in code, whereever you are doing Me.Close(), a line before this, do:   Me.IsUserClosing = true   then check that value when you are closing the form or whatever, using the Form_Closing event ...Show All

• Windows Forms Data Sources window is always blank.

  I had SQL server 2000 on my PC that has a windows 2000 OS. I installed visual studio 2005. Now when i want to add a data source to my project, I go to Data-> Add new data source. However when i have a form opened in the IDE, the data sources window is always blank. If i open the dataset designer i see all the data sources for my project in the data sources window. Does anyone know why is the data sources window always blank, other than when i have the dataset designer opened. Hi Peter, Thanks for your reply. I read through your blogs. It appears that the UDP port 1434 migiht be blocked by the Firewall. I ran the server and client network utility of the MSDE (sp4) and all it has in enab ...Show All