How to locate and take substrings with charindex() and substring() functions?
Explain nested join?
Explain DBCC?
Define views.
tell me the disaster recovery plan
How many .ndf files can we create in Sql server 2005?
between cast and convert which function would you prefer and why?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
Can foreign key be deleted?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
which database is best to use in oracle and sql server? explain reasons?
What is the cartesian product of the table?
How many instances per computer are there in sql server 2000?