Useful tips for everyday
What does it mean when a table is partitioned? What is a database table partitioning? Partitioning is the database process where very large tables are…
Which key defines the relationship between two tables? Primary key defines a relationship between two tables. Reason : Because in primary key column for each…
Why is SQL server-log shipping restore job error? If we look closely to the error, it talks about LSN mismatch. Most of the cases, a…
What causes memory failures? Causes of such memory errors may be due to certain cognitive factors, such as spreading activation, or to physiological factors, including…
How to perform SQL roll back from SQL Server 2008? First of all, copy the database MDF and LDF files. Better safe than sorry The…
Can you change schema? ALTER SCHEMA can only be used to move securables between schemas in the same database. Therefore, we recommend that ALTER SCHEMA…
How do I add multiple rows and columns in one single cell in Excel? Insert rows Select the heading of the row above where you…
How do you bulk UPDATE in SQL? BULK updation in sql. update multiple table single statement. write a Update Statement in single Line for… Sql…
When to use fail over to log shipping secondary? Fail Over to a Log Shipping Secondary (SQL Server) Failing over to a log shipping secondary…
What happens when MongoDB runs out of memory? In sum, the mongod process will consume more and more memory as it fills up its cache.…