Performance difference between Tables, Temp Tables and Table Variables

Posted by on 2012-02-05 No comments

Here is an interesting performance comparison test by John:

http://www.sqlnotes.info/2012/02/03/performance-comparison-tables-temp-tables-and-table-variables/

Interesting to see such a huge performance difference between normal table and temp table.

How to install Android 4.0 on the HP TouchPad (CyanogenMod 9)

Posted by on 2012-01-26 No comments

This is what I followed:

http://liliputing.com/2012/01/how-to-install-android-4-0-on-the-hp-touchpad-cyanogenmod-9-alpha.html

http://liliputing.com/2012/01/cyanogenmod-9-alpha-0-5-bug-fix-for-the-hp-touchpad.html

And the [Release][Alpha0.5] CyanogenMod 9 Touchpad note:
http://rootzwiki.com/topic/15509-releasealpha05-cyanogenmod-9-touchpad/

SQL server activity monitor is unable to execute queries against server

Posted by on 2011-07-19 No comments

Got this error when opening Activity Monitor:

It turns out that the service “Performance Counter DLL Host” needs to be started.

SELECT { fn IFNULL(null, ‘NotFound’)}

Posted by on 2011-07-07 No comments

Is IFNULL a valid TSQL command? So can you use it in TSQL?

SELECT { fn IFNULL(null, ‘NotFound’)}

Well try it and find out.

WIX tool names

Posted by on 2011-06-03 1 comment

You have to admit these names are brilliant, definitelly not following the general IT naming convension.

    Candle: Preprocesses and compiles WiX source files into object files (.wixobj).
    Light: Links and binds one or more .wixobj files and creates a Windows Installer database (.msi or .msm).
    Lit: Combines multiple .wixobj files into libraries that can be consumed by Light.
    Dark: Converts a Windows Installer database into a set of WiX source files.
    Heat: Generates WiX authoring from various input formats.
    Insignia: Inscribes an installer database with information about the digital certificates its external cabs are signed with. For more information, see Insignia.
    Melt: Converts an .msm into a component group in a WiX source file.
    Torch:Performs a diff to generate a transform (.wixmst or .mst) for XML outputs (.wixout or .wixpdb) or .msi files.
    Smoke: Runs validation checks on .msi or .msm files.
    Pyro: Takes an XML output patch file (.wixmsp) and one or more XML transform files (.wixmst) and produces an .msp file.
    WixCop: Enforces standards on WiX source files.
    WixUnit: Runs validations on a set of XML files and the expected output file. Takes a set of WiX source files and an expected MSI as the input and outputs Pass/Fail.