• Issues deleting records in SQL database

    I'm having issues deleting records in a SQL database. What should I do?

    rockquery5 pointsBadges:
  • How to Repair WSS_Content Database in SQL Server 2008?

    Hi, We have SharePoint foundation 2010 and we were getting error on backup so we did run DBCC CHECKDB and found some error. Looks like I found 0 allocation errors and 55 consistency errors in database 'WSS_Content'. Now I'm not sure what i need to do to repair. How do I repair? Any drawback? How...

    GregoryGood5 pointsBadges:
  • Performing SQL Join equivalent in MongoDB

    Does anyone know of a way to perform a SQL Join equivalent in MongoDB? This is what I have right now: comments { uid:12345, pid:444, comment="blah" } { uid:12345, pid:888, comment="asdf" } { uid:99999, pid:444, comment="qwer" } users { uid:12345, name:"john" } { uid:99999, name:"mia" } And I'm...

    ITKE355,500 pointsBadges:
  • How to export data from R to SQL Server quickly

    Is there a way I can export data from R to SQL Server quickly? The standard way (SQLSave) is really slow for a large amount of data. This is what I tried so far: toSQL = data.frame(...); sqlSave(channel,toSQL,tablename="Table1",rownames=FALSE,colnames=FALSE,safer=FALSE,fast=TRUE); Thank you!

    ITKE355,500 pointsBadges:
  • Best load testing software for VB 6 and SQL Server 2012

    What's the best load testing software for VB 6 and SQL Server 2012?

    Udayarajan5 pointsBadges:
  • Should I move my SQL database to NoSQL?

    I have a very large table (roughly 100 million rows and 35 columns) and it's currently stored in a SQL database. However, my queries are running very slow at the moment so I'm wondering if I should move to NoSQL. But I have a few questions: Which NoSQL database should I use? Is there a way to move...

    ITKE355,500 pointsBadges:
  • Users accessing SQL Server 2008 database

    how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .  

    Tablestructure15 pointsBadges:
  • Tool for migrating DTS to SSIS

    What is the tool for migrating DTS to SSIS. And how effective it works. And I want migrate 500 DTS packages to SSIS. How much time it will take?

    Lingala5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 pointsBadges:
  • SSRS Report Server security not working

    SSRS Report server security group is set up right on folders with all rights. But we are getting an Windows account error that says a specific Windows account lacks rights to create a data source. What could cause this?

    RickNPHX15 pointsBadges:
  • What’s the career lifetime for SQL Server, C#, ASP.NET and SharePoint?

    I want to know career and technology lifetime for SQL Server, C#, ASP.NET and SharePoint. Also, how is their growth compared to big data or SAP in the future? Please give your suggestion.

    vitalreddy5 pointsBadges:
  • SSRS Report Security

    Hi,I want to control who can view/run SSRS reports available based on following things?Company of the PersonDesignation of the PersonDepartment of the PersonRank of the PersonHow do I achieve that? Can somebody provide me step by step instructions or point me to right direction.I want ease of...

    Kalpeshpatel5 pointsBadges:
  • How to repair backup of .mdf file database?

    One of our clients gets the following error when trying to backup a database:quote:________________________________________System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during...

    jordan26henderson5 pointsBadges:
  • AS/400 file downloaded to Windows Server

    When downloading AS/400 data files to MS SQL server files, will the storage size be about the same on server as it was on AS/400? We have a 102 gb AS/400 database library we want to download to SQL Server.

    jm101515 pointsBadges:
  • Last modified DML opertations

    If I make any changes(Insert/Delete/Update) in a site then the corresponding changes will store in tables of that particular DB. How to know on which table which operation(DDl/DMl)has done. I would like to store DML activities on Database level in a table,not on particular table. Please help.

    SowjanyaS5 pointsBadges:
  • SQL 9010 Error when using RUNSQLSTM

    I have a CL program having the following RUNSQLSTM RUNSQLSTM  SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK)            COMMIT(*NONE)                            AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE...

    MaldaTabbah5 pointsBadges:
  • The IT Blog Top 10: Oct. 29, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...

    ITKE355,500 pointsBadges:
  • Connecting VB 2008 to SQL Server2005

    How to connect VB2008 with SQLServer2005 through coding. Not through OleDBAdaptar. Also Let me know the code for Add,Edit, Delete & Save in VB2008

    Ishita20095 pointsBadges:
  • How to view content damaged MS SQL Server database?

    Help! Dead computer and all the information. Computer to reinstall formatting (otherwise failed). With the help of programs to restore files managed to pull Fail SQL database (.mdf). But on the other computer does not accept the file. Writes an error. Already tried everything. How do I restore the...

    hanamor11005 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