(Ilan Hazan) Even if you think you know everything about LEFT JOIN, I bet you will learn something or two in this post!
Other News
.NET Task Parallel Library Advanced Data Parallel
(Jeffrey Juday) Much of the .NET Task Parallel Library (TPL) Data Parallel functionality is encapsulated in Parallel Loops. Parallel Loops are conceptually similar to regular loops. Like a regular loop a Parallel Loop usually operates on a collection of data, performing a computation on each element
The Difference Between @Helpers and @Functions In WebMatrix
(Mike Brind) This is another post which was inspired by a recent question in the ASP.NET forums, when someone asked what the difference is between @functions and @helpers in ASP.NET Web Pages. Here, I look at both of these contructs and explain what they are, how they are different, and how each sho
Multiple Channels in RMAN are not always balanced
(Hemant K Chitale) Occasionally, we come across questions about multiple channels and parallelism in RMAN.
Bitmap Indexes and Not Equal (Holy Holy)
(Richard Foote) Way back, I previously discussed how the CBO will simply ignore any possible indexes when determining the best execution plan involving a NOT EQUAL() condition, even if an index might in theory provide the most efficient access path.
layer_gtype keyword issue when indexing linear data on 11g
(Simon Greener) I always recommend the setting of the layer_gtype property in the parameters of an mdsys.spatial_index. I have entered some details on this in a previous blog article.
Code First Development Using the Entity Framework
(Vince Varallo) This article will demonstrate how to use the new Code First feature in the Entity Framework 4.1.
SQL Server virtualization risks: among all the pros, some cons
(Alan R. Earls) It is hard to argue with virtualization. Few technologies have had such a sudden and profound impact on the way businesses run their IT operations, saving them money and manpower, all with scant glitches or snafus. But when it comes to databases such as SQL Server, analysts warn ther
Forcing Collation in the WHERE Clause
(Michael K. Campbell) Problem: SQL Server just isn’t ‘behaving’ with some queries.
jQuery Plugin insertAt() For Comparator-Based Insertion
(Ben Nadel) When creating or augmenting user interfaces with JavaScript, I often find myself in a situation where I have to insert a new DOM element into a collection of existing DOM elements based on some sort of comparison.