What happens when you execute a query
When a query is submitted to SQL server it goes through several processing steps. A proper understanding of these steps...
2015-09-12
4,877 reads
Blog Posts
Argenis and Ryan
It’s the time of the year when PASS holds its annual elections for the board of directors. This year we...
2015-09-11
868 reads
Extended Events – Event Anatomy
As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the...
2015-09-11
15 reads
Extended Events – Event Anatomy
So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into...
2015-09-11
619 reads
Hekaton Part 6:- Hash Indexes - Intro
With SQL Server 2014, new type of Index called the hash index was introduced. Little introduction to hash function would...
2015-09-11 (first published: 2015-09-08)
2,612 reads
Where you should start when managing an enterprise
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us...
2015-09-11 (first published: 2015-09-08)
1,866 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
377 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
41 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
704 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
10 reads
Blogs
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
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...
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