T-SQL Tuesday #36 SQL Community
Community – What is it?
Community is something that is improperly defined with words alone. Community is best defined through first person...
2012-11-13
869 reads
Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...
2012-11-12
1,717 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...
2012-11-12
21 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...
2012-11-12
19 reads
Summit 2012 is over, but not forgotten
What a whirlwind last week was. There were so many sessions to attend and only one of me. I needed...
2012-11-12
743 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
Reblogged from Data on Wheels - Steve Hughes: I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window...
2012-11-12
628 reads
Surface Problems With Azure
I’ve been posting about the Surface over the last couple of weeks and I’ve tried really hard to be positive...
2012-11-12
1,000 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might...
2012-11-12
1,340 reads
November 2012 – Monthly SQL Server Checklist
Last week was the PASS Summit and there were a few cool announcements made. One in particular was the release...
2012-11-12
576 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at...
2012-11-12
1,038 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