Post New Answer View All Answers
What is the return type of executeupdate ()?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is nested transaction?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
what is a live lock? : Sql server database administration
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Explain transaction isolation levels in sql server?
What are the aggregate and scalar functions?
What is a join in sql?
What is nolock?
Does order by actually change the order of the data in the tables or does it just change the output?
how can you attach more than 20 ldf files in sql server
Explain powershell included in sql server 2008?
What are two difference between sql azure and azure tables?