This month I conclude the series by describing the last steps in logical query processing, which handle the SELECT and ORDER BY clauses, and the TOP and OFFSET-FETCH filters.
The Issue
Recently I had someone reach out to me concerned they were about to incur an auto-grow event on a volume where they're already running low on space. They only had megabytes of space remaining on a 5 terabyte-sized data file. This ...
Kelly Lockwood Primus, SVP, Strategic Client Solutions at Leading Women, was the keynote speaker at the annual PASS Women in Technology Luncheon that took place at the recent PASS Summit. Her talk was titled Leadership, The Missing 33%TM and...
Introduction
There are not any individuals - no matter how dedicated an employee or proficient technically - that can work 24 hours per day every day of the year and every year after that year yet that is what is asked of Database Administra...
PASS Summit kicked off general sessions today after two days of full day pre-conference sessions. The day one keynote anchored by Joseph Sirosh, Corporate Vice President, Data Group at Microsoft, focused on aspects of Microsoft's data platform...
A DBCC CHECKDB operation allow you to check the logical and physical integrity of all the objects in a specific database and by default returns the results of the check to the user console when run in SQL Server Management Studio.
When I was...
Just off a fantastic IT/Dev Connections 2016 that delivered a lot of great information from industry experts on SQL Server 2016, analytics, Big Data, and R, this new free eBook from Microsoft Press should be a great companion guide.
The book...