SQL Server Management Studio (SSMS) – Unable to detect Tape Drive

Today I was walking a customer through SQL Server database backup on tape and realized that I’m unable to view the tape drive from SQL Server Management Studio. At this time I took a pause to check the if all is well with the Tape Drive. Here’s tape drive config: •    Device – IMB Ultirum-TD3…

0

Index usage by %Like% operator – Query Tuning

Ok, so this one is interesting. I was reading an Internal DL (Distribution Group) post on tuning %Like% operator performance. I find some confusion in various places about index selectivity of ‘%Like%’ operator, and I decided to do few test myself. Hopefully test details below can help a bit: Problem Statement: – While optimizing high…

2

Understanding and Troubleshooting ‘Win2003 PF Usage’ on the server running SQL Server 2000

  I’ve been recently asked to explain the reason of high PF Usage on Windows 2003 server running SQL Server 2000 Enterprise Edition. Problem Statement: – From: OS Task Manager > Performance Tab: High value depicted in “PF Usage” graph. – On stopping SQL Server Service, the graph drops down. So does that mean that…

2

Steps to change the default location of SQL Server /SQL Server Agent – Error log files

  Recently came across a customer scenario, wherein the ‘ask’ was to change the current location of SQL Server Errorlog files to a different location. Here’s a simple way to get this done: Steps to change Location of SQL Svr Errorlog files Step 1. First, identify the current location of SQL Server Errorlog files. Refer…

0

How to: Archive more that six SQL Server Error Logs using SSMS / EM

The following post describes how you can configure your SQL Server to archive more than six Errorlog files using SSMS (2008, 2005) or Enterprise Manager GUI. While I was aware of MS KB # 196909, that describes a way of increasing the number of SQL Server error logs, by way of Registry change, I was…

1

Backup and Restore SQL Server Database to a network shared drive

Hello All, You have a situation wherein you want to backup SQL Server database to a network mapped drive. So all you thought of doing is mapping the drive from Operating System with a Drive Letter. Now you tried taking the backup from SSMS backup GUI, however you cannot view the network mapped drive. As…

3

SSMS Error “HRESULT: 0x80131040” encountered while opening a Table in Design-View

Hello, April 09, has lot more than expected. During my usual stuff, I was trying to open a table in “Design” view, I got this error TITLE: Microsoft SQL Server Management Studio —————————— The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (SQLEditors) Analysis: Started my search on the…

1

Unable to Drop Data-File – Error: Time-out occurred while waiting for buffer latch type 3

Hello All, This month have been filled with interesting and thought provoking issues. Here’s a new one In a recent scenario, I tried dropping a “secondary” data-file in SQL 2005. Got below error TITLE: Microsoft SQL Server Management Studio —————————— Drop failed for DataFile ‘test1dat4’.  (Microsoft.SqlServer.Smo) —————————— ADDITIONAL INFORMATION: An exception occurred while executing a…

1