Estimating the space requirement for database restores from the backup size can be really misleading.  One of the largest problems in this area is that free space in the...

Be aware, too, that an int column could require up to 10 bytes to store its value.  It's not safe to limit your result from this column to just 8...

Now, multiple online articles suggest to use only when data is huge and not for small amount of data

To put it simply, that's just wrong.  If you need to create...

I'd suggest always using SET XACT_ABORT ON.

(1) Otherwise, you can't be sure which part(s) of a transaction completed and which didn't.  Sometimes the entire transaction will be failed even with...

Oops.

You still don't need a temp table.  Instead:

INSERT INTO ...

SELECT ...

UNION

SELECT ...

UNION

SELECT ...

Insert into dbo.StdActiveTable
(StudentName ,
StdId ,
Stdgrade )

select std.Name
,std.StdID
,dp.stdgrade
from dbo.student std
join dbo.department dp
on std.stdid = dp.id
where (dp.isactive = 1) or
    (dp.isactive = 2 and sdt.isactive =...

Sure, easy to list only those two columns.  I was just mirroring what your original query had, since I wasn't sure exactly what you needed.

Personally I'd also make the job...

You need a few mods to your code, in particular to limit the results to only those with the current msdb session_id.  As a starting point for you, this code...

Should this be replaced with a table that has 17 computed columns ?

Yes, if a computed column would work, then that is what you should use rather than a function.

Can...

I guess I don't understand why anyone would write software based on the knowledge of novices.  If it's important for a novice to be able to maintain something...

Nothing to do with full-blown "novices".  I would expect people with reasonable experience in SQL Server to know what 0 is, it's the default "base date" in SQL Server.  If...

I learnt this from a wise old network manager who told me that you catch more flies with honey...

Along with the excellent suggestions above, also look very carefully at the query plans to see if you're hitting a "tipping point" query.  That is, one query that returns, for...

There's at least one other thread besides this one where someone used it and got the wrong date, because they added a month after the calc with -1 in it.  For...

People often learn via patterns.

If I see a pattern like "DATEADD(<time_period>, DATEDIFF(..." in consistent code, I know already what the result of the main computation will be.  I don't have...