Editor reviews are provided by professional editors who evaluate a blog based on the following criteria: Frequency of Updates, Relevance of Content, Site Design, and Writing Style.
To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and elusive goal. Although building a centralized “hub,” or enterprise data warehouse (EDW) that supports company-wide detail...
I would like to start this post with an interesting question:
Where in MS SQL Server is “100” equals to “0”? And I am not talking about data types now..
Today I will be presenting the answer to this question and some topics related to...
Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in...
Today I will keep the words very short and will convey story in three simple photographs. This post answers the question – “Do I have life outside SQL?” YES! I do and it is very beautiful.
December 12, 2009
September 1, 2009
December 12,...
When a database table grows in size to the hundreds of gigabytes or more, it can become more difficult to load new data, remove old data, and maintain indexes. Just the sheer size of the table causes such operations to take much longer. Even the data...
