Ravi S.Maniam's Blog

A blog by a relational guy with analytical aptitude….

Browse by Tags

Tagged Content List
  • Blog Post: Performance Boost for SQL Queries – Filtered Index in SQL Server 2008

    SQL Server 2008 introduces an enhancement to the way the indexes are created which helps to get better performance from the same queries. This new little guy is known as ‘Filtered Index’. This is actually an Optimized Non-Clustered index which is well suited to cover the subset of data with in a table...
  • Blog Post: Easy Table Partitions with SQL Server 2008

    I am glad to see people realizing the value of SQL Server 2008 platform and they are happily migrating to the SQL Server 2008 platform. Thank you very much for visiting this article. In case if you are not on the MSDN blogs then I would request you to please visit my blog at http://blogs.msdn...
  • Blog Post: SQL Server 2008 - Resource Governor - Part II

    Hi Friends, I was a bit caught up during these days so I could not update my blogs since a long time. Today again it is a weekend and I have some time so I am writing the article on Resource Governor Part II which is overdue since a long time. In my first post you would have seen what is the advantage...
  • Blog Post: SQL Server 2008 - Resource Governor - Part I

    Hi Friends, I am back with one more blog post on an interesting feature in SQL Server 2008. Today I was discussing about run away situations with my colleagues and I found that only few people read about this excellent feature available in SQL Server 2008 so just thought why not to blog about it. If...
  • Blog Post: SQL Server 2008 - Auditing

    Hi Friends, I am back again with one more blog post on SQL Server 2008 Auditing. As we all know that SQL Server 2008 is coming up with *Cool* enhancements that will help the End Users, DBAs, Developers in improving their productivity. Today I am going to blog about a feature which would be liked by people...
  • Blog Post: SQL Server 2008 - Change Data Capture - Part I

    Hello everyone .. It's been a long time since I haven't blogged. So today being a weekend again I have some time for jotting down this blog. Writing gives me a great pleasure and since last few months I didn't get this pleasure to get in touch with you through my blogs. Today I am planning to write...
  • Blog Post: FileStream Data Type : SQL Server 2008

    I am loving the enthusiasm that people have for SQL Server 2008. Everyday I come across many questions on SQL Server 2008, this shows that people are curious and I am pretty sure that people are regularly reading and learning SQL Server 2008 to know more about it and how it can help to improve their...
  • Blog Post: Table-valued Parameters - SQL Server 2008

    Hi... here is one more article on SQL Server 2008 Enhancements. In past we should have found it a bit difficult to pass numerous parameters to the T-SQL Statements or Functions or Stored Procedures. The approach we used to take is creating a Temporary Table on Demand and insert the values to the Temporary...
Page 1 of 1 (8 items)