MSSQL

  These roles are the default server level roles at the instance level. You can find the brief description about these roles below. sysadmin sysadmins …

  In SQL Server, we can join two tables with JOIN operators. You can read the “Join Types in SQL Server” article. With the CROSS …

  Resource Governor announced with SQL Server 2008. We are able to limit resources of a session using Resource Governor. For example, a report user …

The PIVOT , which is indispensable for Excel users, can be implemented with SQL Server 2005 via T-SQL. But I can’t say it’s as talented …

  You can find detailed information about Contained Database in the article “What is Contained Database” We can create a new Contained Database and create …

  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 …