Fill factor for SQL pages

I recently learnt about the term Fill Factor while looking at indexing. Turns out it’s an important thing to know! So, here’s a definition I read online Fill factor is the value that determines the percentage of space on each leaf-level page to be filled…

View index details by Table

Here’s a handy script to see the indexes available on a given table. The script displays all columns associated with the index, and identifies if it is a index key column, or an include. Hopefully you will find it helpful with database tuning, as I…

Slide out footer design

Today I’m featuring an internet find! Tutorialzine.com featured a neat article on a slide out footer style. That is where the web page content seems to “slide out” above the footer area. You can see the article here.

Today I discovered an new Search Engine

I, probably like many of you, am signed up receive newsletters from various tech-related websites. These newsletters often include tips & tricks, and new emerging technologies, and are often an interesting read. Today was one of those interesting days. I was introduced to Qwant. An…

SQL Server Statistics Parser

A colleague of mine recommended the website StatisticsParser.com, which allows you to drop the statistics output from a query, and the website will gracefully format the results for you into helpful tables. Lovin’ it. For those of you who may not be aware of how…

Performing a selective rollback in VS

When you rollback a changeset, Visual Studio 2013 will check out all of the files in the changeset and tag them with the ‘Rollback’ action. You do not need to to perform the rollback on all of the files! Just undo the action on the…

Table functions with temp tables

Big surprise, its another database post! I’m working on tuning at the moment, so I guess it’s just going to be the hot topic. Anyway, today I discovered something that blew my mind a little bit. It did so due to the vast performance improvement…