The Curious Engineer

All blogs / Databases

SQL in Stockholm

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

SQL Server thoughts from the support team in Stockholm

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
55 from 14 Apr 2008 to 4 Feb 2011
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/grahamk/feed.xml

2011 3

  1. The end of the line
  2. SQL Server blocking caused by database mirroring wait type DBMIRROR_DBM_EVENT
  3. Compatibility problems between DMO and SMO connectivity on newer versions of SQL Server

2010 7

  1. Extended Event to track and trace syntax errors
  2. SQL Server performance problems due to high privileged CPU time when running Windows Server 2008 R2
  3. The Forefront TMG/UAG team in Stockholm is hiring
  4. The SQL Server Support Team in Stockholm is hiring
  5. Script to run in SQL Server Agent to monitor DMVs, log results and take action depending upon results
  6. Access Denied error when running SQL Server Transfer Objects Task with a Proxy Account
  7. Troubleshooting SQL Server Management Studio with SQL Profiler and Debugging Tools – Part 3

2009 28

  1. Changed behaviour of OPTION RECOMPILE syntax in SQL Server 2008 SP1 cumulative update #5
  2. Troubleshooting SQL Server Management Studio with SQL Profiler and Debugging Tools – Part 1
  3. SQL Server Database Mirroring Pre-requisites and guidelines
  4. SQL Server 2008 SDK directory does not contain the opends60.lib file required for the creation of extended stored procedures
  5. SQL Server DMV script for monitoring USERSTORE_TOKENPERM size by token type and number
  6. SQL Server DMV script for searching the plan cache by query text, plan handle or execution time
  7. Realistic troubleshooting example of extended events (XEvent) usage in SQL Server 2008 – Part 1
  8. Troubleshooting SQL Server performance problems associated with low memory conditions – should I use sys.dm_os_ring_buffers
  9. Fixed - incorrect CPU time reported by sys.dm_exec_query_stats for parallel plans
  10. Troubleshooting SQL Server deadlocks and performance when running SharePoint
  11. Download location for SQLDIAG Perfstats DMV scripts
  12. SQL Server 2005 Error: 701, Severity: 17, State: 193
  13. SQL Server Error: 7320 Cannot execute the query "xxx" against OLE DB provider "DB2OLEDB" for linked server "xxx"
  14. New SQL Server 2008 DMV which I noticed this week - sys.dm_os_sys_memory
  15. Unable to use forced parameterization when deploying plan guides in SQL Server 2005
  16. How to Customise SQLDIAG in SQL Server 2008 to collect DBCC MEMORYSTATUS
  17. TechDays Sweden: post presentation questions and follow ups
  18. Come and say Hi at TechDays Sweden tomorrow....
  19. sys.dm_exec_query_stats DMV can report invalid information for parallel plans
  20. No SQL posts this week - skiing again!
  21. Kill with rollback estimation
  22. SQL Server Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 1
  23. Which sessionid has the most locks in a SQL Server instance
  24. Thoughts about building a SQL Server 2008 cluster in Hyper-V
  25. Problems executing maintenance plans in SQL Server 2008 - Resolved by SQL 2008 CU#3
  26. Error 29528. The setup has encountered an unexpected error while Setting Internal Properties
  27. Sample Application to test database mirroring failover
  28. Starting SQLDIAG or PSSDIAG automatically using SQL Alerts

2008 17

  1. Changes to management of 'TokenAndPermUserStore' in SQL 2005 SP3
  2. SQL Server Database Mirroring error 1443 - Connection Handshake Failed
  3. Database Mirroring Error 1418 Troubleshooter
  4. More blogs from the SQL Server Support team in Europe
  5. Problems executing maintenance plans in SQL Server 2008
  6. How to configure SQL Server database mirroring between 2 instances on a standalone server
  7. Interesting things to watch out for when using the autoclose database option
  8. Want to read some tips and tricks from the SQL Developer support team?
  9. Database Mirroring Monitor can cause large tempdb growth in SQL Server 2005 - changed behavior in SQL Server 2008
  10. New SQL Blogger from my team
  11. Non-yielding IOCP Listener - Stack Dump analysis
  12. Kayaking and tempdb file placement
  13. SQL Server Assertions and Dumps – a typical example and some proactive help
  14. Slow recovery times and slow performance due to large numbers of Virtual Log Files
  15. 1413 error when starting Database Mirroring – How many virtual log files is too many?
  16. Performance Problems in SQL Server - What data should I collect?
  17. Somewhere to start