What is transaction ? Give me one example.
Answers were Sorted based on User's Feedback
How to drop an existing schema in ms sql server?
Do you know what is lock escalation?
what's the maximum size of a row? : Sql server database administration
How you would rewrite the sql query to return the customerid sorted numerically?
Difference between aggregate functions of sql?
what are three different authentications to connect linked servers?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is a job?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are the advantages of policy management?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
How to select all columns of all rows from a table with a select statement in ms sql server?