Can You Dig It? – Find Estimated RowCounts
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I took a few days off...
2011-01-05
383 reads
Blog Posts
Encryption and the Performance DMOs
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I...
2011-01-05
589 reads
Free e-books
I had stumbled across the free(!) Microsoft SQL Server 2008 R2 ebook, but I was also pointed in the direction...
2011-01-05
743 reads
Good People Know Good People
I can’t remember where I heard this recently, but it’s been stuck in my head as one of those bits...
2011-01-05
617 reads
My Review of SeV Revolution Jacket
Originally submitted at SCOTTEVEST, Inc.
26 Pockets are perfect for everyday and travel items; includes the TravelSmartSystem?. The SCOTTEVEST revolution began...
2011-01-05
1,635 reads
Presenting At SQLSaturday #62 - Tampa
Even though I live in Orlando - just a hop, skip, and jump away from Tampa - I've missed their SQLSaturday for...
2011-01-05
562 reads
Quick SQL Server Sessions Troubleshooting
Summary
I get lot of queries from DBA’s asking what is the quickest way to figure out issue on SQL Server....
2011-01-05
1,430 reads
2011-01-05
6 reads
2011-01-05
8 reads
2011-01-05
5 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