Category Archives: Uncategorized

Monitoring the progress of CreateIndex

One of the frustrating aspects of SQL Server is the lack of progress indicators. One such command falling into this pit is CreateIndex. However, this is a great link for a solution; http://sqlblog.com/blogs/michael_zilberstein/archive/2013/10/21/51415.aspx Step 1 – Before you run the following … Continue reading

Posted in SQL Server, Uncategorized | Leave a comment

Problem shrinking tempdb – could not be moved because it is a work table page

SQL holds a lot of cached information in tempdb. Until it’s cleared it won’t allow tempdb to be shrunk. So here’s a quick script you might have some joy with (obviously be aware that you will suffer the cost of … Continue reading

Posted in SQL Server, Uncategorized | Leave a comment

How to check the progress of SQL Server Shrink Database

Periodically run; SELECT GetDate(),percent_complete, start_time, status, command, estimated_completion_time, cpu_time, total_elapsed_time FROM sys.dm_exec_requests where command = ‘DbccFilesCompact’

Posted in SQL Server, Uncategorized | Leave a comment

SQL Server – The log cannot be rebuilt because

I had the blood-drawn-from-face moments when a database stated is was ‘pending recovery’. Ultimately the transaction log file was broken. Actually I didn’t care about that because I knew it was pretty much all read-only data. So how to recover … Continue reading

Posted in SQL Server, Uncategorized | Leave a comment

Azure Table Insert, one of the request inputs is out of range

Whilst trying to insert a new row via a TableEntity derived class I hit a strange error; ‘one of the request inputs is out of range’ Looking at my object it all seemed fine to me. The problem was that … Continue reading

Posted in Uncategorized | Leave a comment

Surface Phone…what if

I’ve no insight into what is in or out of the Microsoft Surface Phone or if it even exists. However, I was thinking what could it realistically do to be game changing. Well how about this. When undocked you can … Continue reading

Posted in Uncategorized | Leave a comment

Html, CSS finally come of age?

Attended a really inspirational talk, perhaps HTML/CSS will now be about design rather than weighed down by JavaScript libraries and polyfills? Jen Simmons CSS Grid  

Posted in Uncategorized | Leave a comment