Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-05
3,204 reads
Blog Posts
DRP for SQL Server in French - traduction en français du plan de relève – part 3
Here is Part 3 of the translation for the French version of the Disaster Recovery for SQL Server Databases - comments...
2009-10-05
1,052 reads
How to Diagnose and Correct a “Runaway” Transaction Log
This shows you how to diagnose and correct a "runaway" transaction log. This is a very common issue that I...
2009-10-05
8,560 reads
My Journey - Part I
I've actually been meaning to write about my journey as a SQL Server professional, but kept putting it off. I...
2009-10-05
1,110 reads
My Top 10 SQL Saturday Tips
Top 10 SQL Saturday Coordination Tips
1. First and probably the most important thing is to assemble a very responsible and...
2009-10-05
1,342 reads
NY/NJ SQL Saturday Event Details - October 24, 2009
NJSQL/NYCSQL Saturday Event on October, 24th (Registration Required)
Here are the details, of my previously announced SQL Saturday event hosted by...
2009-10-05
1,267 reads
Spaces in Object Names Revisited
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
814 reads
Speaking Engagements This Week
I'll be doing three talks this week, starting tomorrow (Tuesday).
Tuesday, October 6th, Midlands PASS Chapter - Trigger Happy Database Security(PASS Summit...
2009-10-05
982 reads
SQL Lunch Starting at 11:30 AM CST 10/5/2009
TOPIC: SQL Lunch - Memory Management in SQL Server Analysis Services
If you haven’t already, go out and register for today’s SQL...
2009-10-05
730 reads
SQL Saturday #21 – Orlando
Well we are less than two weeks away from SQL Saturday #21 in Orlando, FL. My bags are packed and...
2009-10-05
531 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers