Ravi S.Maniam's Blog
A blog by a relational guy with analytical aptitude….
Translate This Page
Translate this page
.Net 3.5 SP1
Application Life Cycle Management
Change Data Capture
Declarative Management Framework
SharePoint Server 2010
SQL Server 2005
SQL Server 2005 Reporting Services
SQL Server 2008
SQL Server 2008 Express
SQL Server 2008 R2
SQL Server 2012
SQL Server Server 2008
vardecimal data type
Visual Studio Team System 2010
Visual Studio Team Test
Windows Phone 7
Browse by Tags
Ravi S.Maniam's Blog
Tagged Content List
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...
3 Jul 2009
How to get the current time of any TimeZone in SQL Server 2008
We create ASP.Net applications which is hosted at a Central Location say Seattle (USA) but the customers using the application are located all around the world and when they enter the transaction they want their local time to be considered but when we call the function GetDate() the SQL Server will take...
16 Jun 2009
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...
29 Mar 2008
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...
21 Oct 2007
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...
23 Sep 2007
SQL Server 2008 - HierarchyID - Part I
I am excited by the cool new features that SQL Server 2008 is binging up ! SQL Server 2008 is bringing some commendable new features one of the nice feature is HierarchyID . This a new data type that is available in the in the latest July CTP of the SQL Server 2008 Developer Edition. Organizations have...
17 Aug 2007
Page 1 of 1 (6 items)
© 2013 Microsoft Corporation.
Privacy & Cookies