• How to configure the database instance to respond slowly for any request?

    With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can...

    Saimadhu455 pointsBadges:
  • Finding which columns contain data in a table

    I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table 1 has Columns Col1, Col2, Col4 being...

    TedGiles5 pointsBadges:
  • How to test whether the Database tables designed to avoid deadlock occurence?

    I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do?...

    Saimadhu455 pointsBadges:
  • Transfering SQL files from location to colo

    What is the fastest way to get the SQL database files transfered over? i.e. zip the files

    Phatboy81225 pointsBadges:
  • Users in a data base

    How many users concurrents does the database SQL support???

    Users5 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Finding the 3rd highest in the table using SQL.

    The table name is 'Employee' with the columns Empname Sal Age A 8000 25 B 7000 24 C 6000 26 D 9000 25 what is the syntax used to find the 3rd highest. I have tried with all the syntax but no gain. I have searched in w3schools.com but was not able to find the right answer. Kindly help.... Reks

    19757910 pointsBadges:
  • How to push the Database into deadlock state?

    Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Database SQL

    During the copy paste the old data (*.MDF and *.Ldf) with current data same files. When going to open database showing error like " server: msg 945,level 14,state 2 database 'vimalind'cannot be opened becouse some of the files could not be activated." How can rectify this... Pls tell me ..

    SAP Cum IT35 pointsBadges:
  • I want to retrieve always the first record via sql

    I want to retrieve always the first record of a group of records i.e. a history of sold articles, I want to see the date of every first sold article

    Fra90820 pointsBadges:
  • Two programs with separate SQL Databases

    I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?

    Cstanley25 pointsBadges:
  • Limit admin access to a single database SQL2005

    I want to set up an account similar to sa but limit the rights to a particular db.

    Cybx10 pointsBadges:
  • Updating values in a table in a SQL database

    I have a SQL database with a table. I need to insert a new record into that table if there is no entry for a particular column that day, or I need to update the record if that new record already exists. I am using a count column in the table to accomplish this, and if the count is null, I am...

    SQL Server Ask the Experts2,585 pointsBadges:
  • indexes on a large table

    hello, i got a 5milion rows on a single table, my database is sql2005 and my select is : SELECT top * FROM tbl1 WHERE ip_from <= 3515134258 and ip_to >= 3515134258 the 3515134258 is on a sample but the format is similar: SELECT top 1 * FROM tbl1 WHERE ip_from <= [value] and ip_to >=...

    Bbbttt15 pointsBadges:
  • Writing a stored procedure to insert an ASP.net file into a SQL database

    I need to write a stored procedure to insert into a SQL database the contents of a file that has been in read in ASP.net. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting to a remote DB on a UNIX server with SQL

    I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr * C Eval...

    AS400 - Ask the Expert485 pointsBadges:
  • Displaying the COUNT in a SQL database

    I have the following information available from my SQL database: Incident Type COUNT ADHOCREPAIR 13 CONSEXCHANGE 7094 ENTERPRISE 21189 FONECARE 38996 FONECAREEXCHANGE 6280 FONECAREPRIORITY 1251 POSTALEXCHANGE 929 POSTALREPAIR 4575 RETOUT 1 I also have the specification that ADHOCREPAIR CONSEXCHANGE...

    SQL Server Ask the Experts2,585 pointsBadges:
  • List,Save and FTP list of all databases

    How do I run a job to list all SQL databases on a server, save the output and then FTP the output file to another server?

    Mistp00120 pointsBadges:
  • MIgration to 64-bit Sql Server

    What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

    Tomfitzrugger5 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    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