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...

Popular posts from this blog

Excel Key Board Shortcuts

Shortcut key Action Menu equivalent comments version Ctrl+A Select All None All Ctrl+B Bold Format, Cells, Font, Font Style, Bold All Ctrl+C Copy Edit, Copy All Ctrl+D Fill Down Edit, Fill, Down All Ctrl+F Find Edit, Find All Ctrl+G Goto Edit, Goto All Ctrl+H Replace Edit, Replace All Ctrl+I Italic Format, Cells, Font, Font Style, Italic All Ctrl+K Insert Hyperlink Insert, Hyperlink Excel 97/2000 + Ctrl+N New Workbook File, New All Ctrl+O Open File, Open All Ctrl+P Print File, Print All Ctrl+R Fill Right Edit, Fill Right All Ctrl+S Save File, Save All Ctrl+U Underline Format, Cells, Font, Underline, Single All Ctrl+V Paste Edit, Paste All Ctrl W Close File, Close Excel 97/2000 + Ctrl+X Cut Edit, Cut All Ctrl+Y Repeat Edit, Repeat All Ctrl+Z Undo Edit, Undo All F1 Help Help, Contents and Index All F2 Edit None All F3 Paste Name Insert, Name, Paste All F4 Repeat last action Edit, Repeat. Works while not in Edit mode. All F4 While typing a formula, switch b...
Read more

Today's Cyber War for Cyber Security

Cyber security: India co-operating with US The United States is having close co-operation with India on a range of issues related to cyber security. WASHINGTON: The United States is having close co-operation with India on a range of issues related to cyber security and the country wants to expand it, a US official has said. "We have had great cooperation with India. We've had many meetings with Indian officials in various different fora, including at the White House level," Christopher Painter, the State Department Co-coordinator for Cyber Issues, told a group of foreign journalists in a media roundtable. "I think we have lots more meetings coming up. I think we have very good cooperation with India, and that's something we want to build on and expand," he said in response to a question. Talks with India, he said, are just a reflection of the fact that they are talking about how to exchange information, coo...
Read more