Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
One of the features of SQL Server 2008 that...
2010-04-23
3,275 reads
Increasing deadlocks with NoLock
One of my personal pet issues is with inappropriate use of the NOLOCK hint (and read uncommitted) . Don't get me...
2010-04-23
771 reads
Script of the week
Every week I will scour the internet for useful SQL scripts and post my favorite on here.
This weeks comes from...
2010-04-23
404 reads
A DMV a Day – Day 23
The DMV for Day 23 is sys.dm_os_process_memory, which is described by BOL as:
Most memory allocations that are attributed to the...
2010-04-23
2,411 reads
Book Review: Knives at Dawn: America’s Quest for Culinary Glory at the Legendary Bocuse d’Or Competition
Another find from the new book shelf at the local library, Knives at Dawn: America’s Quest for Culinary Glory at...
2010-04-23
481 reads
Rules to Live By: Do the Hard Things First
I can’t say I stick to this one 100 percent of the time, but it’s definitely a deeply held belief....
2010-04-23
517 reads
Adding Administrator
I installed a new VM with SQL Server in it, along with Win 7 and Reporting Services. The plan was...
2010-04-23
802 reads
Book Review - Rework
I have been a fan of 37 Signals for some time, and I read their blog regularly. I think they...
2010-04-23
802 reads
Presenting at 2010 European PASS – Sort Of
I was so looking forward to the trip to Germany to speak at the European PASS Summit
on April 22nd. Two...
2010-04-23
425 reads
Results of Microsoft Certification Poll
In a recent poll at www.bradmcgehee.com, I asked website visitors if they had any Microsoft SQL Server certifications, and if...
2010-04-23
1,202 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers