Performance: Demonstration of Outdated Statistics

standard post
yigitaktan  -  
2 Comments  -  

Statistics are created when Query Optimizer generates a query plan for getting a better performance. Query Optimizer uses Statistics to estimate how many rows will be returned from a query plan. You can access the statistics under the indexes folder in SSMS. Read More


Understanding Parallelism in SQL Server

standard post
yigitaktan  -  
0 Comments  -  

When SQL Server runs on a server with more than one processor or CPU, it detects to use all available CPU’s during query execution. SQL Server’s max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan. This option determines the computing and thread resources that are used for the query plan operators that perform the work in parallel Read More


SQLSaturday #258 – What a long Journey

standard post
yigitaktan  -  
2 Comments  -  

After the SQLSaturday #258, I couldn’t find any time to write about my opinions for this fantastic event. So, it was a long journey which succeeded for us and for all attendees. This journey was started at the beginning of June to October. During this time, I and my chapter team worked very hard so to say inch-by-inch and day-by-day. First of all, I would like to thank to the team. But the big thanks absolutely must go to Turgay Sahtiyan who was the former president of PASS Turkey. He made an excessive effort. It was the 3rd time we held this event in Istanbul. But for this year, SQLSaturday came with big differences. Read More


Reawarded as MVP

standard post
yigitaktan  -  
0 Comments  -  

Today, I have received an e-mail from Microsoft that says I have reawarded as MVP on SQL Server. This is the second year of me to hosted this outstanding award. When you are re-awarded, you receive current year’s ring with your MVP award kit! That means you won’t receive vertical glass rectangular stand again to again every year. Read More


A New Blog!

standard post
yigitaktan  -  
0 Comments  -  

Hi folks,

I decided to change my primary blog to English. So I have separate it. You can browse my Turkish blog at www.yigitaktan.com/tr