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 [...]
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. [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
