class Programmer : IEnableMuch {
"Simplicity can't be bought later, it must be earned from the start" -- DB
Wednesday, April 28, 2010
Debunking the myth that COUNT('Dracula') is faster than COUNT(*)
›
Ok, that was an attempt at humor ;-) How to debunk the myth that COUNT(1) is faster than COUNT(*) ? The most simple mistaken assumption ...
Saturday, April 24, 2010
How to speed up ORDER BY COALESCE(col,9999999) in Sql Server?
›
No we won't, Sql Server 2008 doesn't support creating index on function operations yet. So how can we speed up that expression? Fi...
Tuesday, April 20, 2010
Getting the default value of column
›
Somebody in Stackoverflow wanted to do something like this: UPDATE emp SET subordinate_of = COALESCE(subordinate_of, DEFAULT), other = ...
Recalling quick sort while downloading Visual Studio Service Pack
›
using System; using System; using System.Collections.Generic; using System.Text; namespace TestQuicksort { class Program { ...
Thursday, April 15, 2010
Simple hierarchical query display
›
How to output this in Postgresql and Sql Server? emp_id | emp_name --------+--------------------------------- 1 | Presid...
‹
›
Home
View web version
