MS SQL Server - Clear Cache - for Query Timing

[Using MS-SQL Server] When timing a query for the purposes of optimization, the query may well run quicker on re-execution subsequent to the initial execution - due to caching by the db engine.

In order to meaningfully compare execution time across optimization attempts, the cache needs to be cleared, and this can be done by executing


DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
go


between query timings.

To turn query timing on - SET STATISTICS TIME ON
To turn query timing off - STATISTICS TIME OFF

South African Direct Marketing Opt-Out List

To register for the OptOut list for South African direct marketing:

SMS the letters DMA followed by your RSA ID number, to 34385.

or phone the RSA call centre on

0861 OPT OUT

Recursive Delete Folder & Files in Linux

rm -Rf *

or

rm -Rf rootfolder

Export Create Table Script in mySQL

SHOW CREATE TABLE TableName;

SpaceSniffer - Drive Space Allocation Mapping

If you're looking for a quick and easy disk space mapper, then I suggest SpaceSniffer from Uderzo - it's a small download, runs fast, and has decent visualization.

dotNet eMail

assembly: System.Net.Mail
classes: MailMessage, SmtpClient

---

MSDN Social thread:

public static extern IntPtr ShellExecute(
IntPtr hwnd,
string lpOperation,
string lpFile,
string lpParameters,
string lpDirectory,
int nShowCmd);

Public static void LaunchEmailClient(string mailURL)
{�
ShellExecute(IntPtr.Zero, "open", mailURL, "", "", 4);
}

You can refer http://msdn.microsoft.com/en-us/library/bb762153.aspx

---



Contact Us

Animated Icons/Images in WPF

MediaElement Option
<MediaElement Source="animated.gif"/>

MSDN Article on Pack URI's