February 2012
M T W T F S S
« Dec    
 12345
6789101112
13141516171819
20212223242526
272829  

Try the statement later.

I got an error message I’d never seen before while altering a database.

Database is in transition. Try the statement later. (Microsoft SQL Server, Error: 952)

Try the statement later? What does that mean?

I altered a column in a test database and immediately tried to take it offline. That is when I got the [...]

Problem with a MTD query

I was running a query today and was not able to SUM by the current month. I checked the code and didn’t see any issues there, but when I looked at the variables it was pretty obvious.

DECLARE @targetdate VARCHAR(8) DECLARE @previousdate VARCHAR(8) DECLARE @currentmonth INT DECLARE @currentday INT

SET @targetdate = CONVERT(VARCHAR(8), GETDATE() [...]

Google+ Hangouts

The more I use google+, (which is not very much) the more I like it. I set up a meeting in a Hangout last week and I really think it went well. Much better than chatting or a conference call.

I usually don’t like social networking, but so good so far.

I’m going to be [...]