T-SQL Black Belt
|
167 results found for T-SQL Black Belt, displaying items 1 - 20
|
Calculating Concurrent Sessions, Part 2
Itzik presents a set-based solution with linear complexity that performs better than the previous solutions. He also discusses a set-based solution that will outperform all other solutions once SQL Server supports it.
SQL Server Magazine
—
Itzik Ben-Gan
Calculating Concurrent Sessions, Part 1
Itzik discusses a set-based and a cursor-based solution to a T-SQL concurrent sessions querying problem, as well as the performance and scaling ramifications of both solutions.
SQL Server Magazine
—
Itzik Ben-Gan
Date and Time Support in SQL Server 2008
Four new date- and time-related data types in SQL Server 2008 address the limitations of previous versions’ DATETIME and SMALLDATETIME data types.
SQL Server Magazine
—
Itzik Ben-Gan
Minimally Logged Inserts
Learn which insert methods can benefit from minimal logging, to improve your statements' performance.
SQL Server Magazine
—
Itzik Ben-Gan
Using Nested Iterations and the OVER Clause for Running Aggregates
Until SQL Server supports the OVER clause, your best solutions for running aggregates are
a set-based solution using subqueries or joins, for very small partition sizes, or a CLR data reader–based solution, for large partitions.
SQL Server Magazine
—
Itzik Ben-Gan
CLR-Based Solution for Running Aggregates
If performance is your main goal, you should use the set-based solution only with very small partition sizes; otherwise, you should use the CLR-based solution.
SQL Server Magazine
—
Itzik Ben-Gan
Set-Based vs. Cursor-Based Solutions for Running Aggregates
Although set-based solutions to running aggregations have many advantages over cursor-based solutions, cursor-based solutions can provide better performance in certain cases, such as when dealing with very large partitions.
SQL Server Magazine
—
Itzik Ben-Gan
More SQL Server 2008 T-SQL Improvements
Itzik discusses four enhancements, including composable DML, the ability to declare and initialize variables in the same statement, compound assignment operators, and more reliable object dependency information.
SQL Server Magazine
—
Itzik Ben-Gan
SQL Server 2008’s T-SQL Features
SQL Server 2008 provides several small T-SQL features, such as an enhanced VALUES clause, improved ISO week number calculation, and the ability to convert character to binary and binary to character values while preserving the hexadecimal digits.
SQL Server Magazine
—
Itzik Ben-Gan
More Options for Handling Arrays as Inputs
Use a Common Language Runtime (CLR) split user-defined function (UDF) or SQL Server 2008’s new table-valued parameters to handle arrays as inputs.
SQL Server Magazine
—
Itzik Ben-Gan
Ordered Common Language Runtime Table-Valued User-Defined Functions
Enhancements to CLR table-valued user-defined functions in SQL Server 2008
SQL Server Magazine
—
Itzik Ben-Gan
Handling Arrays as Inputs
Learn how to use a T-SQL split function to handle arrays as inputs for SQL Server stored procedures.
SQL Server Magazine
—
Itzik Ben-Gan
Handling Arrays
One way to use arrays as input for stored procedures is to employ dynamic SQL.
SQL Server Magazine
—
Itzik Ben-Gan
Query Temporal Data
Learn how to handle temporal data in SQL Server queries despite limited support.
SQL Server Magazine
—
Itzik Ben-Gan
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
—
Itzik Ben-Gan
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
—
Itzik Ben-Gan
HierarchyID
Use SQL Server 2008’s new data type to maintain and query hierarchical data.
SQL Server Magazine
—
Itzik Ben-Gan
The Logical Puzzle
Get the solution to June’s puzzle, “Josephus Problem.”
SQL Server Magazine
—
Itzik Ben-Gan
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
—
Itzik Ben-Gan
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
—
Itzik Ben-Gan
|
|
Register
