Useful tips for everyday
What is attendance and payroll system? The time-attendance system gathers employee attendance data in real-time and payroll integration automatically sends this data to payroll software.…
Can you connect to SQL Server 2014 Express? Verify that the instance name is correct and that SQL Server is configured to allow remote connections.…
What is not for replication in SQL Server? “Not for Replication” is a property which can be set for different objects like Check constraints, Foreign…
What is a Sqlproj? Full format name of files that use SQLPROJ extension is Visual Studio SQL Server Project. Files with SQLPROJ extension may be…
How do I setup a network with multiple subnets? 2 Answers Disconnect the second router. Reset it (just be sure) Change its IP address to…
What is truncate transaction log? Transaction log truncation Some operations can be minimally logged to reduce their impact on transaction log size. Log truncation deletes…
What is DDL in PostgreSQL? The PostgreSQL DDL is the acronym for Data Definition Language. The Data Definition Language is used to handle the database…
Is there a reorganize index maintenance task running too long? Coming to the point out of all there is a database with 51Gb, yes we…
What is a one to one or many-to-many to many relationship in database design? One-to-one: A record in one table is related to one record…
Do SQL backups use VSS? SQL Server provides support for Volume Shadow Copy Service (VSS) by providing a writer (the SQL writer) so that a…