Define Foreign Key?
Answer Posted / vani
it is a primary key which is referenced to another table
| Is This Answer Correct ? | 19 Yes | 5 No |
Post New Answer View All Answers
when would you go for denormalization? : Sql server database administration
Does index speed up select statements?
What is the use of “join” in sql server?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How will you know when statistics on a table are obsolete?
What is the maximum row of a size?
How to create an index on an existing table in ms sql server?
What samples and sample databases are provided by microsoft?
What happens to a trigger with multiple affected rows?
Explain about link server in sql server?
How can you tell if a database object is invalid?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
what is the main function of a query parameter?
Can two tables share the same primary key?