The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
11 reads
Si vis pacem, para sql
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
634 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
394 reads
ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017
You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with the MEMORY_OPTIMIZED option set to ON. Like...
2016-06-06
11 reads
ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017
You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with the MEMORY_OPTIMIZED option set to ON. Like...
2016-06-06
5 reads
ISJSON() restriction in SQL Server 2016 and not in SQL Server 2017
You should have a database on SQL Server 2016 instance with an In-Memory file group so that you can create...
2016-06-06
261 reads
ISJSON() restriction in T-SQL 2016
Have a database on SQL Server 2016 instance with an In-Memory file group so that you can create tables with...
2016-06-06
423 reads
SSMS new feature - Showplan comparison
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans...
2016-06-02
349 reads
Showplan comparison
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option...
2016-06-02
4 reads
Showplan comparison
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option...
2016-06-02
3 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers