Useful tips for everyday
How do I see all users in MongoDB? In order to list all users in the Mongo shell, use the getUsers() method or show command.…
What is DBO in stored procedure? dbo is not a prefix, is the schema Schema are like groups, you can create a schema called Production…
What is an IX lock? The locking system grants an intent exclusive (IX) or intent shared (IS) lock at the table level before it grants…
What is a replication set? A ReplicaSet’s purpose is to maintain a stable set of replica Pods running at any given time. As such, it…
Which is the best method for clustering in PostGIS? If such features not exist that means cluster building is completed. Maybe there are some clever…
How do I find the number of rows in a cursor? %ROWCOUNT Attribute When a cursor is opened, %ROWCOUNT is zeroed. Before the first fetch,…
How to increase storage for Amazon RDS instances? To increase storage for a DB instance Sign in to the AWS Management Console and open the…
Where to find SQL Server configuration.ini file? If you missed the Configuration.ini file path during the installation, you can find the configuration file in the…
How do I allow SQL Server to use more memory? Setting a Maximum Memory Limit for a SQL Server Instance. In Enterprise Manager, right-click on…
Can we apply non clustered index on primary key? Indexes and Constraints Indexes are automatically created when PRIMARY KEY and UNIQUE constraints are defined on…