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,224 reads
Glenn Berry
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
913 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,744 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,340 reads
Dachshunds on Patrol
I was home today, since my 3.15Kw solar PV system was being installed, so I took a few pictures of...
2010-06-05
809 reads
SQL Server 2008 and 2008R2 Diagnostic Information Queries for June 2010
This version has updated build lists for SQL Server 2008 and 2008 R2. It also has several new queries, and...
2010-06-02
1,563 reads
Submitted Session Abstracts for PASS Summit 2010
I guess I will join the trend, and list the session abstracts that I submitted for PASS Summit 2010. There...
2010-06-02
907 reads
Microsoft Announces Robotics Developer Studio 2008 R3
Last week, Microsoft released a slightly improved version of Robotics Developer Studio that supports Visual Studio 2010, and adds the...
2010-06-01
1,478 reads
Nice Shout-Out From Brad McGehee
I was browsing Twitter today, and I noticed some retweets linking to a blog post that Brad McGehee (blog | twitter)...
2010-06-01
580 reads
Troubleshooting Login Failed Errors on SQL Server 2008
While looking over my SQL Server Error logs, I noticed a small flurry of error messages like you see below,...
2010-06-01
1,271 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers