SQL Script to find the missing indexes

Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the...

new LinkedIn article

Hi everyone,
I just published a new LinkedIn article entitled “Let It Go”. Please check it out!
https://www.linkedin.com/pulse/let-go-chuck-boyce

SQL SERVER - Data types

In relational database, we store data in tabular form where data is divided into columns. Each column has a name...

Profiling Entity Framework 6 Queries

Entity Framework 6 introduced some API hooks that you can use to monitor log queries that Entity Framework is generating...

Script for compressing a database

When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...

Script for compressing a database

When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...

Script for compressing a database

When you have to compress a database you’d better first see the consideration for the compression.
This is a script that...

SQL Server - Convert() function

Convert () function in SQL Server to convert an expression from one data type to another data type

Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression...

Compress that database

When you have to compress a database you'd better first see the considerationfor the compression.This is a script that I...

Video: A Better Way to Reindex

Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...