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?

Answer Question   |  October 28, 2010  3:08 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

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.)  

Answer Question   |  October 14, 2010  2:00 PM
Business Intelligence, Business Objects, Business Objects Enterprise 12, SQL Database, SQL Server licensing

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.   Please help me

Answer Question   |  September 27, 2010  4:33 PM
Exchange, SQL, SQL 2008, SQL Database, SQL Server 2008, Symantec, Symantec Backup Exec

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. 

Answer Question   |  September 14, 2010  3:57 AM
Database design, SQL 2005, SQL 2005 Database design, SQL Database, SQL Server, SQL Server 2005

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

Answer Question   |  September 11, 2010  7:29 AM
Data storage, Data storage management, SharePoint 2007, SharePoint Server, SharePoint Server 2007, SQL Database

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?

Answer Question   |  August 27, 2010  2:20 PM
Application software, Data Dictionary, Database, Prophet 21, SQL, SQL Database

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?

Answer Question   |  August 26, 2010  12:23 PM
DB2 SQL, Focus, Programming Languages, SQL, SQL Database, SQL Server, Work Files

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?

Answer Question   |  August 25, 2010  9:18 PM
Exchange 2010, Exchange 2010 Administration, Exchange 2010 Archiving, Exchange Back-End Servers, SQL Database

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?

Answer Question   |  August 27, 2010  8:08 PM
Database design, SQL, SQL Database, sql indexes, SQL Server 2005, SQL Server 2005 index strategy

ASP Web page database?
I want to do a web page with ASP.NET I already make another one using Access as my database manager but now is a bigger project so I want to know what can I use for create the database or if it’s good still with access. (I Know basically  ”everything” is SQL but please give [...]

Answer Question   |  August 18, 2010  5:17 PM
ASP.NET, ASP.NET Web applications, SQL Access, SQL Database, SQL Developer

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?

Answer Question   |  August 18, 2010  8:08 PM
Data migration, Excel 2000, Excel Database, Excel worksheets, SQL Database, SQL migration

Transactional Replication: Publisher & Subscriber size mismatch
Hello, We have implemented transactional Replication[Push] on our SQL Server 2005 DB. The Distributor is the Publisher. The publisher is on one server and the subscriber on another. After synchronizing the DB, the tables count and the no of recs per table are identical on both the servers, however the actucal db size on the hard [...]

Answer Question   |  August 5, 2010  12:26 PM
Hard drive space, SQL 2005, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

How to display values in one table by referring and checking values in another table?
how to display values in one table by refering and checking values in another table

Answer Question   |  July 28, 2010  8:08 AM
SQL Database, SQL Server, SQL Server database, SQL Server tables, SQL tables

Change the size of a column and then reorganize the rows in SQL tables
I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     ”PHOTO”        VARCHAR2(25 BYTE) NOT NULL ENABLE,     ”NUM_LINE”   NUMBER(20,0) NOT NULL ENABLE,     ”PHOTO_LINE”  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE PHOTO_DETAIL   (     ”PHOTO”   [...]

Answer Question   |  August 2, 2010  12:13 PM
INSERT SELECT statement, INSERT statement, SQL Database, SQL Server, SQL tables

How do I restore my SQL .bak file over the existing database?
How do I restore my SQL .bak file over the existing database? Do I need to delete what is there already? On a new Windows installation I need to restore our production SQL database from a .bak file. What steps do I need to take? Can I overwrite data or do I need to restore [...]

Answer Question   |  July 14, 2010  5:31 PM
.bak file, Data management and storage, SQL Database, Windows installation

SQL Server 2008 query To Find Columns with incorrect information
This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                    50             SMITH AB 2                          Jones                     45             Leeds 3                          Patel                      38             PATEL AR What someone has done is put in the wrong data in town name and instead used details that we put in a different field. What i [...]

Answer Question   |  July 1, 2010  11:09 AM
SQL Data Set, SQL Database, SQL Query, SQL Server 2008

How can I write a SQL query to get the database name ?
How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

Answer Question   |  June 30, 2010  11:35 AM
Database name, SQL 2008, SQL Database, SQL Query

surf control reports will not work after I enabled drill downs
reports will not work after I enabled drill downs (v.2.6) Followed directions and enabled drill downs.  Now, reports and drill downs will not work after the day I reset the drill down.  Checked directions and no indication of making changes anywhere other that the configuration menu in surfcontrol UI.  Do I need to reset something [...]

Answer Question   |  June 28, 2010  4:28 PM
SQL Database, SurfControl, Windows 7 in 2010

Log In then Output the Data of the Logged Person C# SQL 2005
I have a program that requires a user to input his/her IDNumber. If it doesnt exist the program will prompt to go to the NewRecord section. When the user input his IDNumber and he will be logged on to the real program. After doing the program and pressing the DONE Button. A messagebox will appear [...]

Answer Question   |  August 3, 2010  2:36 PM
C#, Programming, SQL 2005, sql 2005 Performance Issues, SQL Database

SQL server query to search for table and column data in database
I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

Answer Question   |  June 9, 2010  4:40 AM
SQL Database, SQL Developer, SQL development, SQL Server Query