T-SQL 2005
|
32 results found for T-SQL 2005, displaying items 1 - 20
|
Can I Convert This String to an Integer?
Itzik shows you T-SQL and CLR methods for checking whether a given string can be converted to an integer--handy additions to T-SQL's data-manipulation capabilities.
SQL Server Magazine
—
Itzik Ben-Gan
An Upgraded UPDATE
Enhancements to UPDATE in SQL Server 2005 help avoid deadlocks caused by simultaneous database requests.
SQL Server Magazine
—
Itzik Ben-Gan
Query DMFs to Analyze Performance Stats
Learn how to combine new T-SQL querying elements with DMFs to analyze performance statistics and aid in database tuning.
SQL Server Magazine
—
Itzik Ben-Gan
Calculate the Sum of Salaries in an Employee Tree
Itzik takes a SQL Server MVP's challenge: Calculate for each employee the sum of the salaries of all subordinates in all levels, including yourself.
SQL Server Magazine
—
Itzik Ben-Gan
Exploring Changes Made to SQL Server 2005's UDF Options
Here's the "input" a new option for SQL Server 2005's UDF function that speeds up the processing of NULL input. Also, SQL Server 2005 lets you use more non-deterministic functions with UDFs.
SQL Server Magazine
—
Itzik Ben-Gan
Using SQL Server 2005's New Synonym Function
SQL Server 2005 has a new synonym feature that lets you create a link in a local database that points to an object in the same SQL Server instance or in a linked server.
SQL Server Magazine
—
Itzik Ben-Gan
Don't Overlook the New SQL Server 2005 NEWSEQUENTIALID() Function
SQL Server 2005 has a new feature, NewSequentialID(), that I almost overlooked. This new function lets you generate sequential globally unique identifiers (GUIDs).
SQL Server Magazine
—
Itzik Ben-Gan
Calculating the Median Gets Simpler in SQL Server 2005
SQL Server 2005 introduced several new T-SQL enhancements that let you provide simple solutions to existing problems.
SQL Server Magazine
—
Itzik Ben-Gan
Query Data Samples in a Table
The TABLESAMPLE clause returns a random subset of rows in a table, giving you more-reasonably sized result sets in large-table queries.
SQL Server Magazine
—
Itzik Ben-Gan
Using SQL Server 2005 Features with Earlier SQL Server Versions
This helpful technique lets you use SQL Server 2005 features, such as the TABLESAMPLE clause, in T-SQL code that's run against a pre–SQL Server 2005 database.
SQL Server Magazine
—
Itzik Ben-Gan
More TOP Troubles: Using TOP with INSERT, UPDATE, and DELETE
Using the SQL Server 2005 TOP option with data-modification statements produces ambiguous results. Fortunately, you have some choices for circumventing these TOP limitations.
SQL Server Magazine
—
Itzik Ben-Gan
Making TOP Better
Itzik continues last month's discussion of SQL Server 2005's TOP option by explaining how he'd improve it and providing alternative techniques that supply TOP's missing functionality.
SQL Server Magazine
—
Itzik Ben-Gan
|
[December 20, 2005]
|
|
TOP Troubles
SQL Server 2005's TOP option has some limitations that make its use ambiguous. In this and upcoming articles in the series, learn about the new TOP's missing functionality and workarounds that address its shortcomings.
SQL Server Magazine
—
Itzik Ben-Gan
|
[November 22, 2005]
|
|
OVER Clause Simplifies Aggregate Window Calculations
Use the OVER clause in a T-SQL 2005 statement—instead of using subqueries or joins—to calculate the aggregate on a window of values.
SQL Server Magazine
—
Itzik Ben-Gan
|
[September 28, 2005]
|
|
MAX Specifier Boosts Variable-Length Data Types
Enhancements to the MAX specifier let you manipulate LOBs in a much easier and more flexible fashion than in previous SQL Server versions.
SQL Server Magazine
—
Itzik Ben-Gan
|
[September 12, 2005]
|
|
A More Versatile TOP
The TOP keyword becomes more useful in SQL Server 2005. Now you can specify an expression as an input to TOP as well as use it in INSERT, UPDATE, and DELETE statements.
SQL Server Magazine
—
Itzik Ben-Gan
|
[July 25, 2005]
|
|
SQL Server 2005's APPLY Operator
SQL Server 2005 introduces a handy new operator called APPLY, which is used in a query's FROM clause.
SQL Server Magazine
—
Itzik Ben-Gan
|
[June 27, 2005]
|
|
DML With Results
Learn to modify data and access that just-modified data for further processing in the same transaction.
SQL Server Magazine
—
Itzik Ben-Gan
|
[April 28, 2005]
|
|
Querying Partitions
Itzik Ben-Gan finished his four-part partitions series by discussing how querying partitions has improved in SQL Server 2005 when compared to SQL Server 2000--the improved partition-elimination process and the efficient collocated joins.
SQL Server Magazine
—
Itzik Ben-Gan
|
[March 31, 2005]
|
|
Maintaining Partitions
Learn how to maintain partitioned tables and indexes and when you need to add or remove partitions.
SQL Server Magazine
—
Itzik Ben-Gan
|
|
Register
