SQL Server 2016 – It just runs faster SQL Server Engineer Blog Post Overview
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine...
2016-04-22 (first published: 2016-04-13)
3,052 reads
Blog Posts
Upcoming Webinars
Next week I am participating in two exciting webinars that I want to share with you!
Improve App Uptime: Tips from MVP...
2016-04-22
530 reads
Broken Left Join
Here is a simple example of a LEFT JOIN that returns the sales stats for all employees under 21.
SELECT e.Name,...
2016-04-21
577 reads
Cardinality Estimator - Part 2- Out of Date Statistics
Continuing from our series on Cardinality Estimator 2014, Let us look at the first difference between 2 CE models. The...
2016-04-21 (first published: 2016-04-12)
2,015 reads
Columnstore Indexes: Finally Awesome in SQL 2016
Columnstore indexes are amazing for optimizing the performance of large rowcount queries that would otherwise look like a SCAN operation in...
2016-04-21
662 reads
How Long Did That Job Run?
When you use the msdb tables to try to gather information on your SQL Server Agent jobs, inevitably you will...
2016-04-21 (first published: 2016-04-14)
4,221 reads
How Two PASS Chapters Join Forces to Run One SQLSaturday In Orlando
We’re lucky enough to have two PASS chapters here in Orlando, oPASS and MagicPASS. Both in Orlando, but about 40...
2016-04-21
557 reads
Loading Data into Clustered Columnstore Index with SSIS
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is...
2016-04-21
1,845 reads
Microsoft’s Commitment to Azure
For several years, many of us who were involved with working in Azure from the early days, were concerned that...
2016-04-21
534 reads
Promotions and Conflicts of Interest
I noticed my co-worker, friend, and PASS board member, Grant Fritchey, posted a note on members of the PASS Board...
2016-04-21
558 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers