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
|
321 results found for Itzik Ben-Gan, displaying items 1 - 20
|
 |
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
Set Operations
Windows IT Pro
Set Operations
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.
SQL Server Magazine
|
|
Register
