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...

SQL SERVER - Data types

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

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...

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...

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...

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...

Except and Intersect

EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...

F# Type Inference

I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...

Friday Followup For January 23, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...