CASE 1 Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with […]
administration / MSSQL / TSQL
sys.dm_exec_describe_first_result_set()
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 […]
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 […]