• SQL SERVER Data Files and Threads

    I am reading a Microsoft Press Book MCTS Exam 70-432 and in chapter 2 it talks about Data Files and it says "SQL Server creates a thread for each file underneath a database. As you increase the number of files underneath a database, SQL Server creates more threads that can be used to read and write...

    Rick Martinez585 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    project plan with steps outlined

    Anflores5 pointsBadges:
  • Best tool for SQL Server 2000 – like golden is for oracle

    what db tools are there to query ms sqlserver 2000 database? i'm used to using benthic's golden for oracle databases - and would like a similar tool to use with sqlserver databases.

    Angeliamcdaniel5 pointsBadges:
  • Recursive Association with compound primary key in SQL database

    Hello, I'm afraid I'm very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a 'Lead Client' column to represent a recursive relationship where one attendee can be nominated to lead...

    Littlegreen15 pointsBadges:
  • How to transfer database from SQL Server 2008 to SQL Server 2005

    how to attach database of  sql 2008 into sql 2005

    Itready5 pointsBadges:
  • How to update data for one column in MS SQL?

    Hi, I have a table column named "Question" that stores the question without space.For example "Who are you" is stored as "whoareyou".Now I have modified the code to store the data with spaces in Question column.Problem is newly added data will be stored with space,but I want to change the already...

    Santhoshnk735 pointsBadges:
  • Delete all tables in SQL Server database?

    How to delete all tables of a database in SQL Server?

    Prcvjr220 pointsBadges:
  • How to find particular database in SQL stored procedures other than manually?

    Hi all, i have a Stored Procedure, i need to find the database in which the particular SP is available, i dont want to go through all the SP's........... Is there any way to find the database using server name, i need the query for this.. Please help me

    Sagi5 pointsBadges:
  • Question about SQL Server managament database upload

    how to upload sqlserver management studio database on online

  • Importing a “flat” field into a Lookup Table format in SQL database

        * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated...).     * I have created a table...

    Roguetexan5 pointsBadges:
  • SQL SERVER 2005 Database Options

    We have a database in production that is 500GB, what are the pros and cons for setting the "Page Verify" option to "NONE" on the database for best performance? How will "TORN_PAGE_DETECTION" and "CHECKSUM" affect performance?

    Rick Martinez585 pointsBadges:
  • Business Objects XI Enterprise – Repository License

    What are the BOE license requirements (if any) for the BOE repositiory (System & Audit repository) if it is located on a separate server that the BOE server? (Note: The server is licensed appropriately as a MS SQL database.)  

    LifeWay10 pointsBadges:
  • Production SQL Database has been restored with Old database backup

    Dear Expert, I need your Advice, today in morning i run Symantec backup restore on SQL 2008 server where i overwrite the production Database with Old backup. Is there any way i can retreive the old Database until yesterday. i dnt have any backup of New database which i accidentally overwritten.  ...

    Aleem60015 pointsBadges:
  • SQL Server 2005 database design

    What is 1*,o* 1..1,1..*,0..*,1..* in databse design,i have no exact idea about this,need help. 

    Shamu75 pointsBadges:
  • When creating a web application in Sharepoint 2007, where is the data stored?

    hello guys :) when I create a web application on sharepoint 2007...where does t he data and documents that am uploading be saved?? in that path that I have set ?? or on SQL Server that I have installed on C: drive thank u in advance

    IT19875 pointsBadges:
  • Prophet 21 Database Dictionary

    Is there a data dictionary for the prophet 21 database? I am looking to create applications that use data stored by prophet 21 software. Is there available software to interface with prophet 21 data?

    Carlosburkle5 pointsBadges:
  • Indexing in Microsoft SQL

    What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

    TeachMeIT975 pointsBadges:
  • SQL Work Files

    In the FOCUS programming language, you can retrieve data and hold that data for further processing at some point later in the program.  What is the best technique for doing this in SQL?

    Rhansard5 pointsBadges:
  • How does exchange 2010 email archiving work?

    How does exchange 2010 email archiving work? Imean techincally speaking, does it stub? What do the users see, what is on the backend, a SQL database? I can't find any articles on how exchange server 2010 email archiving works under the hood?

    Tuck15 pointsBadges:
  • Importing large sets of Excel 2000 data to SQL database

    I have large data sets of over 5 million customers in several excel 2000 worksheets. I would like to import the data to a SQL database and preserve all data including notes fields which are huge and contain all types of characters. What is the best method of achieving this?

    ITKE344,825 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