Useful tips for everyday
What is trigger explain how do you create trigger? A trigger is a special type of stored procedure that automatically runs when an event occurs…
Does CTE increase performance? One difference is that a CTE used more than once could be easily identified and calculated once. The results could then…
How to do database migration in SQL Server? Take the latest backup of all the databases involved in migration 4. Restore the databases on the…
How does inserting values into a table using a subquery work? Subqueries also can be used with INSERT statements. The INSERT statement uses the data…
Which method is used to pass parameter in a function? Any modifications to the formal parameter variable inside the called function or method affect only…
How can I get rid of a filegroup? You can then select the “Empty file by migrating the data to other files in the same…
What is a partition switch? Partition switching is the process of moving a block of data around in one or more tables. An example. One…
How do I add a new field in SSRS report? To add a query field In the Report Data pane, right-click the dataset, and then…
What is memory pressure in SQL Server? Internal memory pressure is what comes from within SQL Server itself. Queries are run that need to pull…
How do I cast a column datatype in SQL? SQL CAST Function CAST (expression AS [data type]) SELECT First_Name, CAST(Score AS Integer) Int_Score FROM Student_Score;…