Fighting Bad Data Modeling
  • About Me
    • Musing
    • Game Guides
  • Subject Areas
    • Data Modeling
    • Databases
    • Programming
  • Resources
    • Database Conventions
    • Source Code
    • Free Data
    • Utilities
    • Slides
  • SQL Server Archive
    • Courses
      • Performance Tuning Course
      • Data Warehousing Course
    • Grade of the Steel

Category: SQL Server Archive

Shooting yourself in the foot

SELECT INTO – Moving Data From A to B

  • 2014-05-01
  • SQL Server Archive
  • 6 Comments
  • Data Warehouse, ETL, Staging
Domino pieces about to fall

High Availability, at High Speed

  • 2014-04-28
  • SQL Server Archive
  • 2 Comments
  • Architecture, SQL Server
Shooting yourself in the foot

BULK INSERT with Linux Line Endings

  • 2014-04-03
  • SQL Server Archive
  • 5 Comments
  • ETL, SQL Server
Computer Bugs

Race Condition when Creating Unique Values

  • 2014-03-19
  • SQL Server Archive
  • 6 Comments
  • Locking, MySQL, SQL Server
Computer Bugs

Curious Partition Function Behaviour

  • 2014-01-15
  • SQL Server Archive
  • 10 Comments
  • SQL Server, Tuning
SQL Server Logo

SQL Server Configuration

  • 2014-01-15
  • SQL Server Archive
  • 29 Comments
  • SQL Server, Tuning
Shooting yourself in the foot

Clustered Index vs. Heap

  • 2014-01-12
  • SQL Server Archive
  • 41 Comments
  • Keys, Patterns, Performance, Scale, SQL Server
Intel 386 CPU

One Million IOPS on a 2 socket server

  • 2012-09-27
  • Grade of the Steel SQL Server Archive
  • 22 Comments
  • FusionIO, Hardware, I/O

Running Many Batch Statements in Parallel

  • 2012-01-08
  • SQL Server Archive
  • 7 Comments
  • Async, ETL, Parallelism, SQL, SQL Server, Threading

Thread Synchronisation in SQL Server

  • 2011-11-09
  • Grade of the Steel SQL Server Archive
  • 4 Comments
  • Latching, Locking, Multi Core Programming, noSQL, Oracle, Parallelism, Scale, Spinlocks, SQL Server
Previous Page1234Next Page

Thomas Kejser

Fighting Bad Data Modeling

Recent Comments

  • Robert Valencia on Free Data – ISO Languages (CSV and Excel)
  • Khaled Helmi on Free Data – ISO Countries (CSV and Excel)Free Data – ISO Countries (CSV and Excel)Free Data – ISO Countries (CSV and Excel)Free Data – ISO Countries (CSV and Excel)Free Data – ISO Countries (CSV and Excel)
  • Rowland Gosling on Table Pattern: Rotating Log / Ring Buffer
  • Thomas Kejser on A Line in the Sand
  • Josh A on A Line in the Sand

DBA Stack Posts

11
votes
 
 
Why shouldn't we allow NULLs?
2016-04-04
3
votes
 
 
Using timestamp plus integer as primary key
2014-07-28
12
votes
 
 
Change Data Types large Live table
2014-11-07
3
votes
 
 
UPDATE a column by COUNT of another table
2014-01-08
5
votes
 
 
Shrinking old partitions
2014-12-20
Copyright © 2019 - Thomas Kejser