Hekaton Part 6:- Hash Indexes - Intro
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,590 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,590 reads
After a short little break on Hekaton series, we are now back with the 5th post.
Two new index types...
2015-09-04
722 reads
Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at...
2015-08-31
1,276 reads
This post is my 100th post 🙂 Was inactive in blogging for few years in between. Now back in full flow....
2015-08-25
1,476 reads
Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based...
2015-08-18 (first published: 2015-08-14)
2,931 reads
Part of a Series on "Hekaton". Refer below for previous posts
Introduction to Hekaton - Part 1Creating a Hekaton Database - Part 2
Having...
2015-08-13
597 reads
With a Gentle intro done on Hekaton - In Memory tables, let us continue exploring further. Today, we will quickly create a database...
2015-08-06
546 reads
SQL Server 2014 introduced a major feature called "In Memory - Hekaton" Tables, in which even the fundamental concepts of SQL...
2015-08-04
1,079 reads
Sometimes you are in a scenario where you need to transfer a large number of databases from one server to...
2015-05-29
1,074 reads
My article on SQL Server Auditing has been published on www.SQLServerCentral.Com. Article discusses how default trace can be used effectively...
2015-05-22
597 reads
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers