Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of being a guest Author and explain Azure storage options. I cover types of storage accounts,...
2019-11-20
132 reads
I am very excited to be heading to PASS Summit 2019 in Seattle next week. It’s one of my favorite weeks of the year. Getting to hang out with...
2019-11-01
16 reads
Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me and elicited a strong reaction from myself. It got me thinking I need to write...
2019-11-08 (first published: 2019-10-22)
1,542 reads
Query hints are always about tradeoffs—typically you are giving up something, such as flexibility, to achieve more consistency, or very specific performance characteristic. One example of this migt when...
2019-10-29 (first published: 2019-10-16)
999 reads
Speaking Engagements Check out my new Event Calendar, to see my upcoming and past speaking engagements. You can catch me at various events throughout the year. If you are...
2019-10-15
8 reads
I’ve written about statistics in SQL Server a few times now. Through conversations I am reminded that not everyone keeps their table statistics up to date. Keeping your statistics...
2019-09-26 (first published: 2019-09-18)
496 reads
It is widely known that I am a horrible speller and hate to type code. I tend to use a lot of code snippets and reuse code to avoid...
2019-09-20 (first published: 2019-09-11)
1,255 reads
Several times I’ve been asked what tools are in my performance tuning and SQL Server management arsenal, so I decided to just create this blog to list them out...
2019-09-04
429 reads
Indexes can be incredibly beneficial to your database performance; however, they do come with a cost—indexes both consume storage space and affect insert performance. Therefore, it is important as...
2019-09-11 (first published: 2019-08-28)
2,765 reads
Some of us take days and weeks to write a blog, while others can take two minutes and write a great blog *cough* *cough* Denny (B|T). Why is that?...
2019-07-24
25 reads
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
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...
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
Hey All, My setup is as follows: Table with Clustered Index on ID col....
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
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