What is a trace frag? Where do we use it?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
How many types of indexes are there in SQL Server?
6 Answers CarrizalSoft Technologies, United Healthcare,
What are the five major components of a dbms?
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
How to swap the data of two columns in a table. both the columns containing varchar values.
What is the use of RDBMS?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is msdb database? : SQL Server Architecture
When we can say that is in BCNF?
What is entity data services?
What do you mean by COLLATION?
how to take backup bcp out for a column in table in sql server?