 Related Questions Latest Answer : .dbc file basically helps abinitio coops to connect to database. It includes all the required database parameter and other default value respective to it. you can modify them.However .cfg is file is use set up some temporary environment for a particular ... Latest Answer : You can truncate the table using one of the following components: Run SQL, Truncate Table, Update Table. ... Latest Answer : for partition by key it internally generates the hash code. through that i distributes the data records.round robin what they said was correct ... What is the difference between clustered and non-clustered indices? ...and why do you use a clustered index? In a process which reads 15,000 rows from one table and either updates or inserts them into another table and given the scenario where the process may abnormally terminate, describe how you track progress within the data to ensure the process could be restarted without repeating any processing. In the scenario outlined in #18 and given that the output table(s) will be accessed by concurrent readers describe how your SQL code would be structured to minimize lock contention. Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data. What is the t-sql command element you would use to place a logical object (table or index) on a specific physical file (file group). Latest Answer : When you use truncate all the space alloted for the records along with records gets deleted and if you use delete only the records are deleted and the space allocated for the records remains unaltered. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
