Useful tips for everyday
How do I report a publisher in SQL Server mobile? To create a Reporting Services mobile report, install SQL Server Mobile Report Publisher, or launch…
How long does SQL Server backup take? Common backup speeds range approximately 1 GB per every 2 – 3 minutes. A 10 GB SQL database…
How to improve query performance on large table? First, I want to inform that both to partition the table into filegroups and split the table…
Does adding a column lock the table? Adding a column to a table will no longer require table locks except possibly brief exclusive locks at…
Which is used to improve the query performance? However, there is no straightforward way to define the best performance but we can choose multiple ways…
Can we change the starting value of auto increment according to our choice? You can use ALTER TABLE to change the auto_increment initial value: ALTER…
How do I allow remote access to MariaDB? How to enable Remote access to your MariaDB/MySQL database Enabling Remote Access in the Webdock Dashboard. Manual…
When does a secondary replica start a log backup? Once the primary replica acquires Bulkop lock, it informs to secondary replica to start log backup.…
What should be varchar size? The size of the maximum size (m) parameter of a VARCHAR column can range from 1 to 255 bytes. If…
How do I restore a Database in SQL Server 2017? Restore Database backup using SQL Server Management Studio Connect to the instance of the Microsoft…