Database design is the process of specifying the structure and thus the logical aspects of a database.
I need to add proper index to my tables and need some help. I'm confused and need to clarify a …
sql-server database-design indexing clustered-index non-clustered-indexActually what do they mean? All articles I find about them don't give me an idea, or my knowledge is …
database database-design database-schema olap oltpI'm creating a database table and I don't have a logical primary key assigned to it. So, I'm thinking about …
database database-designIn relational database design, there is a concept of database normalization or simply normalization, which is a process of organizing …
database database-design database-normalizationI have applied for an internship in a company and as a question they have asked me to create a …
sql database-design oracle11g schema databaseI am going to design a DW and I heard about materialized views. Actually I want to create a view …
sql-server database-design indexed-viewsI have always wondered how Facebook designed the friend <-> user relation. I figure the user table is …
sql facebook database-design database-normalization database-tableIf I have two relations in a database, like this: CREATE TABLE Courses ( CourseID int NOT NULL PRIMARY KEY, Course …
sql database database-design cascade relationPreamble I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2). I got …
sql-server sql-server-2008 database-design sql-server-2005So, per Mehrdad's answer to a related question, I get it that a "proper" database table column doesn't store a …
sql linq linq-to-sql database-design linq-to-entities