If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
973It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
1037What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
1135To which devices can a backup be created and where should these devices be located? : sql server management studio
1036
What is a heap?
What is bookmark link in ssrs?
How are the exceptions handled in sql server programming?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Tell me in brief how sql server enhances scalability of the database system?
What are the properties of primary key?
What security features are available for stored procedure?
Do you know the cursor optimization tips?
What is transaction server auto commit?
what is a schema in sql server 2005? : Sql server database administration
What is cte (common table expression)?
What is the datatype of rowid?
Tell me what is difference between clustered and non clustered index?
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.
What happens if null values are involved in string operations?