Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

Did you Experience the NEW SQL Server 2008 R2 [Kilimanjaro]

Kilimanjaro is now SQL Server 2008 R2. This is the next version of SQL Server 2008 that will give your organization a power steering to drive the Business Intelligence efforts much faster & focused in your organization. Why I say that it is the next Read More...
Posted Sunday, October 04, 2009 1:37 PM by Ravi S.Maniam | 2 Comments

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 Read More...
Posted Saturday, July 04, 2009 9:09 AM by Ravi S.Maniam | (Comments Off)

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 Read More...
Posted Tuesday, June 16, 2009 10:56 PM by Ravi S.Maniam | (Comments Off)
Attachment(s): Attachment.zip

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 Read More...
Posted Sunday, January 18, 2009 5:13 AM by Ravi S.Maniam | (Comments Off)

How to deploy SQL Server 2008 Express as a prerequisite with ClickOnce

People often ask me how to deploy SQL Server 2008 Express with applications as a prerequisite with Visual Studio 2008. Most often this situation is encountered when people want to deploy applications using the ClickOnce or they want to build a MSI package Read More...
Posted Monday, December 22, 2008 11:33 PM by Ravi S.Maniam | (Comments Off)

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 Read More...
Posted Sunday, November 16, 2008 2:01 PM by Ravi S.Maniam | (Comments Off)
Attachment(s): ResourceGovernor.sql

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 Read More...
Posted Wednesday, July 23, 2008 2:50 AM by Ravi S.Maniam | (Comments Off)

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 Read More...
Posted Monday, July 21, 2008 7:08 AM by Ravi S.Maniam | (Comments Off)

Policy-Based Management : SQL Server 2008

NOTE: Declarative Management Framework has been renamed to Policy-Based Management so I just changed the Title of the article, the contents are unchanged. Hi, I am writing this post after somewhat long time … I hope you all are continuing with your Read More...
Posted Thursday, July 10, 2008 1:08 AM by Ravi S.Maniam | (Comments Off)

SQL Server 2008 - Change Data Capture - Part II

Hi ! It's been a long time since I last updated my blog. To continue with the Change Data Capture feature of SQL Server 2008, this is new post that helps you to know how you can write your own stored procedures / functions to get the required data in Read More...
Posted Tuesday, July 08, 2008 6:38 AM by Ravi S.Maniam | (Comments Off)
Attachment(s): CDC Modified.sql

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 Read More...
Posted Sunday, October 21, 2007 5:36 PM by Ravi S.Maniam | (Comments Off)

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 Read More...
Posted Sunday, September 23, 2007 4:38 PM by Ravi S.Maniam | (Comments Off)

Scale up with SQL Server 2005 / SQL Server 2008 - NUMA

This article is related to the NUMA (Non Uniform Memory Access) feature available with SQL Server. NUMA is a very useful feature to scale up the Server. Even before we discuss how SQL Server 2005 supports NUMA we have a few questions that needs to be Read More...
Posted Monday, September 17, 2007 1:51 AM by Ravi S.Maniam | (Comments Off)

SQL Server 2008 - Enhancements in Date and Time Data Types

I am finding SQL Server 2008 very exciting. Every day it's a new learning for me and my eyes glitter seeing the sweet surprises that SQL Server 2008 is bringing in for efficient data management. I like SQL Server because I realize that data is like the Read More...
Posted Tuesday, August 28, 2007 6:33 PM by Ravi S.Maniam | (Comments Off)

SQL Server 2008 - HierarchyID - Part II

Hi ! are you interested to know more about the HierarchyID then grab a bag of chips for yourself and read on. If you haven't read about the HierarchyID then it is recommended that go to my last post SQL Server 2008 - HierarchyID - Part I and read that Read More...
Posted Tuesday, August 28, 2007 4:56 PM by Ravi S.Maniam | (Comments Off)
More Posts Next page »
 
Page view tracker