Tag Archives : troubleshooting


Panic, Problems, and Plans

So what have I been up to?? Well not writing blog posts, obviously. Everybody Panic!!! Really though, I haven’t exactly been slacking off these past couple weeks.? As you may recall, one of my goals this year was to present at a SQL Saturday.? To help me towards that goal, I have my very first […]


Resource Governor causing memory problem??

So.? Last week I blogged about the experiment I was running with Resource Governor for one of our newly upgraded development databases.? I had enabled Resource Governor and created a procedure to categorize sessions, but I hadn’t set any limits and everyone was sharing the same default pool.? The plan, if you’ll recall, was to […]


Call me Ishmael

This week I’ve been chasing my own white whale.  Another developer came to me with this little problem.  A query he was trying to run over a linked server to an Oracle database was returning unexpected results.  Here’s his original query: select count(order_num) from openquery(PROD, ‘select t2.order_num from myschema.mytable t2 where open_date < to_date(”01-JAN-2011”, ”DD-MON-YYYY”) […]