SQL 2005 Restore DB with Multiple files in Primary File group
Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee

Answer Question   |  December 2, 2007  8:58 PM
Database, Restore, SQL, SQL Server, SQL Server 2005

combine and sum fields in sql
I have a file with approx. 20 columns: 4 of the columns are numeric: finchg1, finchg2, finchg3, finchg4 – one of the columns is acct number. each acct has only one row. I need to combine the four fields into one – can I use the sum function to do this – how? Thank you

Answer Question   |  October 29, 2007  3:47 PM
SQL

Lotus notes to Sql
I have text files as attachments to emails in Notes Database and I would like to get the information from the attachment and store it in Sql database. Could any one suggest the best possible way to accomplish this I have set of data in the text file It goes like this // Name: Tom [...]

Answer Question   |  October 26, 2007  10:14 AM
Lotus Notes, SQL

Accountant
What software proficiency, would enhance my career. There are so many MS Certificates.

Answer Question   |  October 26, 2007  3:00 PM
Application development, SQL, VBA

Systems problem
I always wonder why this happened to my system…..a situation like this. I redesign my system since its predecessors made me a lot of headache. The previous months after it was been upgraded many complains in one particular problem. This is what the problem is……they notice that in no particular time there are data that [...]

Answer Question   |  December 2, 2007  3:11 AM
SQL, SQL Server, VB

SQL Packages
I have a query on SQL packages.Is it necessary to create an SQL package every time we connect to a remote system?Is there any other alternative?

Answer Question   |  February 21, 2008  6:50 AM
SQL

Inserting multiple rows in Oracle 10g
I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific [...]

Answer Question   |  October 18, 2007  4:10 PM
INSERT statement, Oracle, SQL

Delete all data in the database
Good day! Currently I am using MS SQL Server 2000. I wish to delete all data in the database table except data in login table and security table. Furthermore, TRUNCATE is done on stand-alone and child tables, else DELETE if table has any foreign key references (normally refer to parent tables): Is there any suggested [...]

Answer Question   |  October 24, 2007  4:23 PM
SQL

Database Admin…
Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did… nor did I. [...]

Answer Question   |  December 20, 2007  3:37 PM
DBA, naming conventions, Performance/Tuning, Relation Database, Security, SQL

sql server 2000
i am learnin sql server 2000 by ownself tell me the wright way how i can learn after this i shall go for oracle

Answer Question   |  May 23, 2008  11:37 AM
SQL, SQL Server 2000

my question
How to find the repeating charactar or letter in a string like ‘information’ in pl/sql or sql .

Answer Question   |  September 22, 2008  4:35 PM
Parsing, PL/SQL, SQL

SQL Server Schema Best Practices
I am in the process of establishing a “sandbox” database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 [...]

Answer Question   |  February 22, 2008  3:01 PM
SQL, SQL Server

Where is the best site to learn SQL?
Where is the best site(s) to learn SQL? A place with example coding etc…

Answer Question   |  September 26, 2007  2:27 PM
SQL

sql
display the third and seventh employee salary details

Answer Question   |  September 26, 2007  4:22 AM
SQL

programming using c#,winforms and visual studio.
i cant think of what to write in this part of the code so that the password character is ” * ” when the user enters his/her password.pliz help private void txtPassword_TextChanged(object sender, EventArgs e) { char Password =GetStyle (“*”); txtPassword.Focus(); } i just have no idea what to write so that this particular code [...]

Answer Question   |  October 24, 2007  7:29 AM
ASP, ASP.NET, C, ColdFusion, DataCenter, Dreamweaver, HTML, J#, J2EE, Java, JavaScript, JSP, Macromedia Flash, Photoshop, Programming Languages, SQL, VB.NET, VBScript, Visual Basic, Web development tools, Web site design & management, XML

Save and Read a text file from oracle database
Hi, I want to save a text file into oracle database (i.e. relational table) and also read it from relational table. Can you please tell me the best approach to do this. Thanks

Answer Question   |  July 28, 2007  9:27 AM
SQL

Migration Problem
I am migrating an Oracle 9i database to a new Oracle 9i database. My problem is that migration of two tables is taking very long. one takes 8 hours and the other takes 4 hours. The reason i can think of is that these two table have clob fields which are being migrated as varchar2 [...]

Answer Question   |  July 25, 2007  8:50 PM
SQL

SQL 2000 to Yukon Migration
We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for [...]

Answer Question   |  February 22, 2008  8:02 AM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

C#.Net
Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend? Please forward on [...]

Answer Question   |  March 10, 2008  3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools

Updating a table with sub query
Hi, I need to update a table with a sub query. Here are the steps I’m following but I’m struggling to successfully update the table. the performance of this update has to be good because of the number of rows I’ll be updating in production. any ideas? thanks in advance. drop table dummy_test create table [...]

Answer Question   |  June 28, 2007  4:02 AM
SQL