Friday, May 29, 2015

SSRS: The parameter is missing a value

›
Are you experiencing the following error with one of your Reporting Services parameters? Specifically with a hidden parameter? To ...
Thursday, May 28, 2015

SSRS: How to format datetime as Oracle YYYYMMDDHH24

›
If a SSRS report has to be designed for an Oracle database and datetime needs to be displayed with date and hour, there are many different...
Tuesday, May 26, 2015

SQLSaturday #417 - Speakers and Sessions

›
Speaker: Pinal Dave Pinal Dave is a Technology Evangelist for Pluralsight. He has written over 3,300 related articles on his blog ...
Monday, May 25, 2015

Guest Post: How much data will be loss when DBCC CHECKDB reports Consistency Errors?

›
This post is written by:  Priyanka Chouhan Every company or an individual, who use database systems, always wants to ensure the database ...
Sunday, May 24, 2015

SQL Server Brain Basher of the Week #013 - Global Temporary Tables

›
Though we create temporary tables frequently for manipulating temporary data, global temporary tables are infrequently created. As you know...
Saturday, May 23, 2015

Should I consider Collation when creating a temporary table?

›
We always create temporary tables for manipulating data for temporary processes and reports. However, unawareness of collation related iss...

How to decide the number of data files required for tempdb?

›
If your tempdb is used heavily and experiences some slow performance with it, adding multiple data files might help to improve the overall...

Fact Table: Clustered index on date key is enough or partitioning should be done with it?

›
Fact table in a data warehouse (or a large table in an OLTP database) always holds millions of records and we keep on adding records large...
Monday, May 18, 2015

Analysis Services, Integration Services and Reporting Services menu items in the Connect menu are disabled, what is the reason?

›
If you need to connect with Business Intelligence services via Management Studio, you use Connect  menu in the Object Explorer . Generally...
Sunday, May 17, 2015

SQL Server Brain Basher of the Week #012 - Partitions

›
While I was discussing Partitioning with one of my discussions in this week, one enthusiast asked whether how many partitions can be crea...
Saturday, May 16, 2015

What is a Junk Dimension?

›
Dimension represents entities that will be used for analyzing facts in the data warehouse. There are different type of dimensions like Reg...
Thursday, May 14, 2015

What are the reasons for introducing a surrogate key to a dimension table?

›
When designing a dimension table such as Product and Employee in a data warehouse, a surrogate key is introduced for implementing an uniqu...
Tuesday, May 12, 2015

How to take a copy of database files while they are being used by SQL Server

›
I am sure that you have tried this at least once and have face the below issue. Generally, we cannot copy database files or log files...
Monday, May 11, 2015

I want an execution plan optimized for my value, not for the value passed for parameters with first execution.

›
Since I got few questions on the posts written on stored procedure in last two weeks, thought to make few more posts on the same based on ...
Sunday, May 10, 2015

SQL Server Brain Basher of the Week #011 - DBCC

›
An interview question. What does DBCC stand for? When classes related to  Administration  are being conducted, I always ask this q...
Friday, May 8, 2015

How to determine whether RECOMPILE is required? If so, at the creation or execution?

›
When we know that the parameters we pass for stored procedures are widely vary, we insist engine to recompile the procedure. But it does n...
Thursday, May 7, 2015

EXECUTE....... WITH RECOMPILE: Does it discard the previously cached plan?

›
Not an advance theory, everyone knows that first execution of the stored procedure creates the best plan for the execution and keeps it in...
Wednesday, May 6, 2015

How to check parameters values used for compiling the stored procedure?

›
It is a known fact that the initial plan of the stored procedure is created with its first execution. SQL Server engines creates the plan ...
Tuesday, May 5, 2015

SQL Server exams are getting retired within next 12 months

›
New exams are getting added and older exams are either getting revised or retired. Microsoft Learning has decided to retire some exams inc...
Monday, May 4, 2015

SQL Server 2016 public preview coming this summer

›
Satya Nadella, CEO of Microsoft, announced SQL Server 2016, an intelligent platform for a mobile first, cloud first world..... Read more ...
Sunday, May 3, 2015

SQL Server Brain Basher of the Week #010 - Best way to send datetime value

›
Exchanging data between systems is not an uncommon scenario and it has become a part of most of the business. When exchanging data, the st...
Thursday, April 30, 2015

Incremental ETL: How to identify changes for fact data when no support from the source

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