• SQL Server Data Files

    I have a production server with 10 databases, is it good practice to put all the log files for all 10 databases on one RAID 5?

    Rick Martinez585 pointsBadges:
  • Will you be at Interop Las Vegas next week?

    Grab lunch or a coffee with editor Michael Morisy to discuss what you think of the keynotes, sessions, and vendor announcements at Interop next week. Get some sweet IT Knowledge Exchange swag and let us know what you're thinking of the show and the direction of networking in general! Let him know...

    ITKE351,965 pointsBadges:
  • Open IT Forum: Share networking resources, earn knowledge points!

    It's Networking month at IT Knowledge Exchange, and we're looking for your best resources on the subject. Share networking guides, blogs, tips, books, and great Twitter pros to follow! For each category you contribute to, we'll give you 25 knowledge points, good toward our latest contest.

    MelanieYarbrough6,345 pointsBadges:
  • Dynamic SQL query

    Hi! I'm making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let's say is...in a form the user can search for records thru...

    Ayisha5 pointsBadges:
  • Frequency of witness pings to partners

    Does anyone know how often the witness instance pings the partners? I am aware of the timeout setting but want to know exactly how often the ping is initiated. Is it the same or different from the timeout value. Thanks in advance for your reply.

    BitBangerDBA5 pointsBadges:
  • Spring Cleaning: Free IT Book(s) Giveaway!

    This week's IT book giveaway is a little bit different: 1. Answer two of the five questions listed below. Link to your answer in the discussion area of this question. 2. Ask five questions between May 2 and May 8. Link to your questions in the discussion area of this question. 3. Approve three...

    MelanieYarbrough6,345 pointsBadges:
  • Receiving a Binary file

    I have a vendor who is placing a files on a FTP Server in Binary.  I need to retrieve those files and place them into an iSeries database file. Is there away to retrieve the file straight from the FTP Server into the database file using GET that will translate from binary to mixed text and packed...

    AS400PCFileTransfer16115 pointsBadges:
  • sql statement…..

    Can someone take a look at this code and please tell me what i am doing wrong? SQL> INSERT INTO "CDAAS"."INFORMATION"   2  VALUES ('MBedfo','Maurice','Bedford','Maurice Bedford','','','02/02/1990','1234','','',''); VALUES ('MBedfo','Maurice','Bedford','Maurice...

    Wdoss5 pointsBadges:
  • How can I create reference key of non-unique column in SQL server 2008

    how i create refrence key of non-unique column in sql server 2008?

    V4apr5 pointsBadges:
  • SQL statement needed to remove characters

    I have data in one of my columns in a table that I would like to remove via a SQL update statement.  In all cases, the data that I want to remove is the same 3 characters at the end of the varchar field.   How would I structure the SQL statement?

    Satonthehill5 pointsBadges:
  • Oracle 10g to SQL Server 2008

    Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under 1 scheme we have...

    Cholan5 pointsBadges:
  • Journaling on i5 when updating from .net

    We need to update some i5 files (under v6r1) from SQL in a .NET environment. Can I control this process via SQL or will I need to call CL commands from .NET to start/stop journaling & commitment control?

    ZIS5 pointsBadges:
  • Save high volume xml transactions to db

    I'm not a DB developer, I know basic select statements but that's about it. We have a high volume xml web service that takes roughly 200K transactions per day. Each transaction request has a corresponding response so that's about 400k transactional xmls per day to save. Each request xml is anywhere...

    GreenJello15 pointsBadges:
  • unable to create a connection to DB from SQL developer

    Hi, I was using SQL developer since 2 years, suddenly lost all the existing connections.Tried creating new connections, provided all mandatory fields and clicked "Test", it was success. But when tried connecting, no response. Also tried importing the connections, but throwing...

    Abc130 pointsBadges:
  • Desktop Virtualization: SAN boot infrastructures

    Does it make sense to SAN boot infrastructure servers like Citrix DDC, PVS , Xenapp, SQL servers, Hypervisor Host in a VDI environment?

    abbis65 pointsBadges:
  • 10 Chances to Win $100

    Starting today (April 25th) and running through May 31st, you have 10 chances to win a $100 Amazon.com gift card. The 10 IT Knowledge Exchange members with the most Knowledge Points earned between today and May 31st will win. Learn how to earn points in the Community Blog, or start answering...

    ITKE351,965 pointsBadges:
  • SQL equivalent of GRTOBJAUT using Authorization List

    Using SQL script, how does one grant object authority to a table using an authorization list?   This fails because MyAutList is not a *USRPRF:  grant all on table mylib.mytable to MyAutList This works, but is not what I need: grant all on table mylib.mytable to Public 

    DavidGar15 pointsBadges:
  • Stop one database in a SQL 2005 environment

    If there are multiple databases ever one unique SQL2005, how can I stop only one of them?

    MoroExpert5 pointsBadges:
  • How do I connect SQL Server 2005(mobile edition) to Visual Studio 2005?

    How do I connect SQL Server 2005(mobile edition) to Visual Studio 2005? I tried the connection but the database is not found on the server.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrive The Images From Database using Vb.Net

    how Storing AND Retrieving Images in Sql Server using vb.net

    AnandKanade5 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