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,203 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
902 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,729 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,336 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
798 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,550 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
894 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,459 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,266 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;