Category Archives: SQL Server

Distribution database causing high disk IO, many reads / sec.

Playing around with VMWare performance data, i found a server with unusual high disk IO, and by that I mean registering around 300 MB/sec all the time. This server was a SQL Server 2008 R2 with some tables being replicated … Continue reading

Posted in DBA, SQL Server | Leave a comment

SQL Server 2008 R2 failed to install

I recently got this error when trying to install SQL 2008 R2 Developer edition (64 bit) on my Windows 7  Enterprise (64 bit) workstation: SQL Server setup has encountered the following error: msigetproductinfo failed to retrieve productversion for package with … Continue reading

Posted in SQL Server | Leave a comment

Change default Collation in SQL Server 2005

I recently had some trouble selecting the proper Collation/Sort order when setting up a new SQL 2005 installation. There was a small number of Collations/Sort Orders but not the one I needed. The official webpage for that didn’t give much … Continue reading

Posted in SQL Server | Leave a comment

Attaching database that wasn’t detached

I recently had an interesting issue where a Virtual SQL Server was deleted from VMWare, just like that with no nice shutdown and certainly no last backup & detach database commands. We were fortunate to locate and mount the data … Continue reading

Posted in DBA, SQL Server, VMWare | Leave a comment

Memory running low on SQL Server

Looking at performance counters for a SQL Server, I noticed that the Page Life Expectancy (PLE) counter was very low for this server. A quick description of PLE is how long data is stored in the memory of SQL Server … Continue reading

Posted in SQL Server | Leave a comment

Matching physical names with databases in SQL Server

Sometimes you find yourself looking for which database use a specific data file on your filesystem. This may happen when restoring/renaming a SQL database on your server and not following your naming convention. This usually ends up with different physical … Continue reading

Posted in DBA, SQL Server, Tips | Leave a comment

Change default Collation in SQL Server 2008 R2

If you, like me, have a Test SQL Server that you use to load databases from various SQL Servers, then you may find it useful to change the Default Collation for your server every now and then. Reason for this … Continue reading

Posted in SQL Server | Leave a comment

Search for text in Stored Procedures

Very handy when you are asked to create a trace for a stored procedures that update text in a specific table. Then you want a way to search fast within all sp’s in your database. SELECT distinct sysobjects.name FROM sysobjects … Continue reading

Posted in DBA, SQL Server | Leave a comment

Connecting to SQL Server with Windows Authentication to a different domain

How do you solve the problem of connecting from say your office computer in the office domain to your production environment when there is no trust between the domains? This scenario is quite common in larger companies. The reason is … Continue reading

Posted in DBA, SQL Server, Tips | Leave a comment

Selecting data from two or more tables?

Say you have one production database and an archive database for your application. A quite common setup. If you want to grab data from both tables in one single query, there are some ways to do this. you could create … Continue reading

Posted in SQL Server, Tips | Leave a comment