Store procedure one of the object which are used in SQL server database very massively to line up with application. From DBA and Developer end it is tough deal to figure out the culprit store procedure which is consume high resource. We have observed the in production server more than 1000 user define store procedure [...]

Step-1: Goto Site Actions -> More Options Step-2 Choose the Asset Library and give the name for that Step-3 Wait till the changes are being processed Step-4 Click an Add new item Step-5 Click on choose file Step-6 Select the media file to be uploaded Step-7 After few second an information window will be opened [...]

Memory issue is very common stress for DBA but SQL server 2008 introduce new DMV which we can use to handle the issue quickly. Need to follow the below step to resolve the issue quickly. sys.dm_os_sys_memory This DMV was introduced in SQL Server 2008 with an intention of making life easier for all those systems [...]

During production work we sometimes face a problem where when we verify the log space, it shows us as 3274MB. To rectify the same we have to run DBCC Update Usage for all databases to correct pages and row count inaccuracies in the catalog views. These inaccuracies may cause incorrect space usage reports returned by [...]

Contention is the word that we  need to concentrate in resolving the performance issue, page latches contention is common in multi-CPU systems due to the nature of when multiple threads concurrently attempt to acquire incompatible latches to the same in-memory structure. In general there is a miss-representation that latches means locks, but not both are [...]

Dynamics CRM 2011 allows user to integrate CRM reports in IFrames within any entity. For this just create a report in CRM using Report Wizard or you can import external RDL file in CRM. Now to display the report inside entity follow below steps. We will display a simple report in account entity with the [...]

If database is involved in replication then we have to troubleshoot the performance issue in a little bit different way. We can improve the Merge queries and it will improve the overall system performance for synchronizing data. Identify high IO or high CPU SPs then explore how to tune. Here I have posted the article [...]

If the master database is corrupted or damaged, SQL Server won’t start. Attempting to start SQL Server will have no effect. Attempting to connect to the instance with Management Studio will invoke a warning that the server does not exist or that access is denied. The only solution is to first rebuild the master database using [...]

We had a requirement from one of our client where we had to store and pass parameter from one HTML page to another.  We achieved this by simply using HTML/JavaScript. We created two files write.html and read.html, each for writing into a text file and reading from a text file. Below is the sample code [...]

Pentaho allow us to use alternate row color for any report. We can achieve this by using HidePageBandForTableExportFunction. Below are to steps Select Report Function in report structure. select Available Function->Misc->HidePageBandForTableExportFunction under properties area. Click on Add Function to Report Button. Give the function name. After that Item Band option will appear into structure hierarchy. [...]