Monthly Archives: August 2013

schema for storing tags for photographs

I stumbled into this interesting article today.. I was drawn in by the first sentence A friend of mine who owns a stock photo website once told me he had designed an awesome photo auto-tagging algorithm which was 80% correct: … Continue reading

Posted in SQL Server | Tagged | Comments Off on schema for storing tags for photographs

how to tell if a column in a view is REALLY Nullable or not

I’ve been trying to setup Indexed Views (with fulltext search).. And unforunately, it was pretty tough to troubleshoot. I kept on getting messages about not precise, or nullable, and I really needed to iron out WHICH column was giving me … Continue reading

Posted in SQL Server | Tagged | Comments Off on how to tell if a column in a view is REALLY Nullable or not

SSIS Community Tasks and Components

I’m not a huge fan of BUYING third party software. I just don’t think that it’s not always worth the time, money and effort to find and install these on every machine in the house (I like standardization). I just … Continue reading

Posted in SQL Server | Tagged | Comments Off on SSIS Community Tasks and Components

Picture of me!!

Just a quick picture of Aaron Kempf.

Posted in Access, ADP, Funny, Internet Explorer, picture of me, SQL Server, Uncategorized, Web Development | Tagged | Comments Off on Picture of me!!

how to rename tables or stored procedures with spaces in the name

Nothing in this whole wide world makes my blood boil quicker than seeing table names, sproc names, etc with spaces in the name. As usual #1) Run the script #2) Copy the results into a new window #3) Run the … Continue reading

Posted in SQL Server | Tagged | Comments Off on how to rename tables or stored procedures with spaces in the name

default trace in SQL Server

founda great article on the default trace in SQL Server. The default trace in SQL Server – the power of performance and security auditing 14 March 2011 by Feodor Georgiev Since the introduction of SQL Server 2005, there is a simple … Continue reading

Posted in SQL Server | Tagged | Comments Off on default trace in SQL Server

How efficient is your database schema?

Fascinating article about compression ratio vs normalization 🙂 How efficient is your database schema? A suggestion for evaluation and an explanation thereof Posted on 7 August 2013 by anastasllc Summary: An easy way to tell how efficient your database schema … Continue reading

Posted in SQL Server | Tagged | Comments Off on How efficient is your database schema?

Column Sets – SQL 2012 and newer

For about 15 years now, I’ve been DYING to have better tools in MS SQL Server for dealing with UWDB – Ultra Wide Databases. I still don’t see why it’s not easier to do operations like ‘show me all the … Continue reading

Posted in SQL Server | Tagged | Comments Off on Column Sets – SQL 2012 and newer

REMINDER.. ROUNDING SUCKS

REMINDER.. ROUNDING SUCKS Banker’s Rounding When you add rounded values together, always rounding .5 in the same direction results in a bias that grows with the more numbers you add together. One way to minimize the bias is with banker’s … Continue reading

Posted in SQL Server, Visual Basic | Tagged | Comments Off on REMINDER.. ROUNDING SUCKS