Blogs from Suhas
Dirtying my hands in SQL Server
Copy On Write
Lock Pages in Memory
Minimum Recovery LSN
Not For Replication
SQL Server 2005
SQL Server 2008
Virtual Log File
Browse by Tags
Blogs from Suhas
Tagged Content List
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...
15 Jul 2011
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...
14 Jul 2011
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...
13 Jul 2011
How to find sizes of all user tables in a database
Hi Friends! Recently I was asked to write a query that would us us know the sizes of all user tables in a database. Thought of sharing the script; this might be useful to people who would like to know the amount of space being used by each of the tables in a particular database. Here goes the script...
16 Mar 2009
Page 1 of 1 (4 items)
© 2013 Microsoft Corporation.
Privacy & Cookies