Limitation of In-Memory OLTP in SQL Server 2016 – LOB datatypes not supported
Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...
2016-02-01
532 reads
Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...
2016-02-01
532 reads
Hi friends, few days back I was exploring data masking features introduced in SQL Server 2016. I got stuck in...
2015-12-14
542 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
474 reads
Hi friends, With new CTP version of SQL Server 2016 many new functionality are added and modified. As with introduction...
2015-12-08
571 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,124 reads
Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into...
2015-11-26
869 reads
Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...
2015-11-23
487 reads
Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received...
2015-11-17
487 reads
Hi friends, in my previous blog we learnt that sparse column cannot be part of columnstore index. In this blog...
2015-10-26
593 reads
Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which made a...
2015-10-23
630 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers