Sql Server 7 - Misc 2. Question & Answers. Latest updates. Rated A+

Sql Server 7 - Misc 2. Question & Answers. Latest updates. Rated A+ third normal form--eliminate dependencies between non–key columns in a table denormalization--breaking from the normal forms to help performance 3 things about optimistic concurrency--1. may result in loss of concurrency because multiple users can edit data at the same time 2. results in higher concurency than other locking systems. 3. requires timestamps object_id function--gets the database id of a table or object what is the openrowset function?--returns data from a remote data source other than a linked server–– includes a connect string what is a filegroup? What is the primary file group?--a collection of one or more data files. the primary file group contains the primary data file. the primary file group is the default filegroup. info written to a file group is spread between the files in the group proportionally to the free space in the files. @@IDENTITY--returns the last identity value used what is the open query function?--allows passthrough queries to be executed on a linked server. Good for picky database formats with abnormal syntax. format: openquery(server, 'query') ALTER TABLE––