Duty Free!!

SQL Write-Ahead Overhead…

Booking an Appointment in NIMS, Hyderabad.

For all those who would like to book an appointment at NIMS for consultancy with Department Heads, they can call +91 40 23396552 and +91 40 23489244. The consultation fee is 300/-  and starts at 16:30hrs till 19hrs.

Advertisements

September 27, 2010 Posted by | Uncategorized | 1 Comment

SQL Server Standard Edition vs Enterprise Edition

Many a times a Solution Architect would fall in a dilemma whether to go with  SQL Server 2005 Standard Edition or Enterprise Edition especially when the price difference is so high.  

The best place to head to before looking into the Budget is to head to BOL – check – ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm  This link would list the features present and not but is a lengthy one. 

As a summary, if we have to work on huge DBs with loads of Binary/ Large Objects  then EE could be preferred because of advanced Indexing and pre-caching. SE is limited in terms of Cluster nodes[<2] and instances[<16] but these are rarely a limitation. if the environment is 32 bit and large memory support is implemented , EE is preferred as it Dynamically manages AWE. Remember this can be possible only on Win 2003 onwards.

Other possible maintenance tasks where EE is preferred would be Online Indexing and Parallel Indexing and DBCC . These features are useful in mission critical and round-the-clock used servers. Also the Online Page and secondary File restore would help in quick recovery.

Other important performance boosters in EE are Table and Indexed Partitioning and Enhanced Read-ahead and Scan.These are particularly useful when the Tables hold large number of records. Still, Query tuning cant be surrogated by upgrading to EE. The Query Plan needs to be well tuned prior to going for EE and make use of the Index Partitioning and parallel operations. It has be kept in mind, that when there are lots of concurrent users making heavy operations it would be sometimes better to have Parallellism disabled [Degree of Parallelism to 1].

Incase of BI and Analysis services, EE is most preferable for many of the purposes. The above listed BOL page and http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx would provide tabular list of features.

March 5, 2009 Posted by | Uncategorized | Leave a comment

Renaming a Database? Its easy…

Yes..Its easy in SQL Server to rename a database. Just search in the Books Online for “Rename Database” and you get the procedures.

Here are some precautions after renaming a Database : 

1) Check for any Maintenance Plans or Jobs using/optimizing this Database. Those jobs need to be corrected.

2) If there are any Logins on the Database with default DB as the old DB that needs to be corrected as well.  This problem arises because master..syslogins stores the DBName as the default DB rather than the dbid. any particular reason why?? Please let me know incase…

March 4, 2009 Posted by | Uncategorized | Leave a comment

Sub-prime Crisis: What is it?

By now all the news readers must have heard about the US Subprime Crisis.  Rediff published a good article on The Crisis.  If you are interested, here it is…

http://specials.rediff.com/money/2008/sep/25slid1.htm

More curious people can find their way on net to http://en.wikipedia.org/wiki/Subprime_crisis or http://globalcreditcrunch.org/. The latter one is more like a  Newsroll with all the news/rumours flowing about The Crisis and its consequences.

None of the pages, above, mentioned a solution or even a sign of a probable solution. None listed even how long the crisis shall last. The last time such a crisis came, most executives lost their commission. This time they will be glad to be working. Have we seen the depths of the Crisis or are we still finding the abyss?

September 26, 2008 Posted by | Uncategorized | Leave a comment