Handle a late-arriving dimension with inferred members, preserve fact keys, fill attributes later, and report unresolved placeholders.
SQL SERVER – Pending IO request in SQL Server – DMV
How many pending IO requests are there for each MDF and LDF file? My handy script joins sys.dm_io_pending_io_requests with virtual file stats.
LocalDB: SQL Server on a Developer’s Laptop
LocalDB runs SQL Server Express engine features in a developer-friendly local process; learn how to start, connect, and recognize its limits.
SQL SERVER – Finding Latch Statistics
Which latches are waiting and for how long? The DMV sys.dm_os_latch_stats lets you find latch statistics with one simple query ordered by wait time.
geometry STNumPoints: Closing Coordinates Count Again
geometry STNumPoints counts coordinates in the spatial description. A square ring contains its closing coordinate as well as its four distinct corners.
SQLAuthority News – Stay Connected and Social Media
I finally got my faith back in social media. Here are the changes I made on Twitter, LinkedIn and Facebook to stop wasting time on the same updates.
SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)
What is the difference between COUNT(DISTINCT) and COUNT(ALL)? A student asked me at a college session, and one quick script made the answer clear.