The Curious Engineer

All blogs / Databases

Conor vs. SQL

learn.microsoft.com/en-us/archive/blogs/conor_cunningham_msft

Conor Cunningham's blog on SQL Server, data-driven applications, and pretty much whatever other random stuff he decides to post.

DatabasesPerformance / optimizationDistributed systems / cloudMicrosoft blogsMSDN archive

’10’15’20’25
Posts
87 from 23 Jul 2008 to 6 Jul 2014
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/conor_cunningham_msft/feed.xml

2014 1

  1. Conor speaking at SQL Saturday Dublin on Sept. 20, 2014

2013 8

  1. Conor vs. PASS 2013
  2. Conor vs. Premium Edition in Windows Azure SQL Database (aka SQL Azure)
  3. Conor vs. SQL Azure Optimizer Hotfix Traceflag 4199
  4. Conor vs. SQL Azure Parallel Query
  5. Conor vs. SQLBits Spring 2013 Nottingham
  6. Conor vs. SQL Injection
  7. Conor vs. Spring 2013 Conference Schedule
  8. Conor vs. Azure Architecture

2012 11

  1. New SQL Azure Features
  2. Conor vs. SQLRally Nordic 2012
  3. Conor vs. SQLBits X Slide Decks
  4. Conor vs. Traceflags
  5. Conor vs. SQL Azure Pricing
  6. Conor vs. window functions, sequence/ranking functions order-of-operations
  7. Conor vs. SqlBits Spring 2012
  8. Conor vs. SQL Azure Resource Usage
  9. Conor vs. ColumnStore Index Stats
  10. Conor vs. Distributed Query Provider Hints
  11. Conor vs. SQL Azure/SQL Server 2012

2011 11

  1. Conor vs. Extended Events
  2. Conor vs. Synergija Slide Decks
  3. Conor vs. Sinergija 2011
  4. Conor vs. Max Server Memory
  5. Conor vs. SQL Saturday Austin
  6. Conor vs. Parallel Execution Plan Contexts/Runtime Instances
  7. Conor vs. SQLBits 2011 Brighton
  8. Conor vs. SQLBits (United Kingdom)
  9. Conor vs. Map-Reduce vs. Databases
  10. Conor vs. Views/Tables
  11. Conor vs. How I got into computers…

2010 23

  1. Conor vs. more SARGable predicates
  2. Conor vs. Join Search Space
  3. Conor vs. Row Growth in Read Committed Snapshot Isolation
  4. Conor vs. PASS (Slide Decks)
  5. Conor vs. PASS
  6. Conor vs. PASS (November in Seattle)
  7. Conor vs. Optional Parameters Redux – LIKE %
  8. Conor vs. Updates – Talk (for those of you in Austin)
  9. Conor vs. Misbehaving Parameterized Queries + OPTIMIZE FOR hints
  10. Conor vs. Finding a Misbehaving Query
  11. Conor vs. UDFs in Joins
  12. Conor vs. Join Algorithms
  13. Conor vs. Anti-Semi-Join Reordering
  14. Conor vs. Index Fragmentation in Plan Selection
  15. Conor vs. Left Outer Join Reordering
  16. Conor vs. Index SARGability with complex scalar expressions
  17. Conor vs. Runtime Constant Functions
  18. Conor vs. the Search Framework in SQL Server’s Optimizer
  19. Conor vs. Optional Parameters
  20. Conor vs. SQLBits
  21. Loading Data into SQL
  22. Conor vs. Data Warehouses (an introduction)
  23. Conor vs. His Schedule

2009 17

  1. Conor vs. FOREIGN KEY join elimination
  2. Conor vs. Windows 7
  3. Conor vs. UNIQUE in Index Definitions
  4. Conor vs. Statement Offsets
  5. Server Cursors
  6. Conor vs. Stats NORECOMPUTE
  7. Conor vs. Dynamic SQL vs. Procedures vs. Plan Quality for Parameterized Queries
  8. Conor vs. Recompiles, part 2
  9. Conor vs. Recompiles
  10. Do Filtered Statistics update as frequently as normal statistics?
  11. SQL Server 2008 Internals Book Now Available!
  12. Conor vs. Isolation Level Upgrade on UPDATE/DELETE Cascading RI
  13. Conor vs. Indexed View Updates
  14. Conor vs. Non-ANSI NULLs, part 1
  15. Conor vs. MERGE and PRIMARY KEY collisions
  16. Conor vs. His Printer
  17. OPTIMIZE FOR UNKNOWN - How could that possibly make any sense???

2008 16

  1. What I learned at PASS - ETL in Queries.
  2. PASS in Seattle! W00t!
  3. Conor vs. Win2008 Hypervisor
  4. More Business Logic Validation
  5. CHECK Constraints vs. TRIGGERS
  6. PASS Community Summit 2008 - Seattle
  7. CONVERT vs. CONVERT_IMPLICIT
  8. Where's Conor?
  9. Whew! I'm done with the Optimizer Chapter for the next Inside SQL Server book!
  10. No Seatbelt - Expecting Order without ORDER BY
  11. Where's my Jetpack???
  12. Foreign Keys are our friends...
  13. Let's talk Upgrades! SQL 2000->SQL 2005, SQL 2005->SQL 2008, and service pack deployments
  14. Statistics Sample Rates
  15. Darn Gigabit switches...
  16. The Eagle has Landed...