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
• Calculating the Pearson Product Moment Correlation Coefficient in T-SQL
• 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
• Use a CrossJoin to Calculate Multiple Pearson Correlation Coefficients in T-SQL
• Using a SQL Server Case Statement for IF/Else Logic
• Using T-SQL to Perform Z-Score Column Normalization in SQL Server

• Easy way to compare SQL Server table schemas
• 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

• Pass Historical Data for Stocks from Google Finance to SQL Server
• 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 Data Mining Strategies for Stock Buy and Sell Recommendations
• SQL Server Min Max Column Normalization for Data Mining
• SQL Server Rowversion Functions min_active_row_version vs. @@DBTS
• Two T-SQL Alternatives For Tracking Changes
• Using SQL Server Data Analysis for Stock Trading Strategies
• 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
• Delete Files with SQL Server 2016 R Logic in T-SQL Code
• 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

• Implement a Comment Based Help Framework via CLR Stored Procedure

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

• Dynamically build a multi OR with LIKE query for SQL Server

• Standardize SQL Server T-SQL Code Formatting

• 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

• Introduction to Subqueries in SQL Server

• Script to Capture Performance Stats When Testing SQL Server T-SQL Statements
• 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

• Safeguard to Avoid Costly Mistakes for UPDATE or DELETE Statements in SQL Server Management Studio

• Preventing TSQL code from running on a Production SQL Server

• Advanced Use of the SQL Server ORDER BY Clause
• 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 Performance of SELECT INTO vs INSERT INTO for temporary tables
• SQL Server Temp Table vs Table Variable Performance Testing

• Handling Transactions in Nested SQL Server Stored Procedures
• 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
• Top 5 Reasons for Wrong Results in SQL Server

• 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