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,324 reads
Blog Posts
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
566 reads
Managing Your Database
It seems that I see posts like this one more often than I'd like. Or at least some variation on...
2009-08-20
861 reads
Practical or Silly?
I won $25 from Thinkgeek via Intel from a twitter contest. Can you follow that? I posted a question for...
2009-08-20
1,096 reads
Things to consider...
Hi.... I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated....Cool Stuff:
1.SSMS: now...
2009-08-20
561 reads
Two Book Recommendations
I have two new books that I can heartily recommend. This isn’t a review of either book since I’ve only...
2009-08-20
569 reads
August SQL Server User Group – Near Real-time Data Warehouse
Well we had a really good meeting this week at our User Group. There were about 17 physical attendees and...
2009-08-19
853 reads
Buck Woody Joins SQLSaturday Advisory Council
Just announced at http://blog.sqlsaturday.com/2009/08/sqlsaturday-advisory-council-newest.html, Buck makes three – one more to go coming up soon!
2009-08-19
543 reads
Don’t Use USE (in SSIS, at least)
I ran into a situation this week that brought to light a subtle syntactical error I’d made in creating an...
2009-08-19
755 reads
I/O You a followup - More about I/O, Performance Tuning & Troubleshooting....
Yesterday, I blogged about basic I/O usage with some useful scripts, DMVs, and links to more in-depth details on examining...
2009-08-19
1,635 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers