Keep It Simple Stupid
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
27 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
27 reads
Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes are very useful for data warehouse workloads and large tables. They can improve query performance...
2019-07-11 (first published: 2019-06-26)
1,278 reads
When you run a query twice, and get dramatically different run times, your first step can be to try to identify the differences in execution plans. For many that...
2019-07-05 (first published: 2019-06-19)
931 reads
In this post, we continue with another beginner’s blog of database features that may be unknown to many. Let’s take a look at filtered indexes. Many database administrators are...
2019-06-10 (first published: 2019-05-22)
767 reads
I give performance presentations at many different events to all levels of SQL Server professionals. Over time I’ve noticed that some DBAs and developers have never looked at the...
2019-05-29 (first published: 2019-05-15)
2,097 reads
Another quick post of simple changes you can make to your code to create more optimal execution plans. This one is on implicit conversions. An implicit conversion is when...
2019-04-29 (first published: 2019-04-17)
1,147 reads
I am very excited to announce I will be delivering a pre-conference session on SQL Server Performance Tuning on November 5th at PASS Summit 2019. If you have ever...
2019-04-24
87 reads
One of the easiest things to fix when performance tuning queries are Key Lookups or RID Lookups. The key lookup operator occurs when the query optimizer performs an index...
2019-04-17 (first published: 2019-04-03)
726 reads
March is Women’s History Month, to celebrate the PASS Women in Technology Virtual Group (@PASS_WIT) held a webcast featuring prominent...
2019-04-09 (first published: 2019-03-20)
1,036 reads
I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...
2019-03-13
266 reads
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Spring Connections and Learning at...
Comments posted to this topic are about the item Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers