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
635 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
395 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
12 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
7 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
262 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
424 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
350 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
5 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
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers