On first run of SSRS, report rendering is very slow and in this post we will explore “how to speed up SSRS on first run”. The reason behind is that we have to wait for the application pool to spin up. During each start up, the SSRS web service reads and decrypts the rsreportserver.config file, […]
Speed up MS SQL Server Reporting Services SSRS on First Run Read More »
One of my colleague asked me a question that how to “allow only alphanumeric characters” in a column. Below is the exact question: How can i stop accepting any non-alphanumeric characters during DML operations in a column of a table? To achieve this, we can follow below steps. There may be more different ways other than
Last night, i was asked to create a script to compare a bunch of tables data from QA to Prod server. Be sure here that i am talking about the comparison of data and nor schema. Some of us also uses some tools to achieve the same and i have no question about their working
Compare tables data on different databases with same structure Read More »
Lets explore the topic “Index Join in sql server” starting with “what is index join?”. Index join is a technique which uses an index intersection with two or more indexes to fulfill a query completely. If a table has multiple small index instead of a large covering index, the optimizer can choose index intersection on these
What is Bookmark Lookup? If all the columns required by the query are not available in the nonclustered index itself, a lookup is required to base table to pick those columns which are not part of the nonclustered index being used to retrieve the data. Lookup fetches the corresponding data row from the table by
Computed column is a virtual column in sql server, which is not stored physically in the table. It’s data is not materialized in the database and gets calculated during query execution on that column. It takes it’s value from an expression and that expression can contain other columns to calculate a new value for the
In this article, I will share a practical example from my experience. In one of my project, I had a requirement of dynamic data comparison between two entities and the number of attributes were dynamic and can be added any time by end user and removed too. Let me explain it with an example that how we
Read and compare XML nodes dynamically with unknown elements Read More »
In this article, we are going to learn how we can “Reverse string in sql server” with some specified delimiter e.g, based on space or comma or tilde or semi-colon etc; If you will input “A B C”, the output should be as “C B A” Solution: Lets assume space as a delimiter in this example
Reverse the string with a delimiter (Recursive CTE) Read More »
In this article, i will demonstrate a solution for dynamic row mapping problem in sql server. We will see “row mapping for given condition” with examples and in various way. One of my colleague asked me a question as below; “I have a table with Male and Female genders and want an output by mapping each Male with
Row mapping and generating equivalent records for given condition in sql server Read More »
In this article , we will generate as much number of rows as needed for each row of given table dynamically. We have a table named #Employee with two columns “EmpName” and “RowsToGenerate”. Lets explore “Generate rows dynamically” topic in with examples and demos. Generate Rows dynamically as per given count: Below is the structure of the table #Employee
Generate Defined number of rows dynamically (SET based approach) Read More »
