Cumulative Update 5 For SQL Server 2005 SP3
Microsoft has released the latest Cumulative Update for SQL Server 2005 SP3, which is Build 4230. They also released a...
2009-08-21
483 reads
Keeping SQL Server Client Tools Up-to-Date
In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...
2009-08-21
1,416 reads
What happens when you use WITH RECOMPILE
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,328 reads
SQL Lunch
Baton Rouge SQL Server group leader and recent SQL Saturday host Patrick LeBlanc is putting together a new learning series. ...
2009-08-21
710 reads
Denver SSUG – AUG 2009
I attended the Denver SQL Server User Group meeting, wanting to get a chance to catch up with some friends...
2009-08-21
1,111 reads
SQL Profiler – Wild Card Filter on TextData
WARNING: This may be very obvious to most of you. However, several people that I have encountered did not realize...
2009-08-21
37,276 reads
The Kindle Update - A Month on the iPhone/iTouch
Ever since my Kindle broke, I've been reading on my iTouch for the most part. I've been using both the...
2009-08-21
776 reads
A True Sense of Community
We have a thread in our forums that many of the participants refer to as "The THREAD." It's a long...
2009-08-21
724 reads
Ideas are a work of art
When you think about it, most of us in the IT field are paid to solve problems. Sure there are...
2009-08-21
384 reads
Costco & Blueberry Muffins
You’ve probably heard of Costco, one of those warehouse type stores that sells stuff in bulk. We buy stuff there...
2009-08-20
574 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers