Query Tuning Near You
It really is so much easier to just throw hardware at badly performing databases. Just buy a bigger, faster server...
2014-03-19
1,190 reads
The Scary DBA
Finding Mistakes
Ever had that moment where you start getting errors from code that you’ve tested a million times? I had that...
2014-03-18
782 reads
SQL Saturday: You can’t have it all.
SQL Saturday’s are awesome! Let’s get that clear up front. The organizers of SQL Saturday events are glorious individuals. Let’s...
2014-03-17
673 reads
sp_updatestats Is Not Smart
No, I don’t mean the use of sp_updatestats is not smart. It’s a fine, quick mechanism for getting statistics updated...
2014-03-11
1,125 reads
Speaker of the Month, March 2014
This never gets easier. I was able to attend a bunch of sessions in the last month from a number...
2014-03-07
874 reads
Let’s Talk Query Tuning
I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively...
2014-02-27
1,285 reads
SQL Intersection, Spring 2014
I am terribly jazzed to be involved with this amazing event, SQL Intersection. It’s featuring some truly amazing speakers presenting...
2014-03-04 (first published: 2014-02-26)
1,634 reads
Approachable? Sometimes.
Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for...
2014-03-06 (first published: 2014-02-25)
1,848 reads
The CASE Statement and Performance
In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...
2014-02-25 (first published: 2014-02-18)
6,545 reads
SQL Server 2014 and the New Cardinality Estimator
Cardinality, basically the number of rows being processed by an operation with the optimizer, is a calculation predicated on the...
2014-02-12
1,175 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers