This DMV is probably one of the most useful DMVs for developers and Business intelligence users since it describes the data type and other columnar information of the […]
administration / MSSQL / TSQL
sys.dm_db_log_space_usage
Another DMV that is available in SQL server 2012 is the sys.dm_db_log_space_usage DMV, this DMV is useful when trying to decide the current state of the Log file. […]
sys.dm_server_memory_dumps
Memory dumps are a copy of what lies in the RAM during a particular scenario such as a crash or even a manual Dump. Memory dumps are useful […]
sys.dm_os_windows_info
A minor DMV with SQL Server this particular one doesn’t really provide much information about the OS other than the version and service pack level. It is nowhere […]
sys.Dm_db_database_page_allocations()
This new DMV is basically a modified version of the DBCC IND command that is used to display the page allocations for a specific database object like a […]
At long last Pagination
MS SQL Server 2012 introduced a very nice feature for developers with the PAGINATION OFFSET Syntax. It has always been a challenge to work with pagination in MS […]
CHOOSE, Is MS really giving a choice?
In this blog we are going to talk about a little known T-SQL Command called CHOOSE. As its name suggests it allows some kind of selection to be […]
Video on MS SQL Server Partitioning
As promised here is a short video to start of the series on SQL Server partitioning. The video covers the difference between simply placing files in Filegroups with […]
MS SQL Performance tuning: – Partitioning explained
Today I am going to do a quick one hour session explaining partitioning. We will cover the difference between partitioning and placing tables in Filegroups, How to implement […]