Dates and Times in SQL Server: SMALLDATETIME
Last week I spoke about a world wary data type for storing dates and times in a single column, with...
2018-02-28
1,069 reads
Blocking Locks and Deadlocks
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...
2018-02-28
249 reads
Blocking Locks and Deadlocks
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...
2018-02-28
497 reads
Doing DevOPs for your Database? You need to start here…
I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…
In fact it...
2018-02-28
1,270 reads
New Built-in Function STRING_AGG() – SQL Server 2017
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...
2018-02-28
9,379 reads
Typing Alternative Characters
I tend to work in the US English world. I’m somewhat embarrassed to note that I really only know one...
2018-02-27
472 reads
Adaptive Joins
I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So,...
2018-02-27
1,151 reads
How to make a Database Request
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is...
2018-02-27
506 reads
Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!
Planning to Increase Cost Threshold for Parallelism
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s...
2018-02-27
1,156 reads
Productivity For The Data Pro
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate...
2018-02-27
470 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
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
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