The Curious Engineer

All blogs / Databases

Varun Dhawan's Blog

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

Hands-on with SQL Server

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
30 from 22 Dec 2008 to 16 May 2011
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/varund/feed.xml

2011 3

  1. Moving From MSDN To WordPress :: New Blog URL
  2. SQL Server 2005 SP4 RTM Release………what it means with RTM or without RTM?
  3. Using Bulk Logged recovery model for Bulk Operations will Reduce the size of Transaction log backups – Myths & Truths

2010 9

  1. SQL Server Denali - AlwaysON (HADR): Step-by-Setup setup guide
  2. Microsoft Codename Atlanta::How to get in there….
  3. Create a SQL Server Database on a network shared drive
  4. TRANSACTION LOG BACKUP and RESTORE SEQUENCE: Myths & Truths
  5. SQL Server 2008 setup Error - Microsoft .NET Framework 3.5 installation has failed. I know i have it installed already!
  6. Steps to create merged (Slipstream) to Install SQL Server 2008 RTM + Service Pack 1 + Cumulative Update
  7. DB Maintenance: Rebuild Index Task always fails on OperationsManagerDW [SCOM database]
  8. SQL Server 2008 RTM Support Ends April 13, 2010. Time for SP1
  9. End of Support for SQL Server 2005 SP2. Buckle up for SP3

2009 15

  1. SQL Server Management Studio (SSMS) – Unable to detect Tape Drive
  2. Index usage by %Like% operator – Query Tuning
  3. BCP command fails with ERROR:"User name not provided…", when both SQL Server 2000 and SQL Server 2005 Tools are installed on machine
  4. Understanding and Troubleshooting ‘Win2003 PF Usage’ on the server running SQL Server 2000
  5. Steps to change the default location of SQL Server /SQL Server Agent - Error log files
  6. How to: Archive more that six SQL Server Error Logs using SSMS / EM
  7. Error “Failed to open a file. Access is denied”, when attempting to open SQL 2005 Profiler Trace
  8. Backup and Restore SQL Server Database to a network shared drive
  9. SSMS Error “HRESULT: 0x80131040” encountered while opening a Table in Design-View
  10. Unable to Drop Data-File – Error: Time-out occurred while waiting for buffer latch type 3
  11. How To: Improve SQL Server Management Studio Start-up Time
  12. How to: Copy “Column Header” in SQL 2008 SSMS, SQL 2005 SSMS and SQL 2000 Enterprise Manager
  13. How to: Verify path for SQL Server Error Log Files
  14. Lock Pages in Memory in SQL Server 64-Bit
  15. Benefits of Backup Compression - Faster BACKUP / RECOVERY

2008 3

  1. How to identify weather a Database Backup Set was compressed using WITH COMPRESSION
  2. SQL Server 2008 Backup Compression
  3. My First Blog – Welcome All