If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
1 1283
What are points to remember while using the fillfactor argument?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Where can you find the error log information? : sql server database administration
Can binary strings be used in arithmetical operations?
Can coalesce return null?
What is the optimization being performed in oracle and SQL Server?
Define ACID properties in a Database?
Mention the different types of replication in sql server.
Can we join two tables without primary key?
What are the new data types are introduced in sql 2000?
Do you know how to implement service broker?
What is used to replicate sessions between instances in coldfusion clusters?
What is constraints and its types?
What is a synonym for manipulation?
Explain triggers in sql?