I was recently asked is there a single script which can provide all the necessary details about statistics for any database.
SQLAuthority News – Monthly list of Puzzles and Solutions on SQLAuthority.com
This month has been very interesting month for SQLAuthority.com we had multiple and various puzzles which everybody participated and lots of interesting conversation which we have shared. Let us start in latest puzzles and continue going down. There are few answers also posted on facebook as well. SQL SERVER –…
Read MoreSQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator
Today is Monday let us start this week with interesting puzzle. Yesterday I had also posted quick question here: SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers
SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers
There are plenty of the things life one can make it simple. I really believe in the same. I was yesterday traveling for community related activity. On airport while returning I met a SQL Enthusiast. He asked me if there is any simple way to find maximum between two numbers…
Read MoreSQLAuthority News – Download Whitepaper – SQL Server 2008 R2 Analysis Services Operations Guide
SQL Server Analysis Service (SSAS) has been always interesting subject for research. Analysis Services cubes are a very powerful tool in the hands of the business intelligence (BI) developer. They provide an easy way to expose even large data models directly to business users. Microsoft has published very informative white…
Read MoreSQL SERVER – BI Quiz Hint – Performance Tuning Cubes – Hints
I earlier wrote about SQL BI Quiz over here and here.
SQLAuthority News – Ahmedabad Tech Ed On Road June 11, 2011 – A Grand Success of Community Tech Days
I am very excited to announce the huge success of the Microsoft Community Tech Days in Ahmedabad, on 11 June 2011. The turnout for this seminar was huge, and there was a great response from the audience. In fact, the AMA where the conference was held can seat 275 people – but there were over 50 people standing, the event coordinators had to find 150 more chairs, and we even had to turn away 30 people at the door because there was just no more room. This means that there were over 500 attendees!
SQL SERVER – SSAS – Multidimensional Space Terms and Explanation
I was presenting on SQL Server session at one of the Tech Ed On Road event in India. I was asked very interesting question during ‘Stump the Speaker‘ session. I am sharing the same with all of you over here. Question: Can you tell me in simple words what is…
Read MoreSQL SERVER – List of Article on Expressor Data Integration Platform
The ability to transform data into meaningful and actionable information is the most important information in current business world. In this fast growing and changing business needs effective data integration is single most important thing in making proper decision making. I have been following expressor software since November 2010, when…
Read MoreSQL SERVER – Solution – Generating Zero Without using Any Numbers in T-SQL
SQL Server MVP and my friend Madhivanan has asked very interesting question on his blog regarding How to Generate Zero without using Any Numbers in T-SQL. He has demonstrated various methods how one can generate Zero. When I posted note regarding how one he has generated Zero without using number…
Read More



