Geeks With Blogs

Arthur Zubarev Compudicted October 2014 Entries
Getting Started with Impala by John Russell, O’Reilly Media Book Review
Impala is a recent, but very valuable addition to the Hadoop ecosystem. I must say (after reading the book) Cloudera made a big step forward in the right direction. The rational behind bringing Impala to life is the proliferation of SQL. SQL as a language has many flavours, but in one form or another is already known to data practitioners coming to Hadoop from various platforms and DBMS. Impala implements a subset of ANSI-92 SQL specification, regardless, even the subset is powerful enough to make ......

Posted On Friday, October 24, 2014 1:55 PM

How to get maximum row size of a SQL Server table
I am doing a lot of ETL work (typically) and one of the particulars I want to know planning my packages design is the maximum length of a table row. Just to expand further, it is often prudent to know the row size for future performance or for capacity planning. So, without further ado, here is the SQL code (works on SQL Server 2005 and onward): 1: DECLARE @table_name NVARCHAR(115), 2: @1stCol NVARCHAR(115), 3: @sql NVARCHAR(MAX); 4: 5: -- Initialize the table name to sample 6: SET @table_name = ......

Posted On Friday, October 3, 2014 11:55 AM

Copyright © Compudicted | Powered by: