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
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