• Execute a view/query is slower in SQL Server 2005 than 2000

    Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query "select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely...

    Db23290 pointsBadges:
  • combo box in dbgrid

    i want to drop combo box in dbgrid. how to do it?

    Sysmatics25 pointsBadges:
  • Extracting OLE objects attachments in Lotus Notes

    I've written an utility in VB .NET that is able to extract file attachments from a NotesDocument and this works fine. I'm having challenges now with a particular email that has a MS Word document embedded into the body, whose content is part of the body. So basicllay it's an OLE Embedded...

    Squig5 pointsBadges:
  • How to Sign Java Applets?

    HELLO. I want to run an applet made in java on a simple html page. The applet is made from a program which acceses the WebCam. That's why it needs to be signed before it can do that from the browser. DOES ANYONE KNOW AN EASY AND CLEAR WAY TO SIGN AN APPLET AND MAKE IT WORK ?

    Valy00175 pointsBadges:
  • Microsoft Word 2003 VBA Endnotes

    I have a report that I am creating in MS Word 2003 VBA. I need to place some text at the bottom of each section in a Footnote or Endnote. The report is not behaving and the Word Help is not helping, does anyone know a good site to explain how to use and give examples of using Endnotes and Footnotes?

    Flyght55 pointsBadges:
  • Microsoft Access: Hiding form fields with Null values

    Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark "x" and others do not. I need to be able to pull up someones name and see a summary of what they have "x"'s in. I created a Columnar form that has each name as a seperate sheet; listing...

    Wesleycrozier30 pointsBadges:
  • RPG ILE Character Hex Value to Decimal

    Hi, I have a flat file with hexidecimal characters after certain characters. For Example : "MY NAME IS BEN ~0A" The "0A" represents the hex for 10 (decimal) whitch means 10 spaces. My problem is when i have "0A" in a alpha numeric workfield (length 2), how can i use it as a hex value? In other...

    Oupablok20 pointsBadges:
  • Shim add-in not loaded VB runtime error

    i am kind of new on the hole shim add-in thing so go esay on me here what did on VS 2005 com shim wizard v 2.3.1.0 1) create shared add-in(new_addin) and put meesagebox on the on connect proc 2 ) add shim add-in project and chosed for word and excel 3 ) then add setup project add primery output for...

    Aqqa5 pointsBadges:
  • Microsoft Access database update question

    So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database it...

    Tgoody30 pointsBadges:
  • Empty project in Visual Studio 2008

    Can anyone tell me where the Empty Project is in Visual Studio. I am using C# express and there is this fold, but not in my 2008 Visual Studio

    Hlee200010 pointsBadges:
  • How you change a pointer from base class to derived class?

    Hello, I have the following classes class Rock { public: Rock() { goldAmount = rand() % 100 + 1; price = 10; }; int revealContent() { return goldAmount; }; virtual void checkPrice() { cout << price << endl; }; protected: int price; private: int goldAmount; }; class ValuableRock : public...

    CppStudent5 pointsBadges:
  • how to this into a code

    Colfax Industries wants an application that they can use to sum the sales made in four regions: North, South, East, and West. And the four sales amounts: 1000, 2000, 3000, 4000 with a loop.

    ChrisRob305 pointsBadges:
  • I want to read a pf and build a corresponding SQL statement and save the statemnet in text file.

    how can i read pf ?as pf is colomn speciffic have to read pf like it will have feilds and some constraint, key, record. how can i build a corresponding SQL statement ? i m new in AS/400 but i have to submit this utility to my manager this thursday.. can anybody help me in providing some code for...

    0 pointsBadges:
  • Altering Lotus Notes “Delivery Failure Report” using C#

    I am writing application in C#.Net 2.0 to read mails in Lotus Notes database and upload into another application. Emails can come to this mailbox from many sources. There are also other applications that send mails with FROM address as this mailbox while sending to other users\groups and in this...

    Sriramnatesan5 pointsBadges:
  • Crystal Reports 11 to create Body Mass Index chart (BMI)

    need to create Body Mass Index chart (BMI) for different ages for school children. I also need to have the short details of the BMI info at the left top area. I need to do this for a web site in ASP/VBScript 3.0. I am using Crystal Reports 11 and not sure whether I can do this in Crystal without...

    Stabs5 pointsBadges:
  • What is the biggest technical challenge in building a mobile client for a mission-critical enterprise application?

    What is the biggest technical challenge in building a mobile client for a mission-critical enterprise application? This question is sponsored by RIM.

    RIM30 pointsBadges:
  • miniSAP as a test environment

    Hi I am not a SAP developer rather a Java JEE developer. I wish to test Portal Factory (which uses the java JCo middelware product) to connect to a SAP R3 environment. Make calls to BAPIs etc. If I can get my hands on miniSAP will this suffice for a simple proof of concept. Ie connecting to SAP and...

    Jayhow15 pointsBadges:
  • Please help me to solve this Java Servlet

    Hi i solved the classloader problem now its working good but if v create two servlet container named sample1 and sample2 example: i have created two servlet container named sample1 and sample2 i had created same package name for both. In sample1, i created one servlet class with package name like...

    SKILLER5 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 pointsBadges:
  • web application

    hi, I want to develop a webapplication to integrate whole school system including principle, teachers, admin staff and parents, using the C# and sql server. can you guide me about the basic modules which i have to develop?

    70085 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following