Monday, August 22, 2016

SQL Server Heap Structure shows many IO than expected

›
It is very rare to see a table with Heap Structure  as it is not a common practice but we still find such tables with some implementations...
Sunday, August 21, 2016

SQL Server Brain Basher of the Week #051 - SQL Server 2016

›
SQL Server 2016 is released and many have started using it. Here is a simple question on SQL Server 2016; True or False: SQL Server 20...
Friday, August 19, 2016

How to Recover Deleted Tables in SQL Database [Guest Post]

›
This post is written by: Priyanka Chouhan Priyanka Chouhan is a technical writer in " Stellar Data Recovery " with 5 years of...
4 comments:
Thursday, August 18, 2016

NoSQL, Not only SQL, NewSQL: Are they same?

›
Last year, I wrote a post on NoSQL Document Database:  What is NoSQL Document Database? What is Azure DocumentDB? , that speaks about Docu...
Sunday, August 7, 2016

SQL Server Brain Basher of the Week #050 - SSRS Client Printing

›
Here is the weekly question on the SQL Server for improving your knowledge for facing interviews. This time, let's talk about an area o...
Saturday, August 6, 2016

The shared dataset definition is not valid. Details: The required attribute 'Name' is missing

›
Are you experiencing this error when trying to deploy a shared dataset?  This has been mentioned in several forums and considered ...
Thursday, August 4, 2016

Generate aggregates for different levels in the same queries without using sub queries

›
While analyzing a query written for a report, I noticed a query that has been written for getting aggregated values on a same column but u...
Wednesday, August 3, 2016

Arithmetic overflow error converting expression to data type int - It works for larger number but not for a smaller number

›
One of my colleagues sent me a simple code that has two lines. The first line works without any issue but second throws an error. This is ...
Tuesday, August 2, 2016

SQL Server Variable Assignment - SET or SELECT?

›
Declaration variables and assigning values in different ways is something we see as a very common code in modules like stored procedures a...
Sunday, July 31, 2016

Dimension Loading: Source sends same record with different Source ID

›
An interesting question was raised during my lecture today and it was related to dimension loading. The question was; how can we identify ...
Saturday, July 30, 2016

SQL Server Brain Basher of the Week #049 - SSIS Package Store

›
Let's talk about Integration Services in this week for Brain Basher. SQL Server supports two deployment models named Package Deploymen...
Friday, July 29, 2016

Fact Loading: Switching a loaded temporary table into an empty partition of the fact table

›
Fact table in data warehouses are always partitioned and with most of solutions, it is partitioned on a date key. Generally, we use SSIS f...
Thursday, July 28, 2016

SSIS - Fact Loading with Dimension Type II and Dimension Type I

›
The Dimensional Modeling in data warehousing, either using Star or Snowflake schema is still the most famous structure applied and widely ...
Wednesday, July 27, 2016

What is Table Value Constructor?

›
I am sure that many have used this without knowing the term. However it is always better to know the term before applying because that mak...
Tuesday, July 26, 2016

Result shows asterisk when converting int to varchar

›
I was sent a code by one engineer saying they he gets an odd error with one of calculations written. He gets the following error; Conv...
Sunday, July 24, 2016

SQL Server Brain Basher of the Week #048 - Dropping Clustered Index

›
SQL Server mainly maintains two structures for tables: Heap  and Clustered . If there is no clustered index created with the table, table ...
Saturday, July 23, 2016

Install SQL Server with just three clicks - The SQL Server Basic Installer

›
We have been installing SQL Server for long time, different versions and different editions. Everyone is familiar with installation wizard...