Answer Posted / kiran
PLEASE TEL ME ANY ONE
WHAT IS THE DIFFERENCE BETWEEN DBCC INPUTBUFFER AND DBCC
OUTPUTBUFFER?
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Why it is recommended to avoid referencing a floating point column in the where clause?
What are “unrepeatable reads”?
What is meant by datasource?
How does Report Builder support Analysis Services cubes?
What is read committed?
What is a cube? : sql server analysis services, ssas
Explain what stored procedure sp_replcounters is used for? : sql server replication
Can we use max in where clause?
Can sql server 2016 run on windows 7?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Explain the properties of sub-query in sql server?
What are the hotfixes and patches in sql server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are number line correlation administrators will use while working with a subquery?
