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...
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...
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...
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...
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...
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...
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”...
Date: 03/02/2013
SQL Server Builds
How to identify SQL Server version Open SQL Server Management Studio and run of the following...
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...
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...
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...
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...
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.]...
Date: 10/16/2012