• When does SQL performance start being affected by the size?

    When does SQL performance start being affected by the size?  We are running SQL 2005 64bit on Windows 2003 Enterprise 64 bit server.  The database is over 1 tb.  When does MS SQL start to degrade with database size? 

    Mcappy5 pointsBadges:
  • Data archiving to additional server

    We have two identical SQL Server 2005 databases. We need to archive data to another server over a network. What would be the best way to accomplish this? This is primarily required because data needs to be archived for at least five years. We don’t need the archive server for backup purposes,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating DTS packages that use mainframes source to SSIS

    I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

    Jwalini5 pointsBadges:
  • Multithreading T_SQL

    I have to pool data from 1000+ sites on different physical servers through a web service running on each server. What is the best way to do so using T-SQL so that the multiple threads/processes run in parallel

    Rajeevraina5 pointsBadges:
  • Permission to Export SQL Server 2005

    On SQL Server 2005, what is the minimum permission needed to allow a user to export tables from one database server to another server? Permission on SOURCE=? Permission on DESTINATION=?

    VelameLaCosa110 pointsBadges:
  • SQL 2005 transaction logs

    At what point should we truncate the transaction log

    Hydrostani20 pointsBadges:
  • Oracle 10g versus Microsoft SQL Server 2008

    Require comparison between Microsoft SQL 2008 enterprise edition versus oracle 10g standard edition.

    Akansha150 pointsBadges:
  • Retrieving data tables without backup SQL

    If I truncate a table without the backup of it, how do I retrieve the table data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server user name issue

    We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. - aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating a stored procedure in SQL

    I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • View a concise list of all Job Schedules SQL Server 2000

    I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can't be sure. The number jobs I have makes this an onerous task. Is there a way to query the...

    Cyphersimian30 pointsBadges:
  • Conducting a performancee baseline comparison

    I was reading this 2-part article on performance baselines. I would like to know how someone actually performs the comparison between the performance on the system with the baseline? How do you use SQL Server Profiler and PerfMon to do the comparison?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Reporting services

    I am trying to add a field that has different values.I need to add them to get a total number .Example: Lesson num field contains value 1245,3467,6754,9987,4089 I need to add them to get a total of 5.

    Hydrostani20 pointsBadges:
  • MS Access query to show records that contain dates that differ by 1 year

    I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a time. To create a datediff function for all...

    SerenityNow365 pointsBadges:
  • ORA-06550: line 224, column 7: error running in SQLPLUS

    Im getting the following error when running the code below: SQL> @n377d_load_tfdscpm_sxb.sql       exception       * ERROR at line 224: ORA-06550: line 224, column 7: PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following: begin case declare end exit for goto...

    Catch9315 pointsBadges:
  • Alternatives to cursors in SQL Server

    What are the alternatives to cursors? I can’t find any other method to move through record sets one at a time.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Issues with multiple DBs on one SQL Server instance?

    We have multiple SQL Server instances running on different servers in our organization, each requiring maintenance and backup. We have a vendor backing up these instances that charges on a per instance basis. I am doing a review to see if I can bring all those SQL Server DBs onto just one instance...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to compare fingerprint images in VB.NET

    i am working on FINGERPRINT RECOGNITION SYSTEM, i am using vb.net as front end and sql server 2000 as back end, i had saved fingerprint images in sql server using image datatype, now i need suggestion how to compare fingerprint images.

    Dlfshweta5 pointsBadges:
  • DR/HA questions with SQL Server design

    Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • DB mirroring with SQL Server 2005: Standard vs. Enterprise

    On the subject of database mirroring in SQL Server 2005… Besides snapshot access and high safety mode having to be on, as well as the redo thread count, are there any other limitations placed on mirroring, utilizing Standard edition vs. Enterprise edition? I was under the assumption that to allow...

    SQL Server Ask the Experts2,585 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