I ran into a very interesting issue with temp tables recently, when working on a case. The issue description goes something like this. We have an application preparing some SQL statements, and sending them to the SQL Database engine for execution. However...

Consider the following the scenario Scenario : SQL Server 2000 Instance             : Collation A We perform a upgrade from SQL Server 2000 to SQL Server 2005 changing the collation. After successful...

PROBLEM DESCRIPTION ================ · During upgrade from SQL Server 2008 to SQL Server 2008 R2 we might encounter an error as shown below Wait on the Database Engine Recovery Handle Failed. Check the SQL Server error log for potential...

Problem description: The BCP command with code page 65001 fails when both SQL Server 2000 and SQL Server 2005 tools are present on the server. Cause: This issues occurs because when both SQL Server 2000 and SQL Server 2005 tools are present on...

In this blog, we will discuss a scenario which is common across the SQL Server environment using certificates. With the help of another security expert, we were able to find an additional permission required for SQL service account (Non Sys admin) to...

Default Port:2383 You can change default Port for AS in msmdsrv.ini file of the Instance. Port Used by SQL Server Browser Services for SSAS is 2382 How to determine on which port AS is running? -Open Task Manager Get the PID for msmdsrv.exe -Open command...

Performance Monitor Counters has always been the "Bread and Butter" for System Engineers and Administrators alike. With each new version of Windows, Microsoft has always improved on and provided a "better than ever" performance monitors. With the performance...

Good afternoon techies! I recently worked with some customers on SQL Server 2005 login failure issues. Thought I’d make a blog post on what exactly we do @ PSS in such situations and specifically share my thoughts on login failure issues relating with...

While installing security patch KB 948109 on SQL Server 2005, the installation of the patch may fail. In order to find the cause of the failure we need to look into the setup bootstrap logs which are located in the following location, C:\Progarm Files...

BCP is a very commonly used operation and sometime very critical and failure could cause loss of operation time and inconsistent data. Below is one of the cause resulting in bcp operation failure and the error indicates some schema change issue. here...

Scenario Consider a scenario where you have a Log shipping setup with a STANDY secondary database and things are working just fine. One fine day you notice that the secondary database is not in sync with the primary. The seasoned DBA that you are, you...

With Sql server 2000 and 2005 computed columns can be use to improve the performance of queries since without the computed columns, indexes cannot be used as explained in the following blog by one of our Escalation Engineer Jack Li. http://blogs...

This is probably one of the murky topics of SQL Server. Add to this equation, hardware NUMA and the CPU Mask values can be a tough one to determine. Books Online has an article on how to configure Soft-NUMA for a SQL Server 2008 R2 instance. Rob Dorr...

SQL Server Books Online holds information on a variety of topics concerning the product which can overwhelm any user. Today, I shall demystify two parameter options for the most commonly automated DBA activity: Database Backups. SQL Server database backups...

While using Logshipping, if a servername for monitor is used which is other than the @@servername output, for example an alias, the transaction log shipping status report on the monitor server will NOT show any information about the primary and secondary...

Well I’ve looked around in our blog and it pained me to see there were no posts on Full Text Search; an often misunderstood and under-utilized feature that SQL Server provides. Wait no more, here comes the first one (of many I hope) :) . In this post...

There currently isn’t a way in T-SQL to convert UTC Time to Local time; however this seems to be a common issue people are facing. Here is how we could resolve this by writing a simple C# code and deploying it to SQL. This can easily be achieved...

While installing SP2 on the SQL server 2005, the installation may fail. Whenever the SQL server installation fails it creates a log in the following location. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\ The above location generally...

  When I first looked at encryption and hashing I found it to be the same. It was confusing. So here we would be discussing two topics 1) the basic difference between encryption and hashing. 2) How do we implement encryption and hashing in SQL server...

Below is one of the scenarios, I recently witnessed where a query was failing when executed from SSMS (SQL 2008) on windows client machine. There is no local SQL installation on the machine and had registered a remote SQL Server instance. When tried to...

Issue During an upgrade from SQL 2005 to SQL 2008 Express, the SQL Browser service failed to start, thus causing the upgrade to fail. We saw the following errors being reported in detail.txt 2010-07-23 18:49:17 SQLBrowser: SQL Server Browser Install...

Many a times you may have encountered issues related to Full Text Search functionality in SQL Server wherein you won’t be able to search words with different verb forms.  These different verb forms are also called as Stemmers. For a given language...

This blog describes a very simple but tricky issue. A Backup software was unable to take system state back up. The issue was narrowed down to a situation where the SQL Server VSS writer service fails to connect to a non existing SQL instance. When we...

We have observed a common issue which is faced by many of our  customers who export the result set from DTS package to excel worksheet. DTS package that exports results to an existing excel workbook appends the data  each time you run it. ...

Error messages: The log reader fails with the following error message: ============================================== The process could not execute 'sp_MSpub_adjust_identity' on 'PR2K8\YUKON'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help...