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
344 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
363 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
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
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...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers