Microsoft Releases SQL Server 2008 R2 RTM Cumulative Update 2
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 2 (CU2) today. It became available for download today, and...
2010-06-23
2,890 reads
Glenn Berry
Detecting and Reducing VLFs in SQL Server 2008/2008 R2 Transaction Log Files
One common, but often undetected issue that I see with SQL Server databases is a very high number of virtual...
2010-06-22
3,472 reads
Inverter Obsession, or Why I am Starting to Hate Clouds
After getting my new grid-tied solar PV system turned on and operational on June 18, 2010, I have become temporarily...
2010-06-21
767 reads
Promoted to TempDB by SQLRockstar
I noticed today that fellow SQL Server MVP Thomas LaRock (blog | twitter) had updated his SQL Server blog rankings, and...
2010-06-21
728 reads
3.15Kw Grid-Tied Solar PV System Online
I took a day off work so I could be here when Namaste Solar and IREA came out to my...
2010-06-18
867 reads
Teaching ICT 4462 – Transact SQL Programming at Denver University, University College
I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College...
2010-06-15
629 reads
How To Eliminate Key Lookups in SQL Server 2008
The Key Lookup operator is a bookmark lookup on a table with a clustered index. Key Lookups can be quite...
2010-06-09
3,208 reads
More Details About Engine Improvements in SQL Server 2008 R2 (SQLTuesday)
This post is for SQLTuesday #007, hosted by Jorge Segarra (blog | twitter). The topic is to talk about your favorite...
2010-06-08
1,732 reads
Building an Energy Efficient Workstation
Over this past weekend, I decided to build a new general purpose workstation from parts, with a goal of getting...
2010-06-08
903 reads
3.15Kw Solar PV System in Parker, Colorado
After waiting nearly seven months after I signed the contract, my little 3.15Kw grid-tied solar PV system was partially installed...
2010-06-05
1,338 reads
Blogs
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...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers