T-SQL Tuesday #80 – SQL Birthday Present
It’s time for another round of the global blog party we call T-SQL Tuesday. This is T-SQL Tuesday #80 and...
2016-07-12
765 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Possible Infinite Recompile Was Detected for SQLHANDLE
On one of my SQL Server instances, I see a lot of these infinite recompile messages in the SQL log....
2016-07-01
2,239 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-23 (first published: 2016-06-16)
3,511 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-17
781 reads
AG Worker Thread Blocked by Log Backup
We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email...
2016-06-15 (first published: 2016-06-06)
2,118 reads
What has 2 Thumbs and Deleted a LUN with the Log File of a Production DB on it?
That’s right, I did it. I was deleting unused LUNs and the focus somehow jumped from the LUNs for the...
2016-06-08 (first published: 2016-06-01)
2,684 reads
Attendee Questions from My #24HoP Presentation
I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate...
2016-06-02
789 reads
What is the max/min size of a decimal data type?
Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and...
2016-05-31
1,176 reads
My 24 Hours of PASS Session Files
I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of...
2016-05-27
985 reads
Why I'm not attending PASS Summit 2016
I know there has been a lot of drama in the community recently, much of it centered around what people...
2016-05-27
1,098 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