Answer Posted / ranjit kumar routhu
cursors,t-sql,stored procedures,databse,errors and warnings,
locks,objects,performance,scans,security audit,transactions,
user configurable these comes under sql server profile
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is a coalesce function?
What is standby servers? Explain types of standby servers.
Is it possible to have clustered index on separate drive from original table location?
List the ways in which dynamic sql can be executed?
Can one drop a column from a table?
How to convert character strings into numeric values?
What is the difference between for xml raw and for xml auto?
Disadvantages of the indexes?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How to provide default values to function parameters?
How can you append an identity column to a temporary table?
Why should you use or avoid select * statements?
How to enter binary string literals in ms sql server?
How to remove duplicate rows from table except one?
Explain system functions or built-in functions? What are different types of system functions?
