Performance of very large SQL Server table with millions of rows
Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it [...]
Answer Question
| February 6, 2009 12:57 AM
Database design, SQL Server administration, SQL Server database design and modeling, SQL Server maintenance, SQL Server performance, Very Large Databases
Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it [...]
Answer Question
| February 6, 2009 12:57 AM
Database design, SQL Server administration, SQL Server database design and modeling, SQL Server maintenance, SQL Server performance, Very Large Databases
1:1 Modeling Inheritance 1:1
I am working on a database to store employment history. A person can be employed by an organization or another person. I created the following tables: Person Organization Employer Employment Person and Organization both have a 1:1 relationship with Employer. Employer has a 1:M relationship with Employment. Is this an acceptable way to model the [...]
Answer Question
| December 12, 2008 6:22 PM
Database, Database design, Modeling Inheritance
I am working on a database to store employment history. A person can be employed by an organization or another person. I created the following tables: Person Organization Employer Employment Person and Organization both have a 1:1 relationship with Employer. Employer has a 1:M relationship with Employment. Is this an acceptable way to model the [...]
Answer Question
| December 12, 2008 6:22 PM
Database, Database design, Modeling Inheritance
How to test whether the Database tables designed to avoid deadlock occurence?
I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do? [...]
Answer Question
| December 10, 2008 11:04 AM
Database deadlock, Database design, Database Failover, Database modeling, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server
I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do? [...]
Answer Question
| December 10, 2008 11:04 AM
Database deadlock, Database design, Database Failover, Database modeling, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server
Database design
Hi all, I have a condition and formula generator in my application. I must save this condition and formula in database and calculate formulas for each condition. I want to model these conditions and formulas. For example: Condition: Education=BS AND MaritalStatus=Married AND YearsOfService>10 Formula: Salary=2.5*EducationFactor+BaseSalary I modeled conditions and formula separately and using Interpreter Pattern. [...]
Answer Question
| November 17, 2008 9:57 AM
Database design, Database modeling
Hi all, I have a condition and formula generator in my application. I must save this condition and formula in database and calculate formulas for each condition. I want to model these conditions and formulas. For example: Condition: Education=BS AND MaritalStatus=Married AND YearsOfService>10 Formula: Salary=2.5*EducationFactor+BaseSalary I modeled conditions and formula separately and using Interpreter Pattern. [...]
Answer Question
| November 17, 2008 9:57 AM
Database design, Database modeling
Database design schema for Test Data Management?
For test data analysis across the builds, platforms etc, we are thinking of storing the test execution results into the database. Please let me know if any one has already designed the db schema for test case & report management.
Answer Question
| November 4, 2008 6:31 AM
Database design, Database schema, Software Quality, Software Quality Assurance, Software testing, Software testing tools
For test data analysis across the builds, platforms etc, we are thinking of storing the test execution results into the database. Please let me know if any one has already designed the db schema for test case & report management.
Answer Question
| November 4, 2008 6:31 AM
Database design, Database schema, Software Quality, Software Quality Assurance, Software testing, Software testing tools
designing indexes
I have a question regarding database design. Lets assume that there is a table with 10 columns. I don’t have any single column which I can choose as candidate for Primary key. Though, combination of 5 columns can uniquely identify records. Here, I created an identity column as a PK and added UNIQUE constraint on [...]
Answer Question
| October 14, 2008 3:31 PM
Database design, Indexes, JOIN statement, Primary keys
I have a question regarding database design. Lets assume that there is a table with 10 columns. I don’t have any single column which I can choose as candidate for Primary key. Though, combination of 5 columns can uniquely identify records. Here, I created an identity column as a PK and added UNIQUE constraint on [...]
Answer Question
| October 14, 2008 3:31 PM
Database design, Indexes, JOIN statement, Primary keys
Access 2007 Complex Calculations
In Access 2007 I need to enter raw test data into tables, perform complex calculations including linear trends, then store the calculated results. These are the only numbers I really care about. The raw test data could be deleted for all I care, I just need the calculated results. I will need to run queries [...]
Answer Question
| September 5, 2008 7:35 PM
Complex Database Calculations, Database, Database design, Linear trends, Microsoft Access
In Access 2007 I need to enter raw test data into tables, perform complex calculations including linear trends, then store the calculated results. These are the only numbers I really care about. The raw test data could be deleted for all I care, I just need the calculated results. I will need to run queries [...]
Answer Question
| September 5, 2008 7:35 PM
Complex Database Calculations, Database, Database design, Linear trends, Microsoft Access
Hardware requirements for SQL Server 2005
Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db ‘s will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the [...]
Answer Question
| August 7, 2008 10:50 AM
Database design, SQL Server 2005, SQL Server performance
Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db ‘s will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the [...]
Answer Question
| August 7, 2008 10:50 AM
Database design, SQL Server 2005, SQL Server performance
Efficient storage of survey answers
We have a website that asks the user a set of questions. The answers are curently stored in SQL database using a table that has: PersonID QuestionID AnswerID Value So one answer to one question is stored in each record. Some questions have more than one possible answers, so all answers to a given question [...]
Answer Question
| August 1, 2008 8:57 PM
Database design, SQL Database
We have a website that asks the user a set of questions. The answers are curently stored in SQL database using a table that has: PersonID QuestionID AnswerID Value So one answer to one question is stored in each record. Some questions have more than one possible answers, so all answers to a given question [...]
Answer Question
| August 1, 2008 8:57 PM
Database design, SQL Database
How to calculate my DataBase size
Dear all, I like to calculate my database size , can u tell me the views and formula to calculate my DB size please
Answer Question
| July 22, 2008 1:24 PM
Data modeling, Database design
Dear all, I like to calculate my database size , can u tell me the views and formula to calculate my DB size please
Answer Question
| July 22, 2008 1:24 PM
Data modeling, Database design
Designing Table Layout
Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times…can anyone help?
Answer Question
| July 8, 2008 8:57 AM
Database design, Microsoft Excel, tables
Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times…can anyone help?
Answer Question
| July 8, 2008 8:57 AM
Database design, Microsoft Excel, tables
Database Question.
Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information about different years growth statistics [...]
Answer Question
| July 31, 2008 5:33 PM
Data analysis, Data Junction, Data management and storage, Data warehousing applications, Database design, Database issues
Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information about different years growth statistics [...]
Answer Question
| July 31, 2008 5:33 PM
Data analysis, Data Junction, Data management and storage, Data warehousing applications, Database design, Database issues
Split Databases – BE Structural Changes Version: 2007 (12.0)
Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can’t you put their copy of the FE on the network, under a folder just for that user?
Answer Question
| May 7, 2008 8:23 PM
Access 2007, Database, Database design, Microsoft Access
Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can’t you put their copy of the FE on the network, under a folder just for that user?
Answer Question
| May 7, 2008 8:23 PM
Access 2007, Database, Database design, Microsoft Access
Generic database design to store logs of every database change
Hi there, Can anyone help me out by providing a generic database design for having logs of all the changes to my master table so that I can review all the changes at a later point of time through my application. Every response will be appreciated…. thanks, Sudhakar
Answer Question
| February 8, 2008 1:26 PM
Database, Database design
Hi there, Can anyone help me out by providing a generic database design for having logs of all the changes to my master table so that I can review all the changes at a later point of time through my application. Every response will be appreciated…. thanks, Sudhakar
Answer Question
| February 8, 2008 1:26 PM
Database, Database design
Database Project Definiton
A corporation has decided to move its production data off the OS 390 platform to a windows platform running the windows data center operating system. *There are 18 terabytes of data of mission critical data that needs to be available 24 hrs a day. *Because of the size of the customer database they need to [...]
Answer Question
| August 22, 2008 10:40 PM
Database architectures, Database design
A corporation has decided to move its production data off the OS 390 platform to a windows platform running the windows data center operating system. *There are 18 terabytes of data of mission critical data that needs to be available 24 hrs a day. *Because of the size of the customer database they need to [...]
Answer Question
| August 22, 2008 10:40 PM
Database architectures, Database design
