Useful tips for everyday
What is error 825? Error 825. Error 825 is often referred to as the read-retry warning, however the condition is for both read and write…
What are the disadvantages of a large differential backup? A large differential backup loses the advantages of a faster and smaller backup. As the differential…
How do I copy a SQL Server database to another computer? First of all, launch the SQL Server Management Studio from Object Explorer and connect…
What is a specific audit? A special audit is a tightly-defined audit that only looks at a specific area of an organization’s activities. This type…
How to add index with where-clause in PostgreSQL? I would like to add an index with a WHERE clause in Postgres. I used the following…
How to get table of Occurences in PostgreSQL? Without storing a new procedure you can use a code block and execute to obtain a table…
Can you add a non SQL Server subscription? If the publication you are subscribing to has SQL Server subscriptions and the publication is not already…
How do I choose a Distkey and Sortkey? The key is carefully planning each table’s sort key and distribution key. A table’s distkey is the…
How can avoid in clause in SQL Server? There are options to avoid it. — First Let’s create some tables and populate them. — To…
Why is simple SELECT query taking too long? After truncating and inserting data again to this table, I’m unable to do a simple select query…