Skip to main content

Posts

Error on SSRS Report execution query string size exceeded

 Error on SSRS Report execution Excption information: Exception type: HttpException Exception message: The length of the query string for this request exceeds the configured maxQueryStringLength value. at System.Web.HttpRequest.ValidateInputIfRequiredByConfig() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Solution Go to C:\Program Files\Microsoft SQL Server\MSRSXX.<instance_name>\Reporting Services\ReportServer\ Open the web.config Find the <httpRuntime> element. <?xml version=”1.0" encoding=”utf-8"> <configuration>     <system.web>         ...         <httpRuntime maxRequestLength="100000" executionTimeout="90000" requestValidationMode="2.0" >         ...     </sytem.web> Add or modify the maxQueryStringLength attribute (DefaultValue is 2048). <?xml version=”1.0" encoding=”utf-8"> <configuration...
Recent posts

SQL Server query to find long running process in database

  You can user below  Server query to find long running process in database. Please try in query editor thanks. SELECT r . session_id , r . start_time , TotalElapsedTime_ms = r . total_elapsed_time , r .[ status ] , r . command , DatabaseName = DB_Name ( r . database_id ) , r . wait_type , r . last_wait_type , r . wait_resource , r . cpu_time , r . reads , r . writes , r . logical_reads , t .[ text ] AS [ executing batch ] , SUBSTRING ( t .[ text ], r . statement_start_offset / 2 , ( CASE WHEN r . statement_end_offset = -1 THEN DATALENGTH ( t .[ text ]) ELSE r . statement_end_offset END - r . statement_start_offset ) / 2 ) AS [ executing statement ] , p . query_plan FROM sys . dm_exec_requests r CROSS APPLY sys . dm_exec_sql_text ( r . sql_handle ) AS t CROSS APPLY sys . dm_exec_query_plan ( r . plan_handle ) AS p ORDER BY r . total_elapsed_time DESC ;

Top Database management Software application list

  SolarWinds Database Performance Analyzer DbVisualizer ManageEngine Applications Manager Oracle RDBMS IBM DB2 Microsoft SQL Server SAP Sybase ASE Teradata ADABAS MySQL FileMaker Microsoft Access Informix SQLite PostgresSQL AmazonRDS MongoDB Redis CouchDB Neo4j OrientDB Couchbase Toad phpMyAdmin SQL Developer Seqel PRO Robomongo Hadoop HDFS Cloudera MariaDB Informix Dynamic Server 4D (4th Dimension) Altibase

What is good way to reply negative email communication of customer or Client

 To Handle negative email form Customer We need to follow below Instruction. This could be tricky situation so we need to take care those email more than other communication. When we receive a negative mail or communication from customer. We have to present the Facts & proper logical sequence of activities. We have to demonstrate why that situation has arises. If we have highlighted any Risk or intimated customer that we might be facing negative result.  We need to highlight that it was communicated and based on that unfortunately the Risk has occurred. The second part of the mail should contain, how do we plan to pull customer / stakeholders out of that situation. What are the ways and mediums for the same. Also please make sure that you involve your Senior Manager before sending our response to such communication

04 last working day (Adieu) Email Format for IT or ERP Professional company

Today is my last working day at xyz compay . It’s always hard to say good bye. I would like to take this opportunity to thank each and every person I have worked with in past 5 Years of my stint with xyz compay .  I would start by thanking a,b,c,d etc for all the opportunities. I would also like to thanks E for his Mentoring and help provided whenever I needed the same.  Thanks to my technical team (Name list). We always got each other’s back. I would also like to thanks functional and pre-sales team whom I have closely worked (Name list) to name but a few.  Thanks to HR team (Name List).   I may have chosen to walk different path but xyz compay  , the time spent here and memories will always stay close to my heart   Needless to say, please stay in touch. I am reachable at my personal email test@xyc.com

03 Good Bye Email format for Last working Day (Adieu) After 10 Year Experience

Dear All,  After almost 10 year of exciting and memorable stint with xyz company.I am bidding adieu to pursue other career opportunities.   I want to take a moment to say goodbye to you all, today is my last working day in xyz compay and it has been a journey filled with wonderful memories. I appreciate having had the opportunity to be associated with xyz compay and YOU all !   With all this, it has been a hard decision for me to go ahead with the change. But there come times in everyone's life when a change is for the better, and this is one of those times.   It is rare to find great working experience as good as that is in xyz compay . I take this opportunity to personally thank each one of you, who have always helped and supported, directly or indirectly.   My journey at xyz compay  will always hold a very special place in my professional life. I have huge respect and emotions towards this organization.   Once again thanks to all and good bye. ...