2024-12-06
494 reads
2024-12-06
494 reads
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
2024-12-06
In this first article, get an introduction to DAX, it's uses, and the basics of a DAX query as compared to a T-SQL query.
2024-12-04 (first published: 2020-03-26)
20,423 reads
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is where we find the data types, constraints, references and other structures that have to do with how the data stored . The DML (Data Manipulation Language) uses those declarations to change their contents or to invoke them. It does not change structures and schema objects.
2024-12-04
A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!
2024-12-04 (first published: 2014-10-31)
10,375 reads
As a Data Engineer I found myself having to learn rather more about cloud infrastructure than I had expected.
2024-12-02
2,421 reads
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
2024-12-02
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
2024-11-29 (first published: 2014-04-07)
49,009 reads
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series.
2024-11-29
Learn how to use Fivetran HVR software to ETL data into your Azure Data Lake Storage.
2024-11-27
951 reads
The post Lukáš Karlovský: I got the green light from management and built Fabric...
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
This post comes off the back of my last, where I looked at issues...
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
Hi Experts, I am trying to find duplicate documents stored in our Filestream database....
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers