662 reputation
37
bio website
location
age
visits member for 2 years, 4 months
seen Dec 3 '12 at 21:31

Jul
3
awarded  Yearling
Jul
3
awarded  Yearling
May
6
answered Transfer data from DB2 to Oracle
Sep
26
revised How to design a database for financial bond prices?
typos and grammar
Sep
26
suggested suggested edit on How to design a database for financial bond prices?
Aug
2
answered Appropriate multi-language schema, or overkill?
Jul
24
answered Why does ORDER BY not belong in a View?
Jul
18
comment can sql generate a good plan for this procedure?
@jason - you are thinking procedural. when in DB, think relational. what you are doing is a merge, so get it done via one statement.
Jul
11
comment Does the partition key also have to be part of the primary key?
Well, a whole lot of stuff is not a requirement. Even indexing is not a requirement! To make sense functionally, partitioning has to be done on the leading column of a candidate key. Otherwise how would the app architect use the table?
Jul
11
comment Does the partition key also have to be part of the primary key?
Let me clarify - The column you are partitioning is preferred to be part of a Primary Key if it is not a Surrogate Key (Identity type of key). If the PK is a surrogate key, then it should be part of a meaningful Candidate Key. As a DBA you can use anything to partition, but for the app, it has to make sense as a clean boundary. This is possible only if it is part of some sort of a candidate key.
Jul
10
awarded  Editor
Jul
10
revised Does the partition key also have to be part of the primary key?
added 4 characters in body
Jul
10
awarded  Commentator
Jul
10
comment Does the partition key also have to be part of the primary key?
Same as any other index. example: CREATE INDEX IX_ProductVendor_VendorID ON Purchasing.ProductVendor (BusinessEntityID);
Jul
10
comment Does the partition key also have to be part of the primary key?
Candidate Key is just another key qualified to be a Primary Key. For example, ID is the primary key. But in the same table, if another column for eg. PERSON_ID also can uniquely identify a row, that is called Candidate Key. The 2nd and 3rd normalization rules should hold against all candidate keys also.
Jul
9
answered Does the partition key also have to be part of the primary key?
Jul
9
answered Mechanics of partitioning
Jul
6
answered UPDATE with JOIN on 100mm records, how to do this better? (in T-SQL)
Jul
5
comment Which mysql storage engine to choose?
With Full-Text capability in 5.6, it is hard to find a compelling technical reason for not using innoDB. There may be licensing difference though.
Jul
5
comment Help optimizing query in the MySQL slow-query log
Good catch, blob does it