Interested to Buy Any Domain ? << Click Here >> for more details...
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
1043What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
1149What is database replication? What are the different types of replication you can set up in sql server?
964Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
1018You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
1062As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
1042You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
911While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
1049
In case you have filters in your report, when filters will be applied in cached report instance?
Where can you find the error log information? : sql server database administration
What is blocking and how would you troubleshoot it? : sql server database administration
How to create a large table with random data for index testing in ms sql server?
What do you mean by SQL injection attack?
What is buffer cash and log cache in sql server?
Which database stores information about replication?
Please differentiate between a local and a global temporary table?
Can you force a query to use a specific index?
How do I find the size of a sql server database?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Explain different types of locks in sql server.
What are the features of Embedded SQL
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?
