Popular Posts

Friday, February 22, 2013

ASP.NET MVC with StructureMap: a complete overview

Structure map with asp.net MVC step by step

ASP.NET MVC with StructureMap: a complete overview:

'via Blog this'

SQL Sentry Plan Explorer: Query Plan Analysis

an alternative tool to find out about the execution plan for the queries with better options .... adds menu options to sql server as addin ....

SQL Sentry Plan Explorer: Query Plan Analysis:

'via Blog this'

SQL SERVER – Find Statistics Update Date – Update Statistics | SQL Server Journey with SQL Authority

Wrong statistics can cause under estimation and spills ie the pages will be spilled from memory to IO and therefore can cause a lot of performance issues and applying queries in SQL Server .... To identify a list of all tables and indexes and the no o days their statistics is not updated, the following query can help ...



You can use the below query to find all the Tables and Index with number of days statistics being old
SELECT OBJECT_NAME(A.object_id) AS Object_Name, A.name AS index_name, STATS_DATE(A.OBJECT_ID, index_id) AS StatsUpdated ,
DATEDIFF(d,STATS_DATE(A.OBJECT_ID, index_id),getdate()) DaysOld
FROM sys.indexes A
INNER JOIN sys.tables B ON A.object_id = B.object_id
WHERE A.name IS NOT NULL
ORDER BY DATEDIFF(d,STATS_DATE(A.OBJECT_ID, index_id),getdate()) DESC
Thsi works fine with Both SQL Server 2005 and 2008



SQL SERVER – Find Statistics Update Date – Update Statistics | SQL Server Journey with SQL Authority:

'via Blog this'

Saturday, February 16, 2013

How to: Add Web Browser Capabilities to a Windows Forms Application

Found this article that explains how to get callback from the HTML page displayed inside WebBrowser control in the Windows Form application ... this enables to call the windows form code back from the javascript!!!


How to: Add Web Browser Capabilities to a Windows Forms Application:

'via Blog this'

Friday, February 8, 2013

Selectors

Codleywidley -> a great website to play with jquery selectors ONLINE !! Only examples that allow to interactively play with Jquery Selectors ... has examples of almost all of the HTML elements ....Nice

Selectors:

'via Blog this'

Friday, February 1, 2013

Some open source free Javascript libraries: JSON2 -> enables to serialise and deserialise JSON to Javascript objects DateJS -> Extra functionalities for date functions