July 2023 – Page 2 – SQL Circuit

SQL Server -How to check truncation/ all rows deleted status of the table in SQL Server Database

We can check truncation/ all rows deleted status by using the below query. E.g. Employee is a table. SELECT object_Name(object_id)…

To trigger a process after insertion, we need to create INSERT trigger which trigger the process once data insert into…

Scenario: We can not restore the same with latest backup because the DB is critical and there is no latest…

Scenario: 1) Added a column in Tablix2) Added an expression into Column 3) But when we preview the report, the…

1) The KeyNotFound property on the dimension ErrorConfiguration is for snowflake schema. 2) For example, you have employee table which…

Following are the suggestion(s) which may not be solution but we can try if you are pulling all the data…

When we dont have a proper date dimenison then SSAS wil give performance issue(s). Performance issue mostly come when we…

This issue occurred when we move/copy the SSAS solution to a different folder. if this is not getting solve by…

DECLARE @StartTime DATETIME DECLARE @EndTime DATETIME DECLARE @duration INT –Capture timestamp for start of execution SET @StartTime = GETDATE() –…

SQL Server always create Subscription jobs in the instance where reporting service is installed/Configured. Or we can say SQL server…