SQL Server T-SQL Tips

• Concat Aggregates SQL Server CLR Function
• Multi parameter CLR aggregate in SQL Server 2005
• T-SQL: Capture Related Data and Return By Aggregates

• 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]
• Mining Time Series Data by Calculating Moving Averages with T-SQL Code in SQL Server
• Mining Time Series with Exponential Moving Averages in SQL Server
• 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 find the Greatest Common Divisor (GCD) for any number of integers
• Using T-SQL to Perform Z-Score Column Normalization in SQL Server

• SQL Server CASE Expression Overview

• Compare SQL Server Features - Decimal vs Numeric, Timestamp vs Rowversion, Unique Index vs Unique Constraint
• Easy way to compare SQL Server table schemas
• Simple T-SQL Code Comparison With PowerShell
• SQL Server IN vs EXISTS

• 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

• SQL Server Loop through Table Rows without Cursor

• A T-SQL Model for Contrasting Two Different Sets of Measurement
• 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
• T-SQL to Calculate Buy and Sell Stock Recommendations via Three Technical Indicators
• Two T-SQL Alternatives For Tracking Changes
• Using SQL Server Data Analysis for Stock Trading Strategies
• Using T-SQL to Detect Golden Crosses and Death Crosses
• Using T-SQL to find the shortest distance between two points
• Using T-SQL to Perform Decimal Scaling Normalization for SQL Server
• Using T-SQL to Refine an Analytical Model for Picking Stocks

• An Overview of Data Science for Stock Price Analysis with SQL: Part 1
• Analyzing When to Buy and Sell Stocks Using T-SQL in SQL Server
• Assessing with SQL and Data Science Goodness of Fit to Different Distributions
• Contingency Table Analysis via Chi Square using T-SQL: Part 1
• How to Compare and Combine Artificial Intelligence Models with T-SQL
• How to Find Top N Largest Time Gaps in Date Ranges in SQL Server with T-SQL Code
• Mining Stock Price Time Series with MACD in SQL Server
• One-way and Two-way Tabulation Example in SQL Server - Part 2
• T-SQL Techniques For Mapping Ceteris Paribus Variables
• Using SQL to Assess Goodness of Fit to Normal and Uniform Distributions
• Using T-SQL to Assess Goodness of Fit to an Exponential Distribution
• Using T-SQL to Detect Stock Price Reversals with the RSI
• Using T-SQL to Quantify Trend Direction and Strength
• Using Two Samples to Validate MACD with T-SQL

• Introduction to Data Tier Applications in SQL Server 2008 R2

• Overview of WITH RESULT SETS Feature of SQL Server 2012
• SQL Server Bitwise operators to 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

• Do tabs vs. spaces affect performance in SQL Server?

• 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

• Convert SQL Server Base64 Encoded Text to Images

• Simulating ON DELETE CASCADE in SQL Server
• SQL Server Insert Parent and Child Records with One Statement

• Standardize SQL Server T-SQL Code Formatting

• Find MAX value from multiple columns in a SQL Server table
• SQL Server Char Function and Reference Guide
• Write more compact SQL Server code using new features
• Write More Compact SQL Server Code Using New Features - Part 2

• SQL Server and Excel Hierarchyid Example for Organization Charts
• SQL Server Hierarchyid Data Type Overview and Examples
• SQL Server Hierarchyid Example for Bill of Materials

• 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
• SQL Server MERGE statement usage and examples
• 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

• Execute SQL Scripts on Multiple SQL Servers and Save Output as CSV Files

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

• Four SQL Server Syntax Rules I Always Follow
• Introduction to Subqueries in SQL Server

• Getting Started with SQL Server Indexing for Performance, Covering Indexes, Implicit Conversions and Parameter Sniffing
• Optimize Large SQL Server DML Processes by Using Batches
• Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches
• Script to Capture Performance Stats When Testing SQL Server T-SQL Statements
• SQL Server CTE vs Temp Table vs Table Variable Performance Test
• SQL Server Query Performance for INSERT SELECT vs INSERT EXEC
• SQL Server T-SQL Developer Best Practices Tips- Part 2
• SQL Server T-SQL Performance Best Practices Tips - Part 1
• 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
• Executing Code Every Nth Percent of the Time with T-SQL
• Generating Random Numbers in SQL Server Without Collisions
• SQL Server Function to Generate Random Numbers
• SQL Server Random Sorted Result Set
• SQL Server stored procedure to generate random passwords

• Compare SQL Server Results of Two Queries
• 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

• Execute a Command in the Context of Each Database in SQL Server - Part 2
• Execute a Command in the Context of Each Database in SQL Server using sp_ineachdb
• Generic Approach to Identify Modified SQL Server Rows
• Scripts to Build a Network of Connected Records Using SQL Server

• How to make SQL Server Wildcard Searches Faster

• 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
• Sort Alphanumeric Values in SQL Server

• A One-Way Analysis of Variance Test Add-on for the SQL Statistics Package
• A Two-Way Analysis of Variance Test Add-on for the SQL Statistics Package
• Calculating Median Absolute Deviation with T-SQL Code in SQL Server
• Finding Spreads in Data Ranges Using T-SQL
• Matrix Multiplication Calculated with T-SQL
• SQL Server T-SQL Code for the Tukey Honestly Significant Difference Test After an ANOVA
• T-Test Add-on for the SQL Statistics Package
• Using T-SQL for Finding Narrowing Ranges of Data

• Get SQL Server Row Count and Space Used with the sp_rows

• Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters

• 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

• More efficient SQL Server UPDATE for VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) data types with the WRITE Clause
• Swap SQL Server column data due to inserting data into wrong columns

• How to use @@ROWCOUNT in SQL Server
• 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