- Database Design Follies: NULL vs. NOT NULL
- What is ANSI_NULLS and why will I be glad when it finally goes away?
- Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
- The power of Grouping Sets in SQL Server
- What Happens When a Computed Column is Persisted in SQL Server?
- Improving the Quality of SQL Server Database Connections in the Cloud
- Understanding Cross Database Ownership Chaining in SQL Server
- Becoming a SQL Prompt Power User
- Bad habits : Counting rows the hard way
- Forgotten SQL Server Functions – VARP, SOUNDEX and NTILE
- Except and Intersect
- Use Caution with SQL Server’s MERGE Statement
- SELECT INTO and non-nullable columns
- Time Slots – An Essential Extension to Calendar Tables
- Using Hashbytes to track and store historical changes for SQL Server data
- Did You Know: LOB Parameters
- SQL Server 2016 : In-Memory OLTP Enhancements
- Another reason why scalar functions in computed columns is a bad idea
- Calculating Gaps Between Overlapping Time Intervals in SQL
- Loading a Text File from T-SQL
- Sparse Columns in SQL Server : Impact on Time & Space
- Overview of SQL Server sql_variant Data Type
- Using SQL Server’s Table Valued Parameters
- Different ways to make a table read only in a SQL Server database
- Making Deployments Simpler with Re-runnable Scripts
String Functions
- Finding Special Characters within Character Strings
- Concatenating Row Values in Transact-SQL
- Tally OH! An Improved SQL 8K “CSV Splitter” Function
- SQLCLR String Splitting Part 2: Even Faster, Even More Scalable
- Fastest CSV strings splitting using CLR (T-SQL vs. CLR revisited)
PIVOT & UNPIVOT
Locking
- Investigating Deadlocks
- Locking, isolation, and read consistency
- Inconsistent analysis in read committed using locking
Comments
T-SQL Coding — No Comments
HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>