Because of its many roles, tempdb is the source of performance issues in SQL Server, and there are recommended configuration changes to mitigate this. In this article, Fabiano Amorim demonstrates another issue with tempdb performance that you probably didn’t know about.
2020-07-02
Table variables can cause performance issues with joins when they contain a large number of rows. In SQL Server 2019, Microsoft has improved how the optimizer works with table variables which can improve performance without making changes to your code. In this article, Greg Larsen explains how this feature works and if it really does make a difference.
2020-06-22
Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article, Greg Larsen explains one of the features, Scalar UDF Inlining.
2020-03-02
Window functions are more intuitive and simpler in many cases than alternative SQL methods.
2013-12-02
8,483 reads
By KendraLittle
I'm not an expert on collation in SQL Server, but there are a few...
Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
We will have backup server maintenance with the outage between 15mins to 1 hr....
Hey all, Regarding licensing of SQL server, we are considering the possibility of running...
I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I've...
Ask SSC