|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 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 : Hi,lookup_local funtion retrieves the first matching record from a partitioned multifile,which is partitioned on a particular key.consider a lookup file "emp_detail" which is having the fields emp_id,emp_name,dept and is partitioned on emp_id.use,lookup_local("emp_detail","456A"),then ... Latest Answer : while creating table you can implement tat by addingforeign key references p.tab_name(p.Col_name)heree p refers primary table andd this statement to be written beside col you want make as refrential integrity for the table..................... ... Latest Answer : Stored procedure is a pre-compiled execution block,so they do not want to wait as the time for compilation.It is call from the server.It reduce the execution time ... Latest Answer : Using "show users" command yuo can see all the users currently logged on into SQL server ... Describe which database structural and physical elements you would review when optimizing query performance. Describe which system/process elements you would review when trouble-shooting general server slowness. Describe how you would ensure a T-SQL script ran on a particular database where there are multiple databases on a single server. 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).
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
