A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

What exactly does 1 unit of cost represent in SQL Query Analyzer execution plans? [ie: Subtree Cost: 41.2134] Obviously it is some form of measurement since a very simple "select @@version" is like ...

The Microsoft SQL Query Analyzer is part of the client tools that come with Microsoft SQL Server 2000 Enterprise Edition. It's designed to analyze the SQL queries that you or a program makes that ...

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...

I'm not sure it really is actually estimated because as far as I know the only way it can show you what the query plan is is by executing it. So then it really isn't an estimate. I'm sure I'm totally ...

It's not 2008 anymore. Joey details the ins and outs of upgrading these aging Microsoft servers, including licensing changes, support options and potential pitfalls. It was a simpler time. A decade ...

Microsoft will end Extended Support for SQL Server 2008 and SQL Server 2008 R2 on July 9, 2019. IT teams still running either version should start planning their migration strategies now to ensure ...