Sql Server 2016

TL;DR — You can use Query Store to identify poor performing queries quickly and easily! In SSMS open “Query Store” and run some of the queries and play around! Note — it does have some performance impact on production servers! SQL server 2016+ has a great feature known as “Query…

Many a times we come across a scenario where we need to execute some code based on whether a Database exists or not. There are different ways of identifying the Database existence in SQL Server. …

This is a re-hash of a LinkedIn article I wrote in 2018 I was working on an Azure cloud enablement project for a client and we were working through some interesting challenges, I thought it would be of interest to share one of the useful tricks that we discovered for…

Merhabalar son zamanlarda daha fazla veri saklamamıza yardımcı olan XML,JSON gibi dosya uzantılarının kullanımları arttı.Birçok sebepten ötürü bu dosya formatındaki verileri mevcut veritabanı sistemimizde tablo formatına çevirmek isteyebiliriz.SQL Server üzerinde XML’de bulunan verileri tabloya aktarabiliriz.Gelin şimdi bunu nasıl yapabiliriz ona bakalım. Mevcut XML yapımız yukarıdaki gibidir.

Programlama dillerinde en kullanışlı özelliklerden biri bir listeyi veya diziyi baştan sona gezmektir. C# gibi programlama dillerinde bu işlem foreach komutu yapılmaktadır. SQL Server tarafında ise bu işlem cursor yapısı ile yapılmaktadır. Aşağıdaki basit diyagram üzerinden giderek bir cursor oluşturma adımlarını inceleyerek konumuza başlayalım.

Being the final part of the article, it is going to take you to the next level of analyzing word documents stored in Windows folders, managed by File Table, and consumed by Semantic Search. Additionally, the readers are going to gain more understanding of Semantic Search and how to make…

Ever thought about writing following query inside entity frame: Select * From Employees e left join Employees_Attendance ea on e.id=ea.employee_id and ea.date between {{startdate}} and {{enddate}} In above query {{startdate}} and {{enddate}} are the parameters, this query will list all of the employees but only the attendance that are between…

SQL Server讀取索引方式有兩種，無論Scan或Seek都存在向前(forward)和向後(backward)， 索引設計基本也都會考慮index key排序，當然，任何索引設計都是配合TSQL查詢， 實務上，當遇到查詢效能問題，我建議大家先嘗試改寫TSQL、後評估資料表和索引修改影響成本， 千萬不要一遇到查詢效能問題，二話不說先建立索引，或異動資料表結構， 因為所有DDL操作都會發生封鎖情況，如果該資料表相當龐大且存取頻繁， 我想應該可以先準備跑路了。 同事:使用Max和Min函式，SQL Server應該需要掃描資料表全部資料才知道最大或最小值? Rico:你看執行計畫了嗎? 同事:有阿，也有看到Scan運算子，你之前不是說盡量消除Scan並使用seek運算子取代，但這樣還可以消除嗎? Rico:Scan不一定就差，Seek也不一定就好，看看資料量再決定如何調校 create clustered index cidx on TransactionHistoryRico(TransactionDate)