Explain about integration services of Microsoft SQL server?
What is key attribute?
How to assign new column names in a view?
What is a unique key constraint?
How to make a remote connection in a database?
What is clustered index
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
can you any body tell me suppose database is suspect mode. how can take to normal?
Define Check points and End Points?
What is difference between joins and subqueries?
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
What are the differences between clustered and non-clustered index?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?