ORDER BY + OFFSET + FETCH - Sayfalama İçindir

Örnek

SQL Server 2012 ve sonrasında şöyle yaparız

SELECT * FROM Employees ORDER BY EmployeeID ASC
OFFSET 10 ROWS         -- Skip the first 10 rows
FETCH NEXT 5 ROWS ONLY; -- Fetch the next 5 rows

Örnek

SQL Server 2008 ve öncesinde şöyle yapılır

SELECT TOP 5 *
FROM (
    SELECT *, ROW_NUMBER() OVER (ORDER BY EmployeeID ASC) AS RowNum
    FROM Employees
) AS SubQuery
WHERE RowNum > 10;

DROP DATABASE

Örnek

Force drop için şöyle yaparız

-- Set the database to SINGLE_USER mode with ROLLBACK IMMEDIATE to kill all connections
ALTER DATABASE my_new_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

-- Drop the database
DROP DATABASE my_new_db;

Sütun Tipleri - TINYINT - 1 BYTE - UNSIGNED

Giriş

0 - 255 arasında değer saklar

CREATE NONCLUSTERED INDEX

Örnek

Şöyle yaparız

CREATE NONCLUSTERED INDEX IDX_MYINDEX

ON Orders(OrderDate, ProductID);

Query Store

Giriş

Açıklaması şöyle

The Query Store in SQL Server is a feature designed to help you monitor, troubleshoot, and optimize query performance by automatically capturing a history of queries, plans, and runtime statistics. It's essentially a performance monitoring and tuning tool built into SQL Server.

Örnek

Şöyle yaparız

ALTER DATABASE AdventureWorks SET QUERY_STORE = ON;

SQL Server Management Studio

Generate Scripts

Database simgesine sağ tıkla ve Tasks/Generate Scripts menüsünü seç

Replication Tipleri

Giriş

1. Snapshot Replication

2. Transactional Replication

3. Merge Replication