June | 2012 | SQL Server Business Intelligence and Big Data

SQL Azure Reporting.

June 25, 2012 Suhas Kudekar(MCC) Leave a comment

SQL Azure Reporting

SQL Azure Reporting enables developers to enhance their applications by embedding cloud based reports on information stored in a SQL Azure database. Developers can author reports using familiar SQL Server Reporting Services tools and then use these reports in their applications which may be on-premises or in the cloud.

SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF

June 9, 2012 Yashwant Leave a comment

Most of us use those statements while creating stored procedures and functions. most of us don’t know what is the significance of those statements and how they are useful.

SET QUOTED_IDENTIFIER ON/OFF

Categories: SQL, SQL Azure, SQL Server Tags: #SET ANSI_NULLS ON/OFF, #SET QUOTED_IDENTIFIER ON/OFF, dynamic tsql, sql, sql server, tsql

Understand Response Time vs. Total Time in SQL

June 8, 2012 Yashwant Leave a comment

Response time is the time it takes for a query to return the first record. Total time is the time it takes for the query to return all records. For an interactive application, response time is important because it is the perceived time for the user to receive visual affirmation that a query is being processed. For a batch application, total time reflects the overall throughput. You have to determine what the performance criteria are for your application and queries, and then design accordingly.

Categories: SQL, SQL Server Tags: #Responce Time, #SQL, #Total Time, query, response time, sql server

Get a comma separated list in SQL & MDX.

June 6, 2012 Suhas Kudekar(MCC) Leave a comment

To get a comma separated list in SQL as well as in MDX use below queries.

Categories: Business Intelligence Tags: comma seprated, MDX, sql, ssas

Sequence Vs Identity – SQL Server 2012

June 6, 2012 Manish Kaushik 6 comments

What is sequence?

Sequence is a newly introduced database object in Sql Server 2012, Sequence is used to generate a sequence of numeric values in either ascending or descending order, along with an option to have the minimum and maximum values and also allows to cycle and cache for better performance.