Limitation of In-Memory OLTP in SQL Server 2016 – TRUNCATE table not supported
Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...
2016-02-03
1,388 reads
Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...
2016-02-03
1,388 reads
Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...
2016-02-01
543 reads
Hi friends, few days back I was exploring data masking features introduced in SQL Server 2016. I got stuck in...
2015-12-14
551 reads
Hi friends, In new CTP version SQL server 2016 which is 3.0, I was trying to explore the new masking...
2015-12-10
483 reads
Hi friends, With new CTP version of SQL Server 2016 many new functionality are added and modified. As with introduction...
2015-12-08
579 reads
Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets...
2015-11-27
1,133 reads
Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into...
2015-11-26
875 reads
Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...
2015-11-23
493 reads
Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received...
2015-11-17
492 reads
Hi friends, in my previous blog we learnt that sparse column cannot be part of columnstore index. In this blog...
2015-10-26
605 reads
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers