Using Bulk Logged recovery model for Bulk Operations will Reduce the size of Transaction log backups – Myths & Truths

  It’s has been couple of years for me working on SQL Server and I keep coming across various SQL Server misconceptions (or say a DBA Myth). In this specific post I’ll demystify a common DBA myth around log-shipping: "In a log shipping setup, to have smaller size T-log log backups being shipped to secondary,…

0

SQL Server 2008 RTM Support Ends April 13, 2010. Time for SP1

SQL Server 2008 RTM finally reaches it’s end of support tomorrow i.e. April 13, 2010. Here’s snippet from SQL Release Services team blog: Product: SQL Server 2008 RTM Mainstream Support End Date: 4/13/2010 Extended Support End Date: Not Applicable    Options / Notes:  Technical support ends as of 04/13/2010; options for technical and/or hotfix support after…

0

How To: Improve SQL Server Management Studio Start-up Time

Hi Friends, Here’s something interesting about Management Studio 2005 (SSMS) When you launch SQL Server Management Studio 2005 on the server, it takes a couple of minutes (more than 5 mins in some case) before it  starts up and another few minutes to connect. And, you observe from Task Manager that, there are sufficient (Memory…

1

How to: Copy “Column Header” in SQL 2008 SSMS, SQL 2005 SSMS and SQL 2000 Enterprise Manager

SQL Server Management Studio 2008 SQL Server Management Studio 2008 (SSMS) has never failed to surprise me with it’s little (yet useful) enhancements. Here’s adding to the list: As a common need, you are required to Save/Copy SSMS query output to other files (E.g. Excel). This however had a limitation that you could NOT copy…

8

How to: Verify path for SQL Server Error Log Files

Hello Friends, March has been a busy month, and it is not over yet. Taking some time off to blog;  as small find “worth sharing”. While managing a SQL Server instance, there are so many different locations to look for MSSQL files, like SQL Server Error Logs. While we can easily locate path to SQL…

5