Explicitly Drop Temporary Tables Or Wait For Cleanup?
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t...
2018-11-07 (first published: 2018-10-29)
3,997 reads
Free Training: Videos from Tim Mitchell
I’m always on the looking our excellent training, especially free training. Tim Mitchell, Microsoft Data Platform MVP, (twitter | website) has...
2018-10-29
276 reads
Blogger Questions: What if I get a mean/rude comment?
There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time...
2018-10-29
322 reads
T-SQL Tuesday 108 Invitation- Non SQL Server Technologies
I am proud and honored to be hosting T-SQL Tuesday again. This monthly blog party started by SQL Guru Adam...
2018-10-29
327 reads
PASS Summit 2018 - Let's Hang Out! Where to Find Me
In addition to being an amazing opportunity for both technical and professional development, PASS Summit is a #sqlfamily reunion and a huge networking event. Catching up with old friends,...
2018-10-29
32 reads
A lack of foreign keys – a bad culture example.
G’day,
One of the things that I’ve been seeing more often than I would like to lately is large databases with...
2018-11-06 (first published: 2018-10-28)
3,201 reads
Step-by-Step: How to Trigger an Email Alert from a Windows Event that Includes the Event Details using Windows Server 2016
Introduction
Setting up an email alert is as simple as creating a Windows Task that is triggered by an Event. You...
2018-10-28
1,769 reads
Here Comes the New Blog. Same as the Old Blog.
Welcome to the new home of my blog! I’ve had this domain for over a year but with PASS Summit 2018 coming up soon I decided it was time...
2018-10-28
16 reads
Overview of the SQL Insert statement
This article on the SQL Insert statement is part of a series on string manipulation functions, operators and techniques. The...
2018-10-26
385 reads
I have a broken leg
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-10-25
409 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I