• Error uploading records into a SQL Server table

    We have 700 hundred records, and we wish to upload them into a SQL Server table. After 600 have been uploaded, SQL Server failed to upload the last 100. Why might this have happened?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing large data files in SQL Server

    What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Investigating SQL Server 2005 memory issues

    We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we're seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Transposing a table using SQL Server Reporting Services in VB.NET

    How can I transpose a table using SQL Server Reporting Services in VB.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Server Performance online replication

    I have DB of 60 GB on SQL 2000 running on A/P Cluster. I want to do online replication. What would be the impact over Live server performance. Kindly Suggest.

    Natish10 pointsBadges:
  • Import SQL Server 2000 DTS package to new box

    Hi, I am building the new SQL 2000 SP3 server on Windows 2003 R2, in my old box there were alot of DTS package which is I need to import, my question is what account should I import it as to avoid the security right? in my old box I have 3 admin account only one own the DB whoever, DTS package were...

    Bjet55 pointsBadges:
  • Need SQL query

    I have two tables DETAIL and USER. Detail table have two columns (projectid and projectdetail). Projectid is a primary key in DETAIL table. USER table have two columns (projectid and Userid). User table is like more than one userid can be under each projectid, one user can access more than one...

    Minuvinu35 pointsBadges:
  • Adding an index on fields in a SQL Server table

    I have a massive customer table. The ID is the primary key and thus SQL Server makes a clustered index on that. There is no other index on the table. Can I add an index on fields like age, country and gender to make the results faster?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating tables on a SQL Server

    I am creating a directory of local businesses. I have found that my city is divided in to 4,816 business categories, which means I need that many tables in my database. Is there any way that I can create these table with a stored procedure, a SQL function, or a SQL script file? I want to use a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Decreasing the unused space of a SQL Server table

    How can I decrease the unused space of a SQL Server table which is indexed?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • Syncronizing between Distributor and Subscriber in Merge Replication

    HI everybody, i am using merge replication. my concept is that: a publisher publishes a file and then it synchronized with distributor in a schedule (publisher and distributor are in same server). Then Subscriber subscribes (Sync) from (with) distributor not publisher. I want distributor to act as...

    Jah5 pointsBadges:
  • Duplicating records in a table with a SQL query

    How can I duplicate every record in a table with a query in SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • COPY data between to files with SQL in iSeries

    hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don't have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i make the correspond...

    BUG68235 pointsBadges:
  • Concatenating two note fields into one, but need them to be on their own line

    sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?

    Macsterling5 pointsBadges:
  • Reporting Services 2000: Deployed results different from preview in Visual Studio

    I have 1 main report that contains lists. In each list are many subreports. The subreports are called multiple times based on the grouping in the list Problem: There is one particular subreports that shows the zero amount after deployment. However, the results are accurate when viewed in Visual...

    Droozy15 pointsBadges:
  • Differences between SQL Server 2005 and SQL Server Express

    How much does it cost to buy SQL Server 2005 Standard or Enterprise Edition, and how do they differ from SQL Server Express Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to check the existence of a Column in SQL Server 2000?

    - using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.

    Hunkgym5 pointsBadges:
  • How to process partitions (Full) in analysis services

    Hi, I have a cube which on a daily basis partitions will be created Partition names: shipment2008_12_31 shipment2009_01_01 shipment2009_01_02 shipment2009_01_03 shipment2009_01_04 .... . . . . I have to process the partition based on the day. If the day is 03 jan 09 the package has to process...

    GIG240 pointsBadges:
  • stored procedure component

    what is the difference between the way of using storedprocedure component in delphi5 and delphi7?

    VPL100 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