Seldom Used Indexes

On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then possibly a manager or client.  Usually this comes up...

Another Interesting Sort

In October of 2011, I shared an example of a peculiar set of sort requirements.  Today, I am going to...

Another Interesting Sort

Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:

Creative Database Naming January 2, 2020...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those cases where you are consulting or you have taken...

Table Size and Missing FK Indexes

I am bringing an oldie back with another twist.  I recently ran into the need to correlate information between a...

Table Size and Missing FK Indexes

I am bringing an oldie back with another twist.  I recently ran into the need to correlate information between a couple of different queries that I like to use....

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

Another month and another opportunity to write about an interesting topic.  This month hosting TSQL Tuesday is Argenis Fernandez (Blog...

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

Another month and another opportunity to write about an interesting topic.  This month hosting TSQL Tuesday is Argenis Fernandez (Blog | Twitter). This month, Argenis has invited us to...

What is a Favicon?

If I were to show you the tabs in the following pic without a description, would you recognize the websites...