SQL Server Knowledge by Batuhan YILDIZ

Notes From The Field Experiences and Useful Scripts - By Microsoft Premier Field Engineer

What size is suitable as an Initial Size for tempdb system database?

The size and physical placement of the tempdb database can affect the performance of a system. For...

Author: BatuhanYildiz Date: 05/29/2013

Basic steps to setup Windows Server 2012 Cluster with Hyper-V

Setup Windows Server 2012 Cluster in Hyper-V iSCSI Target Configuration iSCSI Initiator...

Author: BatuhanYildiz Date: 05/19/2013

How to identify and solve the fragmentation in SQL Server?

How does fragmentation occur in SQL Server? If there is an index on the object, the data is ordered...

Author: BatuhanYildiz Date: 04/18/2013

Which one is better? PERSISTED Column or XML Indexes?

I had a chance to work on the XML area. The customer had a performance issue with some queries which...

Author: BatuhanYildiz Date: 03/21/2013

How to find busy tables in SQL Server?

There is a performance issue on the system. You check the sys.dm_os_wait_stats and you see that...

Author: BatuhanYildiz Date: 03/20/2013

Guest user account in SQL Server

It is recommended to disable guest user in every database as a best practice for securing the SQL...

Author: BatuhanYildiz Date: 03/02/2013

Autogrowth option for SQL Server database files

It is not recommended to keep “In Percent” File Growth option for database files. If “In Percent”...

Author: BatuhanYildiz Date: 03/02/2013

SQL Server Builds

How to identify SQL Server version Open SQL Server Management Studio and run of the following...

Author: BatuhanYildiz Date: 03/01/2013

Using Distributed Replay to load test your SQL Server–Part 2

In the first part of this series, I explained you how to install and get started with Distributed...

Author: BatuhanYildiz Date: 02/26/2013

Using Distributed Replay to load test your SQL Server–Part 1

This is the first part of a two part series where I explain how to use the new Distributed Replay...

Author: BatuhanYildiz Date: 02/25/2013

TOP N Biggest Tables in every database

Sometime it may be useful to find all the big tables in all databases. There may be performance...

Author: BatuhanYildiz Date: 01/17/2013

TSQL for database size, data and log available size

What are our databases sizes in SQL Server? How much space is Available? How can I prevent the...

Author: BatuhanYildiz Date: 01/07/2013

How to enable/remove Transparent Data Encryption (TDE)

[Note: Before working with the example please read the VERY IMPORTANT NOTE at the end of this page.]...

Author: BatuhanYildiz Date: 10/16/2012