MSSQL

With User Defined Table Type, we can store the structure of a table. We can use the User Defined Table Typies by defining the table-valued …

The Query Store is a feature that introduced in SQL Server 2016. In order to understand the Query Store, it is necessary to understand the …

Database Engine Tuning Advisor (DTA) examines how queries are running in the database and provides us with suggestions. It has its own interface. You can …

With SQL Server 2008, we can now easily uninstall Service Packs and Cumulative Updates from Control Panel, Programs and Features. Especially in case of a …

With BULK INSERT you can upload text, csv data files to the database in any format. Users must have insert privileges in the database and …

With OPENROWSET, you can access remote data using OLE DB. OPENROWSET is a system function as you will see below. With this method, we provide …

What is Query Hint? You can change the execution plan of the query by adding the query hints to the end of the query. For …

In this article, we will examine what happens when we enable Optimize for ad hoc workloads and when we use parameterization. We will see what …

sp_create_plan_guide introduced with sql server 2005. With this sp, you can increase the performance of your queries that you can’t intervene or change, by adding …

Indexes can be disabled in SQL Server 2005 and later versions. If the index is disabled, it is necessary to rebuild the index to enable …