SQL Server 2014 - Cardinality Estimator - Part 1
It has been a while since I blogged. Just moved to few other mediums like speaking at user group and...
2016-04-03
694 reads
It has been a while since I blogged. Just moved to few other mediums like speaking at user group and...
2016-04-03
694 reads
Most of us are aware of Statistics in SQL Server and its purpose. But still, just to get started, statistics...
2016-01-25 (first published: 2016-01-13)
3,201 reads
Checkpoint processes and other internal processes have undergone major changes for In Memory OLTP tables and transactions. The following article...
2015-11-18
683 reads
Finding a row count in a "in memory" Hekaton table can be a tricky task as the regular commands and...
2015-11-06
936 reads
Hash Indexes on "In memory" tables are best suited for equality searches. Reason is obvious, as they are based on...
2015-11-02
485 reads
Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What...
2015-10-25
399 reads
Continuing from previous post , this post will discuss a few scenarios on hash collisions.
The following "in memory" table with a hash...
2015-10-11
588 reads
As explained in the earlier post, a hash index places pointers to the rows in hash buckets, depending upon the value returned...
2015-09-15
689 reads
With SQL Server 2014, new type of Index called the hash index was introduced. Little introduction to hash function would...
2015-09-11 (first published: 2015-09-08)
2,585 reads
After a short little break on Hekaton series, we are now back with the 5th post.
Two new index types...
2015-09-04
719 reads
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
SQL Server 2025 introduces native support for vector data types and external AI models....
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Comments posted to this topic are about the item How to Use SQL Server...
Comments posted to this topic are about the item Choosing an AI in Sept...
Comments posted to this topic are about the item The New SQL Server 2025...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers