ehat is the default port no of sql 2000?
Answers were Sorted based on User's Feedback
What is difference between rownum and row_number?
How will you know when statistics on a table are obsolete?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is checkpoint in sql server?
How to tune a stored procedure?
Explain transaction server auto commit?
Which database stores information about replication?
Explain “not null constraint” in sql server?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Can you explain what is the use of custom fields in report?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration