SQL Server Optimizer Malfunction? - or just a small hurdle...

A few days ago I read Tony Davis’ blog post called “SQL Server Optimizer Malfunction?“.

In short, the blog post is about Adam Machanic’s presentation during the PASS conference claiming that the Query Optimizer is stuck in 1997.

Even though it is controversial whether PASS would be the place for expressing similar thoughts and ideas, I guess

Continue reading […] SQL Server Optimizer Malfunction? – or just a small hurdle… […]

 

How to import PDF file to SQL Server

Recently I had to import a PFD file to SQL Server database. The file contained some statistical information in the form of tables and numbers.

Here is a simple way of doing this:

 

Open the PDF file in Acrobat Reader (I used version 9.1)
Click on Save As…
Save the document as Text (Accessible) .txt
Write a SSIS package

Continue reading […] How to import PDF file to SQL Server […]