Articles

External Article

Data Control Language (aka Security)

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

External Article

The Data Center that Exploded

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: )

10,375 reads

Blogs

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

FIRST_VALUE vs. Min: #SQLNewBlogger

By

I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...

Read the latest Blogs

Forums

CPU Performance Advice in SQL Server 2005

By JoeLee

I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...

CPU Performance Advice in SQL Server 2005

By JoeLee

I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...

Duplicate Documents

By VastSQL

Hi Experts, I am trying to find duplicate documents stored in our Filestream database....

Visit the forum

Question of the Day

Subqueries II

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