Interview Questions ASP.NET Series 2
Milestone 2 to Interview Questions ASP.NET/SQL C# Static Constructor Static Method HTTP Context HTTP Module SQL Magic Tables Instead of trigger Schema binding with views Use DML in functions using schema binding Optimization techniques · Handle deadlock, Can use no lock or related alternatives for this. · Useful clustered index and as per need minimum non clustered indexes detailed analysis specially on large tables · Integer/numbers for joins · Avoid nested queries use joins · Avoid cursor · Create maintenance plans for Index Rebuild To be continued...