Parameter Sniffing is the result of using the query plan in the cache. When a stored procedure is compiled the last time a query …

  In a Cluster you can list all the databases and their sizes withe below script. I prefer one application db for a cluster generally. …

  First, We connect to the node that the database is running with ssh. We see a list of backup jobs with the following command. …

  In this article we will examine how to give permission to a user in PostgreSQL. You should click on the Postgres menu item for …

  First, we connect to the node where the database is located with ssh. After loading the database’s profile, we connect to RMAN with the …

  You can keep the database-level code that you need to use every time in the application through “stored procedures” in the database. You can …

  In this article I will explain you to list active queries in postgresql. First you must connect to postgresql. You may want to read …

  Account Lockout Policy is a security mechanism used by SQL Server. For example, consider someone who is trying to log in with a user …

  Extent Management Control can be LOCAL or Dictionary Based. If local, the information in the bitmaps in the datafile is used. If Dictionary Based, …

I find OLA HALLENGREN’s maintenance script very successful and practical. In this article I will tell you where to download and install the script that …