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

I’m A Friend Of Red Gate For 2015

I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate...

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

F# Type Inference

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

SQLPort’s new image

After almost 5 years of existence, SQLPort (Portuguese PASS Chapter in Lisbon) is kicking of 2015 with a renewed image...

SQL- Querying XML attributes from XML Column

Read XML column attributes in to two columns DimType and Dimvalue  from the below example also retrieve the data matching...

Looking Out for Others Helps You Lead

I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go...