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,207 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
903 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
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
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
801 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,552 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
895 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,462 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
574 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,267 reads
Blogs
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Forums
Deadlock graph anomaly
I've come across what appears to be a strange deadlock anomaly. As seen in...
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The Challenge of AI
Comments posted to this topic are about the item The Challenge of AI, which...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers