David Wiseman

SQL DBA. Dabble in C#. Creator of DBA Dash - open source monitoring for SQL Server.
  • Interests: Running

All authors

All authors

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...

Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join

By

This post comes off the back of my last, where I looked at issues...

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