In Memory OLTP – 2

Good day everyone , In last post

In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...

In Memory OLTP – 1

In-Memory OLTP  (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL...

How to identify the source of page splits in a database

Page splits can slow down your queries and increase the amount of I/O needed to retrieve your data.
So, how do...

New Series 2 at a Time

Hi all
i have posted quite a few blogs till now, all of them were individual post except  a short series...

How to find blocked processes

Blocked processes are often a big problem for DBAs, because they’re difficult to monitor. We receive desperate calls saying “Everything...

Untrusted Check Constraints

Check constraints are useful for more than just verifying the data that goes into your tables. The query optimizer can...

SQL Server’s statistics

Again another interesting article from RED GATE …
SQL Server’s statistics provide the query optimizer with the information it needs to...

Live Query Statistics

The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option...

How to find CPU intensive queries ?

HI all
Today received the mail from RED-GATE team on this topic “How to find CPU intensive queries” . It  is an...

List Out All the SQL servers In domain

HI ALL
In One Of the Group the question was asked that How to list all the Servers in which SQL...