Blogs from Suhas

Dirtying my hands in SQL Server

Browse by Tags

Tagged Content List
  • Blog Post: Advanced Performance Tuning – 4 :: Designing for better performance contd…

    Few months back, I was working with one of my customers, who was engaged by his client to design a Survey Module. Nothing very fancy about the module, but the kind of reports that were to be delivered made it really tricky. Let me explain the requirements first: When customers click on a Survey Link...
  • Blog Post: Advanced Performance Tuning – 3 :: Designing for better performance

    If you have read my earlier post , you might be saying “Heck! This guy loves to post questions without providing proper answers!” Believe me, that is not my intention. My intention here is to help you understand common mistakes that people make, so that you can avoid them in your projects. The biggest...
  • Blog Post: Advanced Performance Tuning – 2 :: Which side of the operator

    If you have read my earlier blog post on the Importance of data-types , you might be wondering, “What the heck is going on here?” I had already written in that post the reason behind the slow performance – the EmpCountry column in the Employee table is CHAR(2) which cannot be directly compared with NCHAR...
  • Blog Post: Advanced Performance Tuning – 1 :: Importance of data-types

    Why did we develop DBMS systems? Not just for storing data – but also to be able to search for and retrieve stored data, and we define what our search criteria should be. This was probably true a couple of decades back, but we have come a long way now. With the huge advancement of technology...
Page 1 of 1 (4 items)