MSSQL

  I would like to write this article because it is a topic that some friends who are interested in SQL Server are usually curious …

In some cases, we may need to determine the memory rates used by databases. Because some databases using extra memory may be degrading the performance …

  OUTPUT Clause transfers the records affected by the currently executed INSERT, UPDATE, or DELETE operations to the specified table. So we can easily capture …

We can create a user without login since SQL Server 2005 version. This feature was introduced instead of Application Role. You may want to read …

  These are the special sorting functions that we can use to sort the data that we select from the tables at run time. ROW_NUMBER …

  Application Role is a role at the database level. You can use Application Roles to access a database only with specific users from a …

I will tell you below metadata functions in this article. APP_NAME COL_LENGTH DATABASEPROPERTYEX SERVERPROPERTY DB_ID DB_NAME OBJECT_ID OBJECT_NAME SCHEMA_ID SCHEMA_NAME STATS_DATE APP_NAME Function: This function …

Before you begin this article, I suggest you read my article “How To Create a Login On SQL Server(Manage Logins)” for a detailed review of …

A login must have authority over some database roles in the msdb database in order to access SQL Server Agent. These roles in the msdb …

  CHOOSE and IIF functions are logical functions. CHOOSE function returns the value at the specified index from the specified list. IIF function performs the …