SQL Community n Speaking Assignments
Dear All,
It has been a while since I became less active on this blog. Reason for the same being that,...
2016-06-12
406 reads
Nagaraj Venkatesan
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,020 reads
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
712 reads
SQL Server Statistics - Histograms
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,238 reads
In-Memory OLTP Table Checkpoint Processes Performance Comparison
Checkpoint processes and other internal processes have undergone major changes for In Memory OLTP tables and transactions. The following article...
2015-11-18
695 reads
Hekaton Part 11 :- Finding row count in memory table
Finding a row count in a "in memory" Hekaton table can be a tricky task as the regular commands and...
2015-11-06
958 reads
Hekaton Part 10: Things Hash Indexes Can do
Hash Indexes on "In memory" tables are best suited for equality searches. Reason is obvious, as they are based on...
2015-11-02
504 reads
Hekaton Part 9: Things Hash Indexes can't do
Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What...
2015-10-25
418 reads
Hekaton Part 8 - Hash Collisions - Hash_Index_Stats DMV
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
612 reads
Hekaton Part 7 - Hash Collisions & Hash Buckets
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
708 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers