Interested to Buy Any Domain ? << Click Here >> for more details...
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
939Every 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?
946How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
1024
What is a cursor, index in sql?
Which are the new data types introduced in sql server 2008?
When would you prefer to have a minimum number of indexes?
What stored by the msdb? : sql server database administration
What is reportserver and reportservertempdb ?
Do you know spatial data types - geometry and geography in sql server 2008?
What are the different types of indexes?
How will you find out if there are expensive SQL statements running or not?
Do you know query execution plan?
What is a deadlock and what is a live lock?
What is amo? : sql server analysis services, ssas
What is the data tier application?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is explicit cursors?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
