Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
Date: 02/28/2013