Answer Posted / koti
250 indexes(1 cluster index,249 non-cluster indexes)
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How dts is used to extract, transform and consolidate data?
Which are the olap features?
Why truncate is ddl?
how many clustered indexes can be created on a table? : Sql server database administration
What is provisioning, billing and metering, and connection routing concepts in the service layer?
How you can find out if an index is useful to the optimizer?
Please illustrate physical database architecture? : SQL Server Architecture
What are the security related catalog views? : sql server security
Write a SQL query to delete a table?
What is the difference between executequery () and executeupdate ()?
What is ms sql server triggers?
Do you know what is difference between stored procedure and user defined function?
What is faster join or union?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?