-
Recent Posts
- T-SQL Cryptographic Patterns – part 6: a hole in the bucket
- T-SQL Cryptographic Patterns – part 5: running the gauntlet
- T-SQL Cryptographic Patterns – part 4: parts is parts
- T-SQL Cryptographic Patterns – part 3: Dog Food
- T-SQL Cryptographic Patterns – part 2: Hotel Juliet
- T-SQL Cryptographic Patterns – Part 1: hashed, scrambled or over easy?
- Throw FORMATMESSAGE() in the SQL Server 2012 Tool Bag
- Encrypting XML Typed Data in SQL Server
- Considering Cryptography in SQL Server Database Architectures
- Repel Dictionary Attacks With Checksum Truncation of The Random lambda
- Using Authenticity, Signing, Nesting in T-SQL to Protect Sensitive Data from (even) Highly Privileged Users
- Encryption Hierarchy Administration – a T-SQL Template
- The Emperor’s New Transparent Data Encryption
- Protecting Sensitive Data at Rest in SQL Azure
- Persisting Data: part 9 – A Modest Data Collection Proposal
- Implicit conversions will find you
- Persisting Data – part 8: Concurrent Persistence Processing
- Persisting Data – part 7: Concurrency and Deadlocking
- Persisting Data – part 6: TVPs are for SSISies
- Persisting Data – part 5: Concurrency and Locking
- Persisting Data – part 4: Upsert and MERGE
- Persisting Data – part 3: Rows, Sets and Files
- Persisting Data – part 2: The Un-Indexed Heap
- Persisting Data – part 1: The “impedance mismatch”
- Monitoring the Default Trace
Tag Archives: T-SQL
Implicit conversions will find you
– two thirds minus one half SELECT 2/3 – 1/2 , 2/3 – 1.0/2 , 2.0/3 – 1/2 , 2.0/3 – 1.0/2 , ISNULL(2/3, 1.0) – .5 , ISNULL(2.0/3, 1) – .5 , COALESCE(2/3, 1.0) – .5 , COALESCE(2/3.0, 1.0) … Continue reading
Posted in Code Review
Tagged CAST(), CONVERT(), Implicit Conversions, primitive sql types, T-SQL
Leave a comment
Persisting Data – part 4: Upsert and MERGE
In part 3 test results when data is persisted to an un-indexed heap table were compared. The un-indexed heap was ideal for isolating the import – get data into the database just far enough so it is safe – operation … Continue reading
Posted in Data Loading
Tagged MERGE, T-SQL, table-valued parameters, testing, Upsert
Leave a comment
Persisting Data – part 3: Rows, Sets and Files
In part 2 of this series of “Persisting Data” posts, the effects of several database server side configuration options on the throughput capabilities for SQL Server to load rows into an un-indexed heap were examined. Reporting Services line charts depicting … Continue reading
Posted in Data Loading
Tagged BCP, staging in tempdb, T-SQL, table-valued parameters, testing
Leave a comment
