Archive for January 12th, 2008

SQL Counter: Part 10 (Full Scans/sec) January 12th, 2008

Vinod Kumar

SQL Server Access Methods Object -> Full Scans/Sec
This counter should always be captured. It shows how often a table index is not being used and results in sequential I/O.
This is defined as the number of unrestricted full scans. These can be either base table or full index scans. Missing or incorrect indexes can result in reduced performance because of too high disk access.

Continue reading...


Query Processing Enhancements with SQL 2008 January 12th, 2008

Vinod Kumar

Check the BOL documentation on this Partitioning enhancement here.

Continue reading...


Do you have the Momentum? January 12th, 2008

Vinod Kumar

Are you interested in evaluating latest of Microsoft products? I would like to include esp:

  • Windows Server 2008 – AD, Virtualization, Virtualization, IIS 7
  • System Center
  • SQL Server 2008

Feel free to drop me a line and secondly, you must be from India because I will be able to help you then only :) …

What can you get !!!

  • Opportunity to learn the new technology
  • Access to exclusive forums and product support
  • Have an opportunity to share your experience with the world-wide community

What can your company see as value ?

  • In-depth technical content
  • Managed forums
  • TechNet Subscription
  • PSS support
  • Lastly, help from me :)

BTW, you become a hero to try and get first hand experience of the software before the final release. And personally, you get an opportunity to communicate with the MS folks on a one-on-one conversation and the exposure this gives you is quite unique.

Action Item:

If you or your company are interested to pilot / try the above products. Mail me at [ITPro (at)]. Dont think, ask your manager and if you are from India – Drop a line NOW !!!

Continue reading...