When a primary key constraint is included in a table, what other constraints does this imply?

684

What are the types of database schema? : sql server analysis services, ssas

682

How can a database be repaired?

650

Can you explain what is indexed view? How to create it?

617

What are the properties and different types of sub-queries?

641

How to verify the port number of the sql server?

618

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

1638

What is sqlcmd?

629

List out the differences between global and local temp tables in sql server?

660

What is scd (slowly changing dimension)? : sql server analysis services, ssas

671

What is 1nf 2nf?

653

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

632

What is command parameter in ssrs?

130

Can we use having clause without group by?

642

What is ms sql server index?

649