Monthly Archives: September 2015

Full Text Search on Varbinary (max) Columns and using the Right filters

By | September 29, 2015

I love Full text search in MS SQL Server. Although I haven’t seen it being used a lot in client locations, I do use it a lot within my own company as well as for some of my clients who have very specific requirements. One of the more common requirements we find is document search.… Read More »

Have Databases become a glorified versions of EXCEL?

By | September 28, 2015

Recently I was having a discussion about how coding and design patterns have changed in RDMBS and if we can still call it RDBMS anymore. Very early in my career while attending an interview I was asked what a relational database is, my answer was “anything that stored data in a row and column format… Read More »

Why VW emissions fraud is a good thing for climate change.

By | September 24, 2015

What does 51700 kilotons have to do with this post? That is the min total CO2 Emissions/year from the 11 Million cars that VW says had the cheating device. So what do the below countries have in common? They each produce an estimated 51700 kt of CO2 emissions annually. VW and the fraud that happened,… Read More »

Video on Performance tuning memory allocation and spill issues

By | September 20, 2015

I was inspired by a recent article I read on parameter sniffing to add my own contribution to the topic, I explain how tempdb spools occur due to poor memory grants and they impact of parameter values in determining how much resources are allocated. I then go on to cover two different ways that the… Read More »

VM and IP Configurations

By | September 18, 2015

Recently there was a post on DB mirroring not working on a VM, in the post I had suggested checking the network connectivity and NIC configurations in the VM software since there are different ways that the VM software assigns IP to the Virtual devices. For the purpose of this post I am using VMware… Read More »

Suspect MSDB and no Backups

By | September 18, 2015

Yesterday I got a call from a client about MSDB being suspect after a drive failure. Unfortunately the client didn’t have any backups. Now the correct and best option is to use a backup and restore the database. This way you don’t lose any of the jobs and other configurations that you may have set… Read More »

SQL Server is an awesome product.

By | September 16, 2015

While I might seem biased in my choice of wording for the title, the fact is SQL Server is an awesome product. If you looking for actual numbers click here. MS SQL Server is the top OLTP and among the top DW RDBMS. More importantly you see that SQL server provide everything you need to… Read More »

The History of War Analyzed

By | September 9, 2015

War is an ugly topic, but I wanted to know if we have learnt anything from history and so I downloaded the data for all the wars since 1900 till date to get an understanding of how things have changed. The below chart shows the duration in years on the x axis and the count… Read More »