Function to Join CahcedPlan, Query Plan and Sql_text

July 13, 2011 by knandula

The cache plan handle can be found by querying select * from sys.dm_exec_cached_plans How do I get the sql text and Query Plan for this plan handle? create function returnSQL(@planhandle varbinary(max)) returns table As return select sql.text,pc.usecounts,pc.cacheobjtype,pc.objtype,pc.size_in_bytes, Pq.query_plan From Sys.dm_exec_sql_text(@planhandle) as sql cross join Sys.dm_exec_query_plan(@planhandle) as pq join Sys.dm_exec_cached_plans as pc on pc.plan_handle = @planhandle; […]

Clear your SQL server cache without restarting SQL Server

July 7, 2011 by knandula

Every T-SQL including database information (indexes etc.,) is passed to SQL server query optimizer which generates a Query Plan, this query plan is executed by SQL Server Engine. Each query plan has a query handle, these cached query plan will be cleared for every restart of sql server. Now this is not suitable for a […]

Open Computing Language – OpenCL

June 20, 2011 by knandula

Are you writing programs for GPU and CPU? Interested to know more about Heterogeneous Computing Start here; check out the webinars @ http://developer.amd.com/pages/default.aspx

HTML 5

May 26, 2011 by knandula

HTML 5 is a language for structuring and presenting content for the World Wide Web, a core technology of the internet – According to WIKIPEDIA to know more visit @ http://en.wikipedia.org/wiki/HTML5. HTML 5 is nothing but a combination of new markup and Javascript APIs. To understand new markup and Javascript APIs please visit http://diveintohtml5.org/table-of-contents.html#semantics http://dev.w3.org/html5/html4-differences/#apis […]

TF255050: A Connection cannot be made to the Report Server WMI provider

May 25, 2011 by knandula

If you face with the below issue , please try the solution @ http://www.artiso.com/ProBlog/PermaLink,guid,4f04246b-1c36-489c-ab56-70cd98523750.aspx Technorati : Reporting Services Del.icio.us : Reporting Services Zooomr : Reporting Services Flickr : Reporting Services

Community Meetup – Microsoft User Group Hyderbad @ Microsoft Campus on 26th Feb ’11

February 28, 2011 by knandula

I’m very happy to talk about SharePoint 2010 for Microsoft User Group Hyderabad , an event held at Microsoft Campus on 26th Feb ’11. Apart from my session there are couple of more interesting sessions like IIS request processing for ASP.NET , MVC , Microsoft Surface etc ., This was my first session at Microsoft […]

Learning XNA

February 27, 2011 by knandula

Best place for game programming http://www.3dbuzz.com/vbforum/sv_home.php

Hide Yellow Status Bar Sharepoint 2010

January 25, 2011 by knandula

How do we hide yellow status bar in SharePoint 2010 ? Open V4.Master file in Sharepoint desginer 2010 and search for <div id=”s4-statusbarcontainer”> <div id=”pageStatusBar” class=”s4-status-s1″> </div> </div> <div> after commenting <!– <div id=”s4-statusbarcontainer”> <div id=”pageStatusBar” class=”s4-status-s1″> </div> –> Just commont these <div tag , and now you don’t see any yellow status bar under […]

Fast Search Server2010 Installation and Configuration – Step by Step

January 24, 2011 by knandula

Fast Search Server 2010 provides extensive search capabilities to Sharepoint 2010, complete information on Fast Search Server is here http://technet.microsoft.com/en-us/enterprisesearch/ee441234 Let’s see how we can install and configure Fast Search Server on Sharepoint 2010 , download fastsearchserver binaries from MSDN (if you are a msdn subscriber). Step 1 (Installing pre-requisites): Install Software pre-requisites, Extra the […]

Sharepoint 2010 Content Type Hubs

January 13, 2011 by knandula

We will see how to create a Content Type Hub and publish content types to different webapplications, In Sharepoint 2007 when we create a custom content type for a particular web applications let say “Customer content type” for Customer Webapplication we cannot reuse the same “CustomerContentType” for a different application like Sales etc., In Sharepoint […]