SQL Server Issue – SQL Server Database struck in Recovery Mode
Scenario: We can not restore the same with latest backup because the DB is critical and there is no latest…
Year: 2023
SSRS Issue – Column not showing in a Tablix
Scenario: 1) Added a column in Tablix2) Added an expression into Column 3) But when we preview the report, the…
SSAS Error – KEY NOT FOUND while processing the Cube
1) The KeyNotFound property on the dimension ErrorConfiguration is for snowflake schema. 2) For example, you have employee table which…
SSRS Subscription Error Message :Failure sending mail: The operation has timed out.Mail will not be resent
Following are the suggestion(s) which may not be solution but we can try if you are pulling all the data…
SSAS – Performance issue with Date Dimension
When we dont have a proper date dimenison then SSAS wil give performance issue(s). Performance issue mostly come when we…
SSAS Tabular Model Issue: The file name(s) would be too long for the destination folder. You can shorten the file name and try again, or try a location that has a shorter parth
This issue occurred when we move/copy the SSAS solution to a different folder. if this is not getting solve by…
SQL Server – How to get a alert or notification if SQL Query is taking more than 5 mins
DECLARE @StartTime DATETIME DECLARE @EndTime DATETIME DECLARE @duration INT –Capture timestamp for start of execution SET @StartTime = GETDATE() –…
SSRS – How to migrate Report Subscriptions from one server to another server
SQL Server always create Subscription jobs in the instance where reporting service is installed/Configured. Or we can say SQL server…
SQL Server – How to reorganize indexes in SQL Server Database
Reorganizing the indexes consists of two processes 1) Detect the fragmentation: By using the system function sys.dm_db_index_physical_stats, you can detect…
SQL Server – How to run a query for all the database(s) in SQL Server Instance
We will use sp_MSforeachdb procedure which is an undocumented procedure that allows you to run the same command against all…
SSRS – Representation of data in Parent child relationship
For showing the data in Parent Child relationship, we need to create grouping. Let’s take an example of Product Category,…
SQL Server – Reason for stored procedure not returning any data
Following could be reason(s): 1) Multiple Exit Point in the stored procedure. We may have RETURN statement before stored procedure…