MSSQL

We create Indexed Views by adding indexes to views. For detailed information about the View concept, I would recommend you read my article “What is …

We can briefly define View as a virtual table that does not physically store records, and is determined by a query. So, There is no …

  Transaction count shows that how heavily the database is used. Some third-party applications can show the transaction count graphs of the databases. But each …

We can use try-catch blocks in TSQL since SQL Server 2005. In the try block; We write the TSQL code that we want to catch …

  Before reading this article, I suggest you read my article “Fixed Server Level Role in SQL Server“. Apart from the default roles on Instance, …

  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 …