Profile cover photo
Profile photo
kutub b
71 followers
71 followers
About
kutub's posts

Post has attachment
Updating Statistics not always a good idea!!


Post has attachment
Star schema vs Snowflake Schema
Here is comparison chart which will useful for quick study of both the approach. Get more details here Comparison chart Snowflake Schema Star Schema Ease of maintenance / change No redundancy, so snowflake schemas are easier to maintain and change. Has redu...

Post has attachment
Impact of Index on Insert query
Creating an index is nothing but additional burden on insert query. Today someone asked me what can be a technical reason behind that, in search of answer for that I came across a good article which I would like to share with everyone on my blog, I think it...

Post has attachment
Quick revision of XML datatypes in SQL SERVER
This Video covers quickly some overview of XML datatypes and functions present in SQL SERVER with example.  1. For XML Clause 2. Query and value functions Query => gives you result with XML tags Value => will give you the data with in XML tags 3. how we can...

Post has attachment
What's new in SQL Server Integration Services 2012?
What's new in SQL Server Integration Services 2012? from Microsoft TechNet - Belgium and Luxembourg

Post has attachment
Find Last day of the month from Month and Year - T-SQL: SQL SERVER
Yesterday I was working on one of my clients database migration project and was implementing an ssis package, in one of the mapping there was requirement to derive last day of the month from two available columns from source data, which was Month (varchar) ...

Post has attachment
One of my favourite :)

Post has attachment
20 Exicitng features of SQL SERVER
Following link takes you to a good article explaining 20 new and exciting features which you can use or try in SQL SERVER 2012. Hopefully you will like it too. http://www.codeproject.com/Articles/526621/Top-20-exciting-features-of-SQL-Server-2012-Part-1

Post has attachment

Post has attachment
Wait while more posts are being loaded