The Curious Engineer

All blogs / Databases

SQL Server Engine Tips

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

Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’05’10’15’20’25
Posts
45 from 19 May 2005 to 2 Jul 2008
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqltips/feed.xml

2008 3

  1. Converting from hex string to varbinary and vice versa
  2. Converting from Base64 to varbinary and vice versa
  3. Differences between ISNULL and COALESCE

2007 8

  1. Spool operators in query plan...
  2. SQL Server 2005 SP2 Re-release and post fixes
  3. New MSDN Books Online search functionality
  4. SQL Server 2005 Performance Dashboard Reports
  5. OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL Server 2005 SP2
  6. SQL Server Performance Engineering Team Blog
  7. SQL Server 2005 SP2 has been released...
  8. Database Applications Profile Survey in https://connect.microsoft.com/sqlserver

2006 14

  1. SQL Server 2005 SP2 December CTP is available for download
  2. Download SQL Server 2005 SP2 CTP
  3. Disabled anonymous comments...
  4. Top 5 relational data warehouse performance improvements you would like to see in next version of SQL Server
  5. Top 5 OLTP performance improvements you would like to see in the next version of SQL Server
  6. Using catalog views in SQL Server 2005
  7. DATALENGTH optimizations for LOB data types...
  8. New whitepapers on physical database storage and tempdb...
  9. Troubleshooting deadlocks in SQL Server 2005
  10. Use of SCHEMABINDING option for TSQL UDFs can improve performance in SQL Server 2005...
  11. Oracle's PERCENTILE_CONT implementation using SQL Server 2005 analytic functions...
  12. Running Index Tuning Wizard (ITW) or Database Engine Tuning Advisor (DTA) on production machines...
  13. New trace flag for deadlock output and profiler deadlock event enhancement
  14. Performance tips...

2005 20

  1. Top 5 SQL/TSQL/Engine features summary of responses...
  2. Renaming logins in SQL Server 2005...
  3. Use of INFORMATION_SCHEMA views to access temp tables.
  4. Top 5 features you would like to see in the next version of SQL Server
  5. .99 US $ TPC-C price/performance benchmark for SQL Server 2005
  6. SQL Server 2005 features that are dependent on Windows Server 2003...
  7. Find Top N costly query plans in adhoc batches or modules...
  8. Request for topics...
  9. Determine primary keys and unique keys for all tables in a database...
  10. Determining optimal MAXDOP setting from TSQL in SQL Server 2005
  11. Renaming sa account in SQL Server 2005
  12. Getting SQL Server registry settings via SQLCLR table-valued user-defined function...
  13. Feedback requested on database mirroring...
  14. Ordering guarantees in SQL Server...
  15. Direct dependencies on a column...
  16. Using ANSI SQL style DECLARE CURSOR statement in UDF...
  17. OUTPUT clause in INSERT/UPDATE/DELETE statements
  18. Test linked server connection settings...
  19. Performing batched updates...
  20. Welcome !