Sequence

SELECT TOP

NULL Values and Joins

T-sql

T-SQL Tuesday #13 Roundup

Steve Jones summarizes the posts from this month's blog party.

New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string

Many times we want to split a string into an array and get a list of each word separately. The sys.dm_fts_parser function will help us in these cases. More over, this function will also differentiate the noise words and exact match words. The sys.dm_fts_parser can be also very powerful for debugging purposes. It can help you check how the word breaker and stemmer works for a given input for Full Text Search.

Nested Temporary Tables

T-SQL

Hidden Formatting Troubles with STR() (SQL Spackle)

Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it.

Printing Lengths