Dinesh's Blog :::: Being Compiled ::::

"Data warehouse is a read-only database": this is one of the characteristics of data warehouse and we used to say "History ...

Everyone is familiar with the term "ETL" and everyone knows about the processes related to it. This concept refers extracting da...

When we need to create a table using a SELECT statement, the option we use is SELECT .... INTO. No arguments, for the most of situations, ...

Deciding an architecture for a data warehouse project and applying it is a challenge. The designer, or the architect has to decide many th...

Have you heard about this provider before? When we need to perform data extraction from another source, we need a provider for connecting w...

When you talk with your database, you use a language that is understandable to the database component you access and specific to the vendo...

Parameterization is not a difficult implementation with Reporting Services as most of the coding are automatically added either via the da...

We have been developing data warehouses, centralizing enterprise data and addressing business intelligence requirements. Generally, almost...

Not a new one but still I do not get proper answers when a question is asked on this. See whether you can select accurate statement(s) befo...

When forming a team for a Business Intelligence or Data Warehousing project, it is always advisable for filling the required roles with be...

SQL Server does not resolve names of stored procedures just as it does on tables. This resolution is bit different. Here is the post I mad...

How SQL Server resolves object names if you have not referred it is as a fully qualified object? If it is not a fully qualified object (a ...

I am sure that you are familiar with ROLLBACK TRANSACTION and COMMIT TRANSACTION but have you heard about or used ROLLBACK WORK and COMMIT...

Assume that you have a table with thousands of records and some of the records are being updated by another user. Now you try to read some...

Let's talk about date and time. Have a look on following code and try to guess the value returned by last SELECT statement. USE te...

Few Cumulative updates have been released for SQL Server 2012 and 2014. Here are the links for them: Cumulative update #6 for SQL Server ...

No matter how hard the software has been tested, issues can be still encountered. Same applies to Microsoft SQL Server too and that is the...

Here is another question I got in this week. The question is all about rolling back transactions, whether we need to write a code with ROL...

If you are the DBA or DBE, and reports have been deployed in production environment, question like above is very common? Usually quotes ar...

Can I use sp_recompile with tables? What would be your answer? Yes or no ? Answer should be Yes  but it does not mean that we can ...

This is something I discussed with one of my colleagues, it was all about obtaining the next sequence number from Identity type column wit...

Although getting questions from SQL Server enthusiasts makes me busy, this brushes up my knowledge significantly. This is one of the quest...