The Curious Engineer

All blogs / Databases

Sakthi's SQL Server Channel

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

A window to express my views about SQL Server Database Management System.

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
41 from 26 May 2010 to 25 Jan 2018
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlsakthi/feed.xml

2018 1

  1. User realm discovery failed from ADOMD

2012 8

  1. Error: "Could not retrieve backup settings for primary" in Log shipping Backup job
  2. Wow... We have MAXDOP calculator for SQL Server... It makes my job easier...
  3. SQL Server 2012 Upgrade Technical Guide & What's new Whitepaper Released
  4. INF:What happens to a database when transaction rollback fails?
  5. "Failed to save Local Policy Database" while granting any privilege to SQL Service SID in Group Policy Editor
  6. "stop before startup" after "Using large pages for buffer pool" during SQL Server startup
  7. Restore database stuck at 90% waiting on PREEMPTIVE_OS_WRITEFILEGATHER
  8. Re-configure Replication after restoring publication database from Backup - Replication Scenario

2011 25

  1. Now Connect PHP website running in Linux Apache Webserver to SQL Server
  2. Snapshot replication fails after adding a column to a table (article)
  3. OPTIMIZE FOR UNKNOWN in SQL Server 2005
  4. Error: 17127 "No memory for kernel buffer hash table" during startup along with FAIL_PAGE_ALLOCATION 262
  5. Large Network Packet Size and Memory Pressure in SQL Server
  6. How to troubleshoot - "Incorrect syntax near - Source: MSSQLServer, Error number: 102)" errors in replication
  7. -MaxBCPThread parameter for Snapshot and Distribution Agent in SQL Server Replication
  8. Error: 18056 State: 29 The client was unable to reuse a session. The failure ID is 29 after upgrading SQL 2000 to SQL 2008 SP2
  9. Video Tutorial on Managing Virtual Log Files (VLF) in SQL Server
  10. AUTO_CLOSE and performance issue in a .NET application
  11. SQLSPIDAnalyzer.sql - My way of monitoring a particular request in SQL Server
  12. Best Performer: Distributed query (Four-part) or OPENQUERY when executing linked server queries in SQL Server
  13. What is WRITELOG waittype and how to troubleshoot and fix this wait in SQL Server
  14. Service Broker "Fire and Forget Scenario" and Memory Allocation failure
  15. Max. Worker Threads and when you should change it
  16. Importance of setting Max Server Memory in SQL Server and How to Set it
  17. "Show Server Trace" Feature for SQL Server 2005 to analyze Stored Procedure and T-SQL Execution
  18. T-SQL Query Script to monitor Memory Usage of a SQL Server Instance
  19. Query to find what modules are loaded inside SQL Server VAS (Virtual Address Space)
  20. Difference between KILL and KILL WITH STATUSONLY – Estimate Rollback completion time
  21. Convert Page ID offset address to Page Number
  22. Troubleshooting slow running query using Extended Events Wait info event
  23. Troubleshooting SQL Server I/O requests taking longer than 15 seconds - I/O stalls & Disk latency
  24. Different Status of a SPID in SQL Server and What do they mean
  25. Troubleshoot Connectivity/Login failures (18456 State x) with SQL Server

2010 7

  1. Script existing server side trace to create a new trace with same definition
  2. Login failed for user 'sa' while installing SQL Server 2005
  3. Rule "Same architecture installation" failed while installing SQL Server 2008 R2
  4. "Wait on the Database Engine recovery handle failed" while installing SQL Server 2008
  5. How to define backup interval for Full, Differential, TLog
  6. Who is connected when in Single User Mode
  7. Welcome to my MSDN Blog