Learn more about SQL Server tools

 
 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

SQL Server T-SQL Tips


All Tips
 
  • Find MAX value from multiple columns in a SQL Server table
  •  
  • PowerShell Regular Expression (RegEx) Video Examples for SQL Server
  •  
  • Silent Truncation of SQL Server Data Inserts
  • Backward Compatibility
     
  • 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
  • Calculations
     
  • 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
  •  
  • Script to calculate the Median value for SQL Server data
  •  
  • T-SQL Bitwise Operators in SQL Server
  •  
  • Using T-SQL to Perform Z-Score Column Normalization in SQL Server
  • Computed Columns
     
  • 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?
  • Configuration
     
  • Determining SET Options for a Current Session in SQL Server
  •  
  • Limit amount of data returned with the SQL Server TEXTSIZE command
  • Consolidation
     
  • Integrating SQL Server Data Using Union, Case and Cast in T-SQL
  • Data
     
  • PowerShell and Text Mining Part I: Word Counts, Positions and Libraries
  •  
  • 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
  • Data Tier
     
  • Introduction to Data Tier Applications in SQL Server 2008 R2
  • Data Types
     
  • Overview of WITH RESULT SETS Feature of SQL Server 2012
  •  
  • SQL Server Bitwise operators store multiple values in one column
  • Delete
     
  • Best Practices For Deleting SQL Server Data
  •  
  • Deleting Data in SQL Server with TRUNCATE vs DELETE commands
  • Duplicate Data
     
  • Delete duplicate rows with no primary key on a SQL Server table
  •  
  • Removing Duplicates from Strings in SQL Server
  • Locking
     
  • Comparison of SQL Server Serializable and Snapshot isolation levels
  • Merge
     
  • 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
  • OUTPUT
     
  • SQL Server 2008 consume output directly from the OUTPUT command
  •  
  • Using INSERT OUTPUT in a SQL Server Transaction
  • Permissions
     
  • Minimum Permissions for SQL Server TRUNCATE TABLE
  • Pivot
     
  • 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
  • Plan Cache
     
  • Keeping data available in the SQL Server data cache with PINTABLE
  • Random Data
     
  • 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
  • Result Set
     
  • Rolling up multiple rows into a single row and column for SQL Server data
  •  
  • SQL Server 2008 Group By Sets
  • Security
     
  • Preventing TSQL code from running on a Production SQL Server
  • System
     
  • 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
  • Temp Tables
     
  • 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
  • Troubleshooting
     
  • Problem using DISTINCT in case insensitive SQL Server databases
  •  
  • SQL Server work around for Msg 2714 There is already an object named #temp in the database
  • Tutorials
     
  • 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
  • Update
     
  • Swap SQL Server column data due to inserting data into wrong columns
  • Variables
     
  • 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
  • Webcast
     
  • Free Webcast - Building blocks for managing your SQL Server code
  • More SQL Server Solutions




    Learn more about SQL Server tools