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,212 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
806 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
629 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
662 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU SEMARANG Call CSO; (+62 821°3111°179
Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
BCA KCU THAMRIN Call CSO; (+62 821°3111°179
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
BCA KCP Wonogiri Call CSO; (+62 821°3111°179
Jl. Jend. Sudirman No.233, Cubluk, Giritirto, Kec. Wonogiri, Kabupaten Wonogiri, Jawa Tengah 57611
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers