|
| |
| |
|
|
|
Da Notes -
70-029 - V
Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender. |
Passing Score: 693, Questions: 49, Time: 150 Min.
|
Da Notes Index
|
|
|
Vertical partitioning
|
See partitioning
|
Views
|
Simplify complex queries by using views that can focus on important data. Also used to limit access to sensitive data (payroll columns, etc).
Useful for hiding complex database design from the end user.
Cannot include ORDER BY
Cannot reference INTO keyword
Cannot use temp tables
Cannot use more than 1024 columns
Cannot combine with other TSQL statements in a single batch.
|
|
|
|
|