• In DB2 when a select statement is executed, it is taking lot of time and the table is being locked.

    In DB2 when I'm giving a select statement its taking lot of time, the reason is like the table is a very huge table. As a result some times it is locking the table. Can any one help me for executing the select query with any option which would not lock the table. Thank you in advance.

    UmaGandreddi80 pointsBadges:
  • Changing the sql server service and agent windows account password

    Hello, we are considering changing the sql server service and agent's password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!

    Rob35 pointsBadges:
  • Exporting SSRS Report in Simple Excel sheet(not formatted)

    Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

    Avhilash5 pointsBadges:
  • SQL Server 2005 question self join query

    I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ------------ ----------- Book Commerce Commerce Accounting Science Math Commerce B.O. Material Pen Pen Link Pen Renolods I want ouput...

    Kotnimahesh5 pointsBadges:
  • SQL Server 2008: Difficulty setting mixed mode authentication password

    I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message, "The...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Encrypt the password in SQL 2000

    How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to...

    S09875 pointsBadges:
  • Estimate SQL Server tempdb space for a query

    Database - MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns retrieved 2. Join...

    BR5 pointsBadges:
  • unable to connect to SQL from Access

    I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

    Standaman15 pointsBadges:
  • Refresh/Run SQL

    We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?

    CrazyCoder5 pointsBadges:
  • SQL Server tables – What account created the object

    Is there a way to see who created or droped a table in sql server?

    Rick Martinez585 pointsBadges:
  • SQL Server: Index and Key

    What is the difference between a key and an index? Whe I issue a SELECT statement, and the table has an index, do I still have to use my key?

    bogeybetsy560 pointsBadges:
  • SQL select command

    Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price,...

    Abrahm7570 pointsBadges:
  • Memory overhead recommended for benchmarking SQL server 2005 on vSphere

    For a 'direct' physical to VM comparison of SQL server 2005, would anyone recommend giving the VM extra (say, 1.5GB) RAM to compensate for any overhead the OS needs? So a direct comparison would then be 1vCPU, 2.5GB RAM VM & SQL set to use 1GB RAM) vs. SQL on physical host set to use 1CPU and 1GB...

    SKrep5 pointsBadges:
  • SQL Server Profiler’s TextData Column Has NULL And Longest Duration value

    My Profiler's TextData Column Has NULL value and Longest Duration value (100000ms). What could be the reason? Thanks

    Jsql155 pointsBadges:
  • SQL Server Database Date Time Values

    I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 jan 1900. i want...

    RAYNISH35 pointsBadges:
  • Join Logical files and SQL views

    I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical files in...

    bogeybetsy560 pointsBadges:
  • SQL Error

    we need to determine error message:the condition applied to this collectioncontains an ORDER BY without a corresponding TOP clause.

    RaqT5 pointsBadges:
  • SQL Injection Validation

    HOW CAN I USE VALIDATION CODES IN ORDER TO AVOID SQL INJECTION IN MY WEB SERVER? I MEAN, EVERYBODY KNOW THAT HTML MODIFICATION IS VERY EASY, SO, DO I HAVE TO USE WEB SERVICES TO DO THIS OR GET ANOTHER APP?

    Underworld5 pointsBadges:
  • VB 6, SQL Server 2000 & Crystal Reports

    i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.

    RAYNISH35 pointsBadges:
  • sql server 2000 how can i make backup 4 file only and restore

    how can i make backup 4 file only and restore

    01058478505 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