You may worked with xml and you may aware of title mentioned in this post. Today when I was working to collect information from one table which having xml column, I was trying to open xml data result set from query analyzer with new query window. For so...

ISV Vendors may supply a copy of their data files instead of a full database backup/scripts. Attempting to attach the database requires the use of CREATE DATABASE...ATTACH_REBUILD_LOG option. Re-creating the log file resets the recovery model of the database to SIMPLE. In this post, we attempt to explore why the recovery model is reset....

Recently, Bill Jelen aka Mr Excel came up with a podcast that showcased a visualization that he termed as the “100% Visualization”. I have never seen this visualization before and I am not sure whether Stephen Few would approve of it. But I found the co...

I have created a video tutorial for Visual studio 2012. Where I have shown different kind of searching options. ";" alt="">

Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often used in telling family stories. Except ascendants. I never really understand what this word means until I ran into this wor...

In this post, we take a look at the Dynamic Management and Catalog Views related to Resource Governor introduced in SQL Server 2012: sys.dm_resource_governor_resource_pool_affinity and sys.resource_governor_resource_pool_affinity...

Often developers use Import wizard from SSMS or SSIS to import data from a text file into a table. You may or may not import it successfully based on the nature of the data. Create a text file named test.txt with the following data id|name|address1|rame...

A while before few weeks, I discussed about an error of replication “The row was not found at the Subscriber when applying the replicated command”. We had a tricks to get discrepancies for error table and resolved issue. Let me put another method (Actu...

In one of my recent blog post of SSIS Buffer Error , I have demonstrated how Union All transformation has caused error. I received a comment in the blog post, asking for the functionality of Union All task and why and how it is used. This blog post is f...

After installation of SQL Server 2012 SP1, one may encounter a situation where the CPU spikes to 100%, NGEN errors are encountered and Event Viewer has the error message: "Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans', Component '{0CECE655-2A0F-4593-AF4B-EFC31D622982}' failed." This post directs to the Microsoft KB article with the solution....