Itzik Ben-Gan
|
|
Itzik Ben-Gan, a mentor at Solid Quality Mentors, teaches, lectures, and consults internationally. He manages the Israeli SQL Server Users Group, is a SQL Server MVP, and is the author of the Inside Microsoft SQL Server 2005: T-SQL series (Microsoft Press, 2006).
Email address: itzik@solidq.com
Web site: http://www.SolidQualityLearning.com
|
323 results found for Itzik Ben-Gan, displaying items 1 - 20
|
 |
T-SQL Sorting Challenge
Itzik provides a T-SQL challenge involving sorting separated lists of values.
SQL Server Magazine
SQL Server 2008 RTM MERGE Bug and Fix
Itzik describes a bug involving the MERGE statement in SQL Server 2008 RTM, and provides a pointer to the bug fix.
SQL Server Magazine
Discover the Benefits of Filtered Indexes and Statistics
Learn how you can take advantage of SQL Server 2008’s filtered indexes and statistics feature to improve query performance and obtain detailed and accurate distribution statistics.
SQL Server Magazine
Equilateral Triangles Puzzle Solutions
Itzik provides solutions to the equilateral triangles puzzle.
SQL Server Magazine
SQL Server 2008’s HierarchyID, Part 2
Use the new HIERARCHYID data type to move a subtree from one parent location in the hierarchy to another, and to convert a parent-child representation of the hierarchy to a representation that uses the HIERARCHYID data type.
SQL Server Magazine
Equilateral Triangles Puzzle
Itzik provides a puzzle involving equilateral triangles.
SQL Server Magazine
Bug with NEWID Function
Itzik describes a bug involving the NEWID function and table expressions.
SQL Server Magazine
Into the Wild
Itzik talks about his impressions of Into the Wild—a book now made into a movie.
SQL Server Magazine
HierarchyID
Windows IT Pro
HierarchyID
Use SQL Server 2008’s new data type to maintain and query hierarchical data.
SQL Server Magazine
The Logical Puzzle
Get the solution to June’s puzzle, “Josephus Problem.”
SQL Server Magazine
Solution to Shipping Algebra Puzzle
Itzik describes the solution to last week’s puzzle.
SQL Server Magazine
Shipping Algebra
See if you can solve this logic puzzle involving shipping and algebra.
SQL Server Magazine
Use T-SQL to Solve the Classic Eight Queens Puzzle
Hone both your logic and programming skills by using T-SQL to solve this logic puzzle.
SQL Server Magazine
The Logical Puzzle
Get the solution to May’s puzzle “A Cat, a String, and the Earth,” and prepare your mind for June’s puzzle.
SQL Server Magazine
Composable DML
Itzik describes a new feature in SQL Server 2008 called Composable DML.
SQL Server Magazine
Beer, Salt and a Tip for Life
Itzik shares a tip that he got from a waitress that makes beer drinking a better experience.
SQL Server Magazine
Temporal Histograms
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.
SQL Server Magazine
The Logical Puzzle
Get the solution to April’s puzzle, “Suicidal Mosquito,” and prepare your mind for May’s puzzle, which involves distance calculation.
SQL Server Magazine
Changes to MERGE and HIERARCHYID
Itzik describes changes to the MERGE statement and the HIERARCHYID datatype that will appear after CTP 6.
SQL Server Magazine
|
|
Register
