Answer Posted / gd
you can find detailed answer here on How to Debug PL/SQL
Stored Procedures in Visual Studio http://bit.ly/15O01NM
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the flow of creating a cube? : sql server analysis services, ssas
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Explain the difference between cross join and full outer join?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How do use Having,Group by,Group function in SQL?
What is the importance of concurrency control?
In which format does an image save in SQL Server database ?
What is the significance of null value and why should we avoid permitting null values?
What is a DBMS, query, SQL?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Can a table have 2 foreign keys?
can an automatic recovery be initiated by a user? : Sql server administration
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How can you check the level of fragmentation on a table?
what protocol both networks use? : Sql server database administration