1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication?
Answer Posted / subhash kumar
yes
no
yes
yes
no
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain powershell included in sql server 2008?
How do you implement session management in SQL Server mode?
What is the significance of master, tempdb and model databases?
What is the difference between sdf and mdf?
How do I delete a sql server database?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Does a full backup include transaction log?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
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 structure can you implement for the database to speed up table reads?
What are advantages of ssrs or why we should use ssrs?
Define Unique Key?
Define full outer join in sql server joins?
How to filter records of table in SQL SERVER?
Explain the various types of concurrency problem?