View Detailed Profile
SQL 077 Numeric Scalar, EXP or Natural logarithm to the power of e

SQL 077 Numeric Scalar, EXP or Natural logarithm to the power of e

Explains the

SQL 078 Numeric Scalar, EXTRACT or How do I get part of DATE/TIME?

SQL 078 Numeric Scalar, EXTRACT or How do I get part of DATE/TIME?

Explains the

Compute Scalar Operator and Stream Aggregate in SQL Server

Compute Scalar Operator and Stream Aggregate in SQL Server

Looking for comprehensive, deep-dive training on

SQL 076 Numeric Scalar, CHAR_LENGTH or How many string characters?

SQL 076 Numeric Scalar, CHAR_LENGTH or How many string characters?

Explains the

SQL 083 Numeric Scalar, POSITION or What is the starting position of a sub-string?

SQL 083 Numeric Scalar, POSITION or What is the starting position of a sub-string?

Explains the

SQL 074 Numeric Scalar, BIT_LENGTH or How many bits in the strings?

SQL 074 Numeric Scalar, BIT_LENGTH or How many bits in the strings?

Explains the

SQL 084 Numeric Scalar, POWER or How do I raise a number to a power?

SQL 084 Numeric Scalar, POWER or How do I raise a number to a power?

Explains the

SQL 073 Numeric Scalar, ABSOLUTE, ABS or What are the positive values?

SQL 073 Numeric Scalar, ABSOLUTE, ABS or What are the positive values?

Explains the

SQL 080 Numeric Scalar, LN, LOG or How can I get the Natural logarithm?

SQL 080 Numeric Scalar, LN, LOG or How can I get the Natural logarithm?

Explains the

Using Scalar SQL to boost performance

Using Scalar SQL to boost performance

One the great powers of

WITH SCHEMABINDING Performance for Scalar Functions in SQL Server

WITH SCHEMABINDING Performance for Scalar Functions in SQL Server

WITH SCHEMABINDING one of those features that will speed up the performance of your queries with almost no cost...if the ...

SQL 082 Numeric Scalar, OCTET_LENGTH or How many 8 bits in a string?

SQL 082 Numeric Scalar, OCTET_LENGTH or How many 8 bits in a string?

Explains the

SQL 079 Numeric Scalar, FLOOR or How can I round values downward?

SQL 079 Numeric Scalar, FLOOR or How can I round values downward?

Explains the