Monthly Archives: June 2011

A weird result from IN (SELECT

I was recently building a query that referenced a SQL Server 2000 database on a linked server. I’m using SQL Server 2008 R2 on my end and I’m used to Intellisense suggesting the columns in the table I’m querying. Unfortunately, … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Who’s data is it?

Recently I needed to import some data from a flatfile into SQL Server. As I was creating the table for it, I tried to determine what the data actually was. There wasn’t very good documentation for it so I played … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Oracle to SQL Server

It can be hard getting back to blogging after some time off, but here goes. I moved in March/April and I’ll be unpacking for a long time, but I do want to be blogging it is just hard to find … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment