How many heap tables do you have? :Quick Tips
Nothing exciting, just a general script. How can you see what heaps you have laying around?
exec sp_MSforeachdb @command1 ='
use [?]
SELECT...
2013-11-22
898 reads
DBA On The Go
Fill Factor and wasted space: Quick Tip
This is a little excessive, but here's a quick script to show you your fill factors per table that are...
2013-11-21
917 reads
Select * from * : Quick Tips
What? You want to see all of your data? Well do I have the script for you! New, Improved, Extra...
2013-11-20
462 reads
Fill Factor, Why Do You Taunt Me? Part 3
Let's look at something a bit more in depth. Let me start by saying, "Please don't arbitrarily change any default...
2013-11-25 (first published: 2013-11-19)
2,240 reads
Fill Factor, Why Do You Taunt Me? Part 2
So Friday we were discussing the idea of an idea. I think... or an idea of an idea's idea. What...
2013-11-18
1,006 reads
Fill Factor, Why Do You Taunt Me? Part 1
Like all the arbitrary numbers we hear in the SQL community such as the 30% fragmentation and 1000 pages. These...
2013-11-15
751 reads
Baseline Maintenance Statistics Job For Indexes. (say that three times fast)
This is a project I've been working on for a while. The information is all there... how it's queried may...
2013-11-14
508 reads
Can't We All Just Get Along?: Personal Development
This isn't a normal post. This one is directed to newer people, those who feel pushed around a bit at...
2013-11-13
398 reads
Index Fragmentation : Quick Tip
Fragmentation can cause issues for performance to the point of having queries not resolve at all. Your normally scheduled maintenance...
2013-11-12
434 reads
Floating Fill Factors, Automation at work!
A while back I saw a wonderful article on BrentOzar.com by Kendra Little. In the comments, Aaron Morelli mentioned that...
2013-11-11
444 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers