TRY_CONVERT in SQL Server 2012
One of the new TSQL feature in SQL Server 2012 is TRY_CONVERT, basically it’s a function that will return null if the object passed is not compatible with the expected casting. In earlier version of SQL…
-
-
SQL Server udf Join
I found some interesting article to share in regards of joining the UDF into your join which ends up in executing the UDF as many as number of records being joined to. The solution is to…
-
Tracing Dynamic SQL in the SQL Profiler
The default template in SQL profiler doesn’t trace the dynamic SQL executed by the stored procedure. In order to trace the Dynamic SQL, you need to turn on these 2 options in your tracing profile SP:stmtstarting…
-
Tips: How to find Recursive Parent-Child relationship in SQL Server
Below is the sample in how to reproduce a recursive parent-child relationship and how to find out which records are the troublesome one CREATE TABLE RecursiveSample ( REF INT NOT NULL, PARENT_REF INT NOT NULL, NAME…
-
Simulate Deadlock in SQL Server
How to simulate Deadlock in SQL Server, pretty simple 1. Create a table CREATE TABLE MyDeadlockTable ( REF INT PRIMARY KEY NOT NULL, NAME VARCHAR(255) ) GO 2. Populate a table with the record INSERT INTO…
-
Microsoft All in One Script Framework
I’ve just found that Microsoft has just released a repository for all scripts which are driven by Technet script repository and Microsoft Customer Script & Support, the sample scripts are based on the real world scenario…
-
Coding Standard for Javascript
This is the javascript coding standard that my colleague found on Github, but seriously this is a good standard and I recommend it to any developer https://github.com/rwldrn/idiomatic.js/
-
Styles in Silverlight
In silverlight, normally we apply style per XAML file by adding the style into UserControl.Resources section. Sample below http://pastebin.com/embed_iframe.php?i=FgjnHqAT and to apply the style in the control we do http://pastebin.com/embed_iframe.php?i=veWGiyNh but let’s say you want to…