• Select into vs Insert into in SQL Server

    Hi experts, What is better between Select into vs Insert into in SQL Server when it comes to performance? thx

    DBM10 pointsBadges:
  • Network Connection Freezes

    For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the...

    DboiSOBE0 pointsBadges:
  • Updating database index

    when i create a table with nearly 100 rows, database index gets update to accomodate those 100 rows. Can i find out the time taken by the index to get updated from previous state to a state to accomodate those 100 rows?

    Ravikanthtodeti5 pointsBadges:
  • High Disk usage on SQL Server 2005

    We recently upgraded our application from version 3.1 to 3.5. We had run the latest schema and other DB changes on the existing 3.1 Database. This is how we upgrade to higher versions. Now the problem is, after the upgrade, the disk usage has gone very high. What are the possible reasons for high...

    Jsql155 pointsBadges:
  • Call Stored Procedure Multiple times

    I want to use a SQL script that takes values from one table and then calls a stored procedure multiple times for each of those values. Each time, I am passing in those values as a parameter for each stored procedure call. How can I do that?

    Kyoseix5 pointsBadges:
  • Help navigating SQL Server 2008 database?

    Hi all, I'm facing an interesting challenge... Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I can get my...

    Palloquin95 pointsBadges:
  • What are the query optimization techniques used in SQL 2000?

    What are the query optimization techniques used in SQL?

    Gomsbk35 pointsBadges:
  • Answer a Question, Win The Official Ubuntu Server Book!

    At the beginning of the month, we gave away The Official ubuntu Book, and now we're giving away The Official ubuntu Server Book, Second Ed.! The book includes a DVD that contains the versions of Ubuntu Server needed for different CPU architectures. You also receive a code for a free online version...

    MelanieYarbrough6,345 pointsBadges:
  • Prophet 21 Database Dictionary

    Is there a data dictionary for the prophet 21 database? I am looking to create applications that use data stored by prophet 21 software. Is there available software to interface with prophet 21 data?

    Carlosburkle5 pointsBadges:
  • Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs

    Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

    SQL2K8Dude5 pointsBadges:
  • SQL Server 2008 Restore error message

    I get this error when trying to restore a 30 mg database "Callback:SQL Server 2008: Out of memory on restore" and then get the error ""There is insufficient system memory in resource pool ‘internal’" Anyone have any ideas?

    Kmmc1122334455665 pointsBadges:
  • server temporary freezing

    I have Dell poweredge 700 with Dell CERC SATA 1.5/6ch Raid controller card in RAID 5 I have about 20-30 stations connected to it at any moment. The disk queue is small below 1 from time to time people will experience desconnection problems such as i will try to access file and server will stop...

    Dimchik0 pointsBadges:
  • Indexing in Microsoft SQL

    What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

    TeachMeIT975 pointsBadges:
  • SQL Server 2005 maintenance plans

    I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?

    TeachMeIT975 pointsBadges:
  • Kerberos unconstrained delegation for MS SQL svc account

    Can an MS SQL service account run non-SQL services if "trust this user for delegation to any service (Kerberos only) has been enabled?

    Calicdaj5 pointsBadges:
  • Crystal Reports XI – SQL table fields that fail all compare tests

    I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as... if {mytable.mystring} = "test value" then 1 else 2 This is what happens during execution...  when the the preceding test is true, Crystal returns a...

    BTod45 pointsBadges:
  • Error Message when restoring a SQL server DB in SQL Server Express 2008 R2

    This error received and cannot determine resolution: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240MB per database. The DB.bak file is 1.67MB

    Trackster209515 pointsBadges:
  • dba deleting data

    Is part of a DBA's job to delete production data using SQL scripts?

    Biker015 pointsBadges:
  • SQL Work Files

    In the FOCUS programming language, you can retrieve data and hold that data for further processing at some point later in the program.  What is the best technique for doing this in SQL?

    Rhansard5 pointsBadges:
  • Receiving result sets in RPG (prior to release 7.1) from an SQL SP

    I have read through the IBM manual "Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries" for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this...

    MapleLeafDeveloper5 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