Currently browsing category

SQL Server Architecture

SQL Server Memory & Storage Technology

SQL Server- Understanding Server Storage Technology Explained First we need to understand the different types of memory below a.Static random access memory …

SQL Server 2008 Extended Events 3

Now lets create a New Event Session to capture Deadlock Victims IF EXISTS(SELECT * FROM sys.server_event_sessions WHERE name=’Demo_session_Deadlock’) DROP EVENT SESSION Demo_session_Deadlock …