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
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
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
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
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
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
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? 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
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
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
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
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 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
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? 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
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 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
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
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
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