Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....
2018-09-10
18 reads
Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code,...
2018-09-10
768 reads
Are scalar functions really a bad thing?
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...
2018-09-18 (first published: 2018-09-10)
4,038 reads
Estimated Plans and Forced Plans from Query Store
While all plans are estimated plans, there is still a difference between capturing an estimated plan and looking at a...
2018-09-20 (first published: 2018-09-10)
1,766 reads
Redgate University is Growing
There isn’t a degree to be gained, but you can get a lot of information about Redgate products at Redgate...
2018-09-10
230 reads
Service Broker Target for Extended Events
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-09-20 (first published: 2018-09-10)
2,493 reads
Different Ways to Handle Deadlock in SQL Server
Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are waiting for a resource. No process can get the...
2018-09-10
24 reads
Different Ways to Handle Deadlock in SQL Server
Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are...
2018-09-10
2,779 reads
Hello Cloud Goodbye DBA
No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs...
2018-09-10
655 reads
SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run...
2018-09-10
69 reads
Blogs
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Forums
Alamat BCA KCP GAMA Telp:08218200233
Telp/Wa 62 8218200233 Gama Tower Lt. Dasar Unit B, Jl. H. R. Rasuna Said...
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers