• Recursion in Visual Studio 2010

    I'm running Microsoft Visual Studio 2010 Professional on a Windows 7 laptop and trying to learn C#. I'm working on recursion and want to prompt the user to enter a specific word into a console application and then use a recusive method to print each character of the user-supplied word on a separate...

    QMac10 pointsBadges:
  • SQL Server 2008 tables

    I  have 2 tables, tanle1 and table2 Can someone help for  SQL query  for table3 with 2 colums colum 1  is select number from table1 for colum2 in table3  I need to get the total number of times  each number in colum1 of table1 apears in in colums n1,n2,n3,n4 of all events in table2 as shown...

    Ajibola110 pointsBadges:
  • Performance and Resource Consuming Monitors SQL Server 2008 R2

    Are there any specific GUI tools available to monitor the performance and resource consuming process? At present we are using third party tool to do so (Spot light)?

    ITKE346,400 pointsBadges:
  • Cost to Upgrade to SQL Server 2008 R2

    How much will it cost to upgrade from SQL 2005 to the 2008 R2?

    ITKE346,400 pointsBadges:
  • Select/Insert Statements causing out of memory error run under VB Script

    I'm using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error.  As far as the Select...

    TheBandit15 pointsBadges:
  • Earn 250 Knowledge Points now by tweeting out our contest

    We've recently added 250 Knowledge Points to the following profiles for tweeting out our Google Nexus One Challenge: JaideepkhandujaOwenAmbroseCarlosdlRyan8613MarkK Tweet out our Google Nexus One Challenge now and you can also earn the 250 Knowledge Point bonus. Remember that you don't have to be...

    JennyMack4,280 pointsBadges:
  • SQL command question

    I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don't know...

    Ktoby55 pointsBadges:
  • iSeries SQL ISNULL Equivalent

    What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?

    Jaggerdude60 pointsBadges:
  • Can I transfer a SQL license/install to a new server

    We are in the process of upgrading on of our db applications to a new version. This version will require a replication server, meaning we will need a SQL server. Ether 2003 or 2008.  We will need to have a full working test environment before rolling out live with it. Can we transfer our "test"...

    swinehart68031,050 pointsBadges:
  • VIEW_TABLE_USAGE SQL 2005

    In MS SQL 2005, when I select * from VIEW_TABLE_USAGE, I get incomplete results. At least one object that is used in at least one of the views is not listed. View "PTP__MARA_MARC" uses two tables and one view, but VIEW_TABLE_USAGE only lists one table and one view.  Can you please help?

    44444Dave5 pointsBadges:
  • Upgrading for database structure

    hello everyone  Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data "data loss is not accepted here". I have a complex DB structure in my application which depends "in some...

    Mshafie70 pointsBadges:
  • Where does the WPHOST file get stored in our Novell server?

    Where does the WPHOST.db file gets stored .Does it get stored in our local disc.If yes then where.And where is the novell address book gets stored it gets stored in our local disc or is present at the server side

    Sanchaita15 pointsBadges:
  • SQL and Dates

    Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||'/'||SUBSTR(BMDTOR,7,2)||'/'||SUBSTR(BMDTOR,3,2)))/30 AGE,...

    jschultz385 pointsBadges:
  • Application Upgrade and Data migration

    Hello Sir/Mam We have a web application that has an intensive usage of Database operations. This application of course has some sort of sophisticated Database (tables, indexes, ...)  structure according to Database engine used.  My question now is , what is the best practice to migrate old...

    Mshafie70 pointsBadges:
  • Crystal Reports 8.5 iMIS 10.6 database

    I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to...

    Mystic15 pointsBadges:
  • DBCCShrinkDatabase as Security Cleanup Measure?

    Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming...

    KansasCoder40 pointsBadges:
  • SQL Server project in VB 2005

    A form contain two text field (Name,Address) three buttons (Save,Modify,Delete). A test.mdf file in sql server. I want total source code of that sample project Pl help me about that. Thank you prit

    PRITH5 pointsBadges:
  • SQLCMD does not create a log file

    I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).

    Harv200250 pointsBadges:
  • Server Timeout on initial web connection to SQLServer

    We run a couple of websites (hosted on different webservers) that connect to an SQL Server. The data was recently moved to another SQL Server (called SQLCLUSTER) and now the first time the site is accessed, it takes over 20 seconds to bring up the page. If I don't set the Connection Timeout in the...

    Ajmo25 pointsBadges:
  • IT Knowledge Exchange’s iPad Contest Starts Today!

    Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or...

    MelanieYarbrough6,345 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