Month: September 2010

W

When Microsoft or Google CDN fails, what should u do?

// Let me tell you one thing, an outage in CDN is very rare. But just in case you don't want to take a risk, go ahead with this fallback mechanism, as suggested by Scott Guru. Microsoft CDN outage for jQuery: <script type="text/javascript" src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js"></script> <script type="text/javascript"> if (typeof jQuery == 'undefined') { document.write(unescape("%3Cscript src='/Scripts/jquery-1.4.2.min.js' type='text/javascript'%3E%3C/script%3E")); ...

C

Convert a comma separted list to a table in SQL

I thought of sharing this simple function that you can use for splitting a list or nvarchar(max) or anything that is coma separated and sent to DB, into a temp table. Reason: Performance is a bottle neck for us. As for that matter, for any SP executions. We cannot live with the IN operator. It ...

Advertisements
Advertisements