The Curious Engineer

All blogs / Databases

Sql Stuff

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

Ramblings of all kinds of Sql related tasks - usually related to customer questions, problems, etc. (that's what I do and all)

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
32 from 5 Jan 2007 to 17 Oct 2007
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/chadboyd/feed.xml

2007 32

  1. Moving Blog...
  2. Non-technical - big news for Chad, he's getting married
  3. sp_who for Sql 2005 (sp_who2k5)
  4. Katmai (Sql 2008) - Group By Sets
  5. Katmai (Sql 2008) - Data Compression (including Backup Compression)
  6. Katmai (Sql 2008) - The List of New Features
  7. Katmai - Did you know? Inline variable initialization and Compound assignment
  8. Katmai / Sql Server 2008 Presentations in the DC area (novaSql, caparea.net, CMAP)
  9. So you think you know SQL...Administration Part I
  10. So you think you know SQL...Concurrency and Locking
  11. So you think you know SQL...
  12. Large log backups with bulk operations and read-only databases
  13. SERIALIZABLE isolation level (serialized transactions) and duplicate key insertion attempts
  14. Non-Unique Clustered Index and Duplicate Value limits...
  15. CMAP CodeCamp in Baltimore Area
  16. NOVA Code Camp in DC
  17. PAE and /3GB and AWE oh my...
  18. What indexes are used most often (or least often) on my server?
  19. Sql 2005 Dynamic Memory Managment with AWE enabled
  20. Sorting and comparing unicode and binary data - why do I get a weird sort order?
  21. How does AUTO_UPDATE_STATISTICS_ASYNC work with Sql 2005?
  22. What is a hobt_id in Sql 2005?
  23. How can I get sysindexes information in Sql 2005?
  24. Row sizes exceeding 8060 bytes in Sql 2005
  25. SP2 Rollback requires complete reinstallation
  26. NULL database name values? Database ID of 32,767? What is going on here?
  27. sys.dm_os_buffer_descriptors aggregations
  28. How to determine service-related priviledges for Sql Server service account
  29. Finding (all the) gaps in an identity column (or any integer based column for that matter) using Sql 2005
  30. Sql Server CPU licensing, edition support, and multi-core technology
  31. Login failures connecting to new principal after failover using Database Mirroring
  32. Sql Server and the new Daylight Savings Time changes