July 2008
Use SQL Server 2008’s new data type to maintain and query hierarchical data.
July 2008
Get the solution to June’s puzzle, “Josephus Problem.”
June 2008
Hone both your logic and programming skills by using T-SQL to solve this logic puzzle.
June 2008
Get the solution to May’s puzzle “A Cat, a String, and the Earth,” and prepare your mind for June’s puzzle.
May 9, 2008
If you're running SQL Server 2000, use the code linked to this document in place of Listing 3 and Listing 4 in "Temporal Histograms," May 2008, InstantDoc ID 98360.
May 2008
Handling distribution of events over time is tricky. Break the problem into steps. If handling all of a task’s requirements at once is too complicated, relax some requirements, solve a simpler form of the problem, then reintroduce the complexity layers.
May 2008
Get the solution to April’s puzzle, “Suicidal Mosquito,” and prepare your mind for May’s puzzle, which involves distance calculation.
April 2008
Circumvent unsupported logical phases, work around SQL Server 2005’s lack of INTERSECT ALL and EXCEPT ALL, and take advantage of the INTERSECT and EXCEPT operations’ treatment of NULLs.
April 2008
Get the solution to March’s puzzle “Too Clever by Half,” and prepare your mind for April’s puzzle, which involves calculating distance.
March 2008
SQL Server 2008’s MERGE statement simplifies the task of merging source data into a target table.
March 2008
Get the solution to February’s puzzle “Counterfeit Coins,” and prepare your mind for March’s puzzle.
February 28, 2008
Delve further into the MERGE statement, including its more advanced aspects and its restrictions.
February 2008
Get the solution to January’s puzzle “Counting Triangles,” and prepare your mind for February’s puzzle, which involves determining weights.
February 2008
Under both Read Uncommitted and Read Committed isolations, updates running during an index-order scan can result in reading the same row multiple times or skipping rows.
January 2008
Now that you're familiar with the read-consistency problems that can develop under the Read Uncommitted isolation, check out these tangible examples that demonstrate those problems and begin to learn some workarounds.
January 2008
Get the solution to December's puzzle "Minimum Number of Weights," and prepare your mind for January's puzzle, which involves counting triangles.
December 2007
Get the solution to November's puzzle "Crazy Sequence," and prepare your mind for December's puzzle, which involves a minimum number of weights.
December 2007
This two-part series promises to shed some light on the way reads behave in different scenarios, as well as the consistency level you should expect in each scenario.
November 2007
Get the solution to October's puzzle "Two Mathematicians," and prepare your mind for November's puzzle, which involves an insane number sequence.
October 25, 2007
For those customers who don't implement cubes in AS, there's now an alternative to basic cubes.
Add these Headlines to your Website
