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,210 reads
Blog Posts
MS TechUpdate Prishtina in Kosova (June 9, 2010)
On June 9, 2010 is held the annual event that in Prishtina is recognized as Microsoft TechUpdate. Presenters in this...
2010-06-09
1,845 reads
Option missing in NTILE function?
Just saw something interesting....we have a requirement to divide a result set into a certain number of groups that have...
2010-06-09
747 reads
PASS 2010 Submissions
Since all the cool kids seem to be posting the sessions that they submitted to the PASS Summit, nerd that...
2010-06-09
805 reads
SQL Saturday #22 - Pensacola
This was my second year going to SQL Saturday in Pensacola and once again I enjoyed it. I stayed again...
2010-06-09
342 reads
SSMS 2008 and changing a SQL 2005 SA password.
You can probably tell from some of my more recent posts that I have been doing some work lately on...
2010-06-09
1,685 reads
TechEd 2010 - A Half a Conference Recap
I left TechEd this morning, actually too early, catching a 7:12am flight from New Orleans to Denver. Which meant a...
2010-06-09
361 reads
TechEd 2010 – Afternoon
Noticed that they have ‘overflow’ rooms where they are broadcasting sessions that max out attendance, very nice. Wonder how much...
2010-06-09
628 reads
TechEd Impressions: Day Two
It’s only day two of the four day conference, and I am already exhausted from attending sessions from 8:00 AM...
2010-06-09
499 reads
A Guitar is Just a Piece of Wood
In my real-life I play guitar. Being an analytical sort-of-fella I found myself inhaling all the books, videos, advice, etc....
2010-06-08
661 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers