Today we will be discussing how to list Total Data Pages In Memory Buffer Pool with the help of sys.dm_os_buffer_descriptors.
SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information
If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.
SQL SERVER – UDF – Validate Natural Integer Function – Simple Version
I have already blogged about validating positive integer numbers in this post (SQL SERVER – UDF – Validate Natural Integer Function).
SQL SERVER – List Database Available for Current User – HAS_DBACCESS
In those scenarios, we end up on a very elaborated training session. Let us learn today about how to List Database Available for Current User.
SQL SERVER – Add Folder Paths to the Windows Path Variable for Easy Access
I was working with a DBA and he asked me question if thee any way to Add Folder Paths to the Windows Path Variable for Easy Access.
SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention with OPTIMIZE_FOR_SEQUENTIAL_KEY
I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.
SQL SERVER Management Studio and SQLCMD Mode
Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today.