SQL Server Internals

/Tag:SQL Server Internals

Free SQL video: SQL Server 2014 New System Objects

Hi Friends, In this video, I am demonstrating how you can figure out the SQL Server 2014 new System Objects in any version of SQL Server, yourself! Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation [...]

By |September 3rd, 2014|SQL Server Videos|0 Comments

Free SQL video: SQL Server Trace Flag 3608

Hi Friends, In this video, I am demonstrating an interesting behavior with SQL Server Trace Flag 3608. Get new content directly in your inbox - Click here You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to download video resources (presentation & demo code). Hope the video was worth your time. [...]

By |September 3rd, 2014|SQL Server Videos|2 Comments

sqlservr.exe file size mystery

Hi Friends, File size of sqlservr.exe in SQL Server 2008 – approx. 56 MB File size of sqlservr.exe in SQL Server 2008 R2 – approx. 60 MB I don’t have a SQL 2005 instance handy at the moment, but I guess the size would be less than 50 MB. Now, with SQL Server 2012, the [...]

By |May 15th, 2014|SQL Server|0 Comments

SQL Server Statistics Histogram- How to Decode? (Statistics Internals)

Hi Friends, Here is a short explanation of the SQL Server statistics histogram. I am using AdventureWorks2008R2 database. There is a table Sales.SalesOrderHeader with a column TotalDue. Let us have a look at that column. USE AdventureWorks2008R2 GO -- first observe the rows select TotalDue from Sales.SalesOrderHeader GO select DISTINCT TotalDue from Sales.SalesOrderHeader GO You [...]

By |May 5th, 2014|SQL Server|2 Comments

SQL Server Dynamic Index seek operation

Hi Friends, Indexing is a wonderful thing. We all know about Index scans and seeks. Today I want to talk about SQL Server dynamic index seek operation. I find it tough to explain in words so I will straight away use an example without further ado ! Suppose you run the following query (turn on [...]

By |May 2nd, 2014|SQL Server|1 Comment

SQL Server 2008 Partition Level Locking

Hi Friends, I have posted an article on SQL Server 2008 partition level locking. You can browse it here: http://sqlservergeeks.com/articles/sql-server-bi/73/sql-server-2008-%E2%80%93-partition-level-locking This article demonstrates partition level locking behaviour which is new in SQL Server 2008 onwards. Locks are escalated from ROW to TABLE by default. But the default option can be changed to escalate ROW locks [...]

By |April 24th, 2014|SQL Server|0 Comments

SQL Server 2014 New System Objects – Figure It Out Yourself

Hi Friends, In this post I want to show you how you can find out SQL Server 2014 New System Objects, yourself! From SQL Server 2014 VM (or a physical box), add a Linked Server connection to a SQL Server 2012 VM (or a physical box) And execute the following script: SELECT a.NAME sql14_objname ,a.xtype [...]

By |March 15th, 2014|SQL Server|0 Comments

SQL Server 2014 new DMV – Figure It Out Yourself

Hi Friends, In this post, I am demonstrating how you can figure out SQL Server 2014 new DMV, yourself! From SQL Server 2014 VM (or a physical box), add a Linked Server connection to a SQL Server 2012 VM (or a physical box) And execute the following script: SELECT a.NAME sql2014 ,b.NAME FROM sys.sysobjects a [...]

By |February 15th, 2014|SQL Server|0 Comments