I don’t understand why Microsoft ships products that aren’t indexed properly. Using this query, it is easy to see that this simple SharePoint server – that is SLOW AS MOLASSES ON NICE HARDWARE by the way – select * From sys.dm_db_missing_index_details It just makes me cringe when I see databases that are underindexed. Ever single […]
I don’t get it.. I’ve got a couple of co-workers that are just TERRIFIED whenever they see a subquery. WHY? I’ve always loved subqueries- I think that it makes more sense to have a single distinct SQL Statement that we can test- without changing the functionality of the parent query.
This is the coolest thing I’ve found in SQL Server in the past 10 years. SQLDOM project SQLDOM is an easy and robust way to parse HTML directly into SQL tables, manipulate DOM nodes in a JQuery-like manner, and to render HTML from the SQL-based DOM. SQLDOM is written entirely in native T-SQL, and uses […]
I’ve always hated Oracle products. They just SUCK from a usability perspective – no, I do NOT want to run everything inside of a webpage!?!?! I do NOT want Java errors when I launch my DB Development studio!!!! Well– it looks like they’re finally waking up to the 90s and finally offering a decent GUI […]