There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc… However, not all environments allow you to use those features (eg. vendor...
2019-04-25 (first published: 2019-04-16)
1,272 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
22 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
19 reads
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data. When the data types do not match, SQL Server has to...
2019-04-22 (first published: 2019-04-09)
712 reads
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
22 reads
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
29 reads
A while back I learned that it’s possible to create temporary stored procedures in SQL Server. I never put that knowledge into practice however because I struggled to think of...
2019-04-16 (first published: 2019-04-02)
872 reads
Watch this week's video on YouTube
A while back I learned that it's possible to create temporary stored procedures in SQL Server.
I never put that knowledge into practice however because I...
2019-04-02
10 reads
Watch this week's video on YouTube
A while back I learned that it's possible to create temporary stored procedures in SQL Server.
I never put that knowledge into practice however because I...
2019-04-02
8 reads
It’s important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect. Today I want to look at what...
2019-03-26
61 reads
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Comments posted to this topic are about the item Let's Talk Certifications
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers