SQL Server T-SQL Tips

• Concat Aggregates SQL Server CLR Function
• Multi parameter CLR aggregate in SQL Server 2005

• Make your SQL Server database changes backward compatible when adding a new column
• Make your SQL Server database changes backward compatible when changing a relationship
• Make your SQL Server database changes backward compatible when dropping a column
• Make your SQL Server database changes backward compatible when renaming an entity

• Avoiding erroneous results when using T-SQL Trigonometric Functions in SQL Server 2012
• Calculating and verifying financial values in SQL Server
• Calculating Mathematical Values in SQL Server
• Getting a SQL Server RowCount Without doing a Table Scan
• Min-Max Normalization in T-SQL when the Boundaries are not [0,1]
• Script to calculate the Median value for SQL Server data
• Select min and max values along with other SQL Server columns using T-SQL
• SQL Server T-SQL Code to Return Consecutive Values Over a Certain Value
• Summarize Metrics with SQL Server T-SQL Code
• T-SQL Bitwise Operators in SQL Server
• The SQL Server Numbers Table, Explained - Part 1
• The SQL Server Numbers Table, Explained - Part 2
• Transforming Cartesian Coordinates to Spherical Coordinates in SQL Server with T-SQL
• Using T-SQL to Perform Z-Score Column Normalization in SQL Server

• Simple T-SQL Code Comparison With PowerShell

• Change All Computed Columns to Persisted in SQL Server
• Getting creative with Computed Columns in SQL Server
• What Effect Does Persisting a Computed Column Have in SQL Server?
• What Happens When a Computed Column is Persisted in SQL Server?

• Determining SET Options for a Current Session in SQL Server
• Limit amount of data returned with the SQL Server TEXTSIZE command

• Integrating SQL Server Data Using Union, Case and Cast in T-SQL

• PowerShell and Text Mining Part I: Word Counts, Positions and Libraries
• Query for pair-wise relationships between rows for a SQL Server table
• Reporting Techniques With SQL Server Text Mining (Part II)
• SQL Server Min Max Column Normalization for Data Mining
• SQL Server Rowversion Functions min_active_row_version vs. @@DBTS
• Using T-SQL to Perform Decimal Scaling Normalization for SQL Server

• Introduction to Data Tier Applications in SQL Server 2008 R2

• Overview of WITH RESULT SETS Feature of SQL Server 2012
• SQL Server Bitwise operators store multiple values in one column

• Best Practices For Deleting SQL Server Data
• Deleting Data in SQL Server with TRUNCATE vs DELETE commands
• Differences between Delete and Truncate in SQL Server
• SQL Server Stored Procedure to Safely Delete Data

• Delete duplicate rows with no primary key on a SQL Server table
• Removing Duplicates from Strings in SQL Server

• Find MAX value from multiple columns in a SQL Server table

• Comparison of SQL Server Serializable and Snapshot isolation levels

• Comparing performance for the MERGE statement to SELECT, INSERT, UPDATE or DELETE
• Merge parent and child SQL Server tables that use identity keys
• Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error
• SQL Server 2008 MERGE More than UPSERT
• Use Caution with SQL Server's MERGE Statement
• Using MERGE in SQL Server to insert, update and delete at the same time
• Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions

• SQL Server 2008 consume output directly from the OUTPUT command
• Using INSERT OUTPUT in a SQL Server Transaction

• Testing SQL Server Performance of Database Inserts and Updates

• Minimum Permissions for SQL Server TRUNCATE TABLE

• Script to create dynamic PIVOT queries in SQL Server
• Use SQL Server's UNPIVOT operator to dynamically normalize output
• Use SQL Server's UNPIVOT operator to help normalize output

• Keeping data available in the SQL Server data cache with PINTABLE

• A More Versatile SQL Server Random Number Function
• Generating Random Numbers in SQL Server Without Collisions
• SQL Server Random Sorted Result Set
• SQL Server stored procedure to generate random passwords

• Rolling up multiple rows into a single row and column for SQL Server data
• SQL Server 2008 Group By Sets

• Preventing TSQL code from running on a Production SQL Server

• Different Methods to Sort SQL Server Result Sets

• Calculating Median Absolute Deviation with T-SQL Code in SQL Server

• Auto Rename SQL Server Tables and Their References with PowerShell
• Dropping multiple SQL Server objects with a single DROP statement
• Renaming SQL Server database objects and changing object owners
• SQL Server Four part naming
• SQL Server sp_ prefix when and when not to use it

• New SQL Server sp_helptext to avoid line splits of code

• Create SQL Server temporary tables with the correct collation
• Differences between SQL Server temporary tables and table variables
• Exploring SQL Server 2014 Table Variables
• SQL Server Global Temporary Table Visibility
• SQL Server Temp Table vs Table Variable Performance Testing

• Problem using DISTINCT in case insensitive SQL Server databases
• Silent Truncation of SQL Server Data Inserts
• SQL Server work around for Msg 2714 There is already an object named #temp in the database

• Advice for Learning T-SQL SELECT Statement Step By Step
• New SQL Server Database Development Tutorial
• SQL Server Insert Tutorial
• SQL Server SELECT Tutorial
• Understand how SQL Server works to write better T-SQL queries

• Swap SQL Server column data due to inserting data into wrong columns

• Nullability settings with select into and variables
• SQL Server 2008 Inline variable initialization and Compound assignment
• When to use SET vs SELECT when assigning values to variables in SQL Server

• Free Webcast - Building blocks for managing your SQL Server code