Right now, you're missing the entire query

🙂

You can eliminate irrelevant datatype columns using:

and columns.system_type_id IN (35,99,167,175,231,239,241,231)

hopefully you're not using sql_variant (98)

It should be possible. The stored procedure to create a subscription is ReportServer.dbo.CreateSubscription. You could either trace a call to the proc when creating a subscription via the RS Manager...

Depends on what your query is doing. Cast or Convert does whatever your query tells it to do.

If you are only using it in a select (only returning data), then...

Is it hidden? Look in Report > Manage > Properties

Use variables to determine the logic for the comparison values -- e.g.,

DECLARE @dayOfMonth int = DATEPART(DAY,GETDATE())
DECLARE @minDate DATETIME = CASE WHEN @dayOfMonth < 16 THEN DATEADD(mm, DATEDIFF(mm,...

Advantages of pre-allocation: Queries don't die when you suddenly run out of room in the middle of a transaction. No need to wait for file growth. No risk of something...

Are you doing index maintenance before the backup?

"so i have not taken a backup of the database, because it is not required as my Data balance plan is , balancing the data according."

And now you have no...

I liked Telerik reports when I was using it a few years ago. I haven't used it, but generally see good comments on DevExpress. Both appear to be...

You can use STRING_SPLIT to turn the delimited data into separate rows.

You can use CROSS APPLY (if product_descr is never null), or  OUTER  APPLY (if there are nulls) after...

SQL is a relatively simple language.

Sure. So is learning how all of the pieces move in the game of Chess.  You can memorize how all of the pieces move without...

You haven't mentioned the mdf file (primary data file). The corruption is in your mdf and/or one or more of the ndf files.

You restore from backups. Do you have recent...

PL/SQL implies Oracle (or PostgreSQL). Are you using Oracle or Microsoft SQL Server 2016?

If you're looping one-row-at-a-time, don't -- there's a lot of latency and extra logging costs in row-by-agonizing-row...

SQL is a relatively simple language. I think your domain knowledge in healthcare would certainly be an asset as a data analyst in healthcare.

How are your technical skills/confidence/experience in general?...