What are all new concepts in SQL Server 2008? That is
Exactly Difference between 2005 to 2008
Answers were Sorted based on User's Feedback
More powerful management
Policy Management feature
Improved performance and scalability
Storing high volume of data
Support for diverse types of data
Better security and availability
Security increased by data encryption
Availability increased by database mirroring
Changes for developers
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / jigar
Row Constructors
Output Clause
Compound Operators
Inline Variable Assignment
Grouping Sets
Is This Answer Correct ? | 0 Yes | 0 No |
Explain syntax for viewing trigger?
Explain what are the different index configurations a table can have?
What are the different editions available in sql server 2000?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
What is the cartesian product of table?
What are “unrepeatable reads”?
What is de-normalization and what are some of the examples of it?
How many full-text indexes can a table have?
What is Check point? Explain in Brief what it will do?
hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is normalization? Describe its different types.