Itzik Ben-Gan
  


Itzik Ben-Gan is a mentor with Solid Quality Mentors. He teaches, lectures, and consults internationally. He’s a SQL Server MVP and is the author of several books about T-SQL, including Microsoft SQL Server 2008: T-SQL Fundamentals (Microsoft Press, 2008).
Email address: Itzik@SolidQ.com
Web site: http://www.SolidQualityLearning.com

331 results found for Itzik Ben-Gan, displaying items 1 - 20
December 2008  
Handling Arrays
One way to use arrays as input for stored procedures is to employ dynamic SQL.
SQL Server Magazine

November 22, 2008  
Time Only
Itzik demonstrates a technique to extract only the time part from a DATETIME value.
SQL Server Magazine

November 3, 2008  
Live Chat with SQL Server Magazine’s Authors
Join a live chat with SQL Server Magazine’s authors Andy Kelly, Mike Otey and Itzik Ben-Gan.
SQL Server Magazine

November 2008  
Calculate Percentiles
Use T-SQL to implement statistical calculations such as percentile and percentile rank.
SQL Server Magazine

October 29, 2008  
Normalizing HIERARCHYID Values
Itzik explains how you can normalize or shorten HIERARCHYID values that became too long.
SQL Server Magazine

October 22, 2008  
Microsoft SQL Server 2008: T-SQL Fundamentals Book
Itzik talks about his new T-SQL Fundamentals book that was just published.
SQL Server Magazine

October 2008  
Query Temporal Data
Learn how to handle temporal data in SQL Server queries despite limited support.
SQL Server Magazine

September 9, 2008  
Solutions to T-SQL Sorting Challenge
Itzik provides solutions to last week’s T-SQL sorting challenge.
SQL Server Magazine

September 1, 2008  
T-SQL Sorting Challenge
Itzik provides a T-SQL challenge involving sorting separated lists of values.
SQL Server Magazine

August 30, 2008  
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

September 2008  
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

August 4, 2008  
Equilateral Triangles Puzzle Solutions
Itzik provides solutions to the equilateral triangles puzzle.
SQL Server Magazine

August 2008  
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

July 28, 2008  
Equilateral Triangles Puzzle
Itzik provides a puzzle involving equilateral triangles.
SQL Server Magazine

July 21, 2008  
Bug with NEWID Function
Itzik describes a bug involving the NEWID function and table expressions.
SQL Server Magazine

June 28, 2008  
Into the Wild
Itzik talks about his impressions of Into the Wild—a book now made into a movie.
SQL Server Magazine

June 27, 2008  
HierarchyID
Windows IT Pro

July 2008  
HierarchyID
Use SQL Server 2008’s new data type to maintain and query hierarchical data.
SQL Server Magazine

July 2008  
The Logical Puzzle
Get the solution to June’s puzzle, “Josephus Problem.”
SQL Server Magazine

June 4, 2008  
Solution to Shipping Algebra Puzzle
Itzik describes the solution to last week’s puzzle.
SQL Server Magazine



     [1]  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   next page 


SQL Server Magazine Office & SharePoint Pro Windows Dev Pro ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing