Turgay Sahtiyan - Senior SQL Server PFE

Some of the Recently Published MSIT Case Studies

I would like share with you some of the recently published MSIT case studies below. It gives you a...

Author: Turgay Sahtiyan Date: 01/10/2014

Announcement : MEA Services Webcast Series

I’m really happy to announce that as MEA services team we have started an initiative to share our...

Author: Turgay Sahtiyan Date: 01/02/2014

How to Find Which SPs Use Forced Index

One of the periodical DBA task is to examine index usage statistics with sys.dm_db_index_usage_stats...

Author: Turgay Sahtiyan Date: 11/16/2013

If you lost some intermediate backup files?

It’s sometimes really challengeable to restore a database if you lost some intermediate backup files...

Author: Turgay Sahtiyan Date: 10/27/2013

Recap – SQL Saturday 258, Istanbul

After SQLSaturday 258, Istanbul, finally I get some rest and find a free time to write about great...

Author: Turgay Sahtiyan Date: 10/09/2013

EXEC vs. sp_executeSQL

When we want to execute a TSQL string we can use both EXEC and sp_executesql statements. But there...

Author: Turgay Sahtiyan Date: 09/17/2013

The 3rd SQL Saturday in Turkey is Coming to You on 5th October, 2013

I am really proud to announce that SQLPass Turkey Chapter is organizing the 3rd SQL Saturday in...

Author: Turgay Sahtiyan Date: 09/17/2013

Data Mismatch on WHERE Clause might Cause Serious Performance Problems

Like Applying Function on WHERE clause problem, any datatype mismatch on WHERE clause might cause...

Author: Turgay Sahtiyan Date: 09/16/2013

My Upcoming Presentations at SQLSaturdays and SQLRally Nordic Events

The last quarter of 2013 calendar year is going to be really hectic. Next three months I will be...

Author: Turgay Sahtiyan Date: 09/13/2013

Applying Functions on WHERE Clause Columns might Cause Serious Performance Problems

Any function such as collate, convert, substring etc. applied on a column might make impossible for...

Author: Turgay Sahtiyan Date: 09/11/2013

Parameter Sniffing Problem and Possible Workarounds

SQL Server compiles the stored procedures using (sniffing) the parameters send the first time the...

Author: Turgay Sahtiyan Date: 09/10/2013

SQLSaturday #243, Cape Town : “Top 10 Performance Tips for SQL Server Developers”

I just presented my “Top 10 Performance Tips for SQL Server Developers” session at SQLSaturday #243,...

Author: Turgay Sahtiyan Date: 09/07/2013

Step by Step : Backup and Restore for SQL Server in Windows Azure Blob Storages

As all of you already awared, backing up data is a vitally important part of the strategy in...

Author: Turgay Sahtiyan Date: 07/12/2013

How to Find Unused Statistics

As you know, statistics are used for row estimation during query plan generation phase. So they are...

Author: Turgay Sahtiyan Date: 05/08/2013

I will be on the stage!

A few week later I will be on the stage for 2 SQLSaturday events. First of them will be held on May...

Author: Turgay Sahtiyan Date: 05/06/2013

Indexes Overhead on DML (Insert-Update-Delete) Operations

Indices dramatically affect query performance. A report which can take several hours can be...

Author: Turgay Sahtiyan Date: 04/22/2013

Using Plan Guides and Plan Freezing

Turgay Sahtiyan Normal Turgay Sahtiyan 2 1336 2013-02-28T22:06:00Z 2013-02-28T22:06:00Z 8 2131 12150...

Author: Turgay Sahtiyan Date: 02/28/2013