Monthly Archives: June 2011

I use WordPress for this blog

I first tried WordPress for blogging a couple of years ago and liked it so much that I currently run all my blogs on WordPress. I like it so much I even run my friends blogs on WordPress! This blog … Continue reading

Posted in Linux, 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

Search for Column in SQL Server

This is really useful if you get an error message complaining about a column and you don’t know where or if that column exist. Lets find it using the query below! Search for Column Name SELECT * FROM INFORMATION_SCHEMA.COLUMNS (nolock) … Continue reading

Posted in SQL Server | Leave a comment

Progress of DBCC CHECKDB

Run this to find out progress for dbcc checkdb select percent_complete, command , start_time from sys.dm_exec_requests where command like ‘%dbcc%’ You can also find out progress for long running backups and more! select percent_complete, command , start_time from sys.dm_exec_requests where … Continue reading

Posted in SQL Server, Tips | Leave a comment

Errors when editing a SQL Server Agent job in SQL 2008 R2

Creating an instance of the COM component with CLSID. Do you get this when editing jobs in SQL Server Agent? Then install the latest CU, currently CU 6 for SQL Server 2008 R2. After installing this it fixed my SQL … Continue reading

Posted in SQL Server | Leave a comment