Things To Consider While Using SQL Server Reporting (SSRS) With Silverlight (3 and 4)

Facebooktwittergoogle_pluslinkedinmail

Reporting is the heart of most business applications. And SQL Server Reporting Service (SSRS) is a preferred choice while MSSQL Server is the database back-end. Apart from ready to use services, SSRS provides different and useful scalability and extensibility options.

On the other end, lately, MS Silverlight has generated positive heat amongst varied business applications.

So you got the point. I’m talking about the marriage between SSRS and Sliverlight.

It started with challenges as the whole concept was an unknown devil which we were able to tame in the end.

Continue reading Things To Consider While Using SQL Server Reporting (SSRS) With Silverlight (3 and 4)

Something about NULL in SQL Server

Facebooktwittergoogle_pluslinkedinmail

As developers, we all probably know what a NULL is in SQL Server. NULL is not a specific value but it stands for UNKNOWN value. In other words, NULL represents the ‘absence of data’.

The behavior and treatment of NULL in SQL server is very interesting in different context and part of T-SQL language. Let’s have a quick look on how it is treated in different ways by SQL Server.

When you use NULL (UNKNOWN value) in Arithmetic operations or in String Concatenation operations, the result is always UNKNOWN because the value which is being operated is not available or UNKNOWN. So, all the following statements yield the result of NULL:

Continue reading Something about NULL in SQL Server

5 Performance Enhancement Tips for LINQ Coupled With MSSQL Server

Facebooktwittergoogle_pluslinkedinmail

LINQ is one of the most exciting enhancements made in the Microsoft.NET languages in the recent years.

Essentially, it’s a new way to represent different data models in OOPs notation.

While working extensively with LINQ in last couple of years on mission critical .NET projects, I’ve observed the following five performance enhancement possibilities.

Continue reading 5 Performance Enhancement Tips for LINQ Coupled With MSSQL Server

Smart and Effective Use of SQL Server’s Pool of Shared Memory

Facebooktwittergoogle_pluslinkedinmail

Microsoft SQL Server has an effective pool of shared memory which ideally is used for two purposes .

  1. Data buffer;
  2. Execution plan cache.

It is commonly known that a query executed second time always gives response faster than the first time. In this post I’m going to discuss what works behind this and how can we make sure that the shared memory is effectively used. Continue reading Smart and Effective Use of SQL Server’s Pool of Shared Memory

Few Smart Database Indexing Tips To Boost Application Performance

Facebooktwittergoogle_pluslinkedinmail

Indexes play key role in performance and scalability of any database intensive applications. Here are few tips to smartly use indexes to get the best out of it.

  1. Decide Best Candidates for Index. The column(s) which are most frequently used to filter records (WHERE clause and JOIN clause), group records (GROUP BY clause) and/or sort records (ORDER BY) are best candidates for index creating. Analyze your queries very attentively and avoid creating indexes which are seldom used. You should also minimize the number of indexes for the tables which has data being frequently updated/deleted/inserted to reduce index maintenance cost during each such operation.
  2. Continue reading Few Smart Database Indexing Tips To Boost Application Performance