Team SQL Circuit – Page 12

SQL Server – Adverse effect of using User defined function in the T-SQL Query Performance

Following are the reaons that why UDF degrade query performance:1) User defined function calls each row & get the data…

Work round: 1) We can do some work around if we have data like Age (21,50, 75) which is stored…

Following things can be checked to resolve the issue: 1) Run the report query in SSMS and see whether it…

Following are the suggestions: 1) If your SSIS server is shared instance then there could be possibility that your IO/memory…

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…