SQL Server Knowledge by Batuhan YILDIZ

How does fragmentation occur in SQL Server? If there is an index on the object, the data is ordered in the page using the slot array. When a new insert comes, SQL engine will search an available page to keep the data by using the index. The data should...

I had a chance to work on the XML area. The customer had a performance issue with some queries which were related to XML data. The customer was using a banking application called TEMENOS T24 on Microsoft SQL Server. The tables in the databases have just...

There is a performance issue on the system. You check the sys.dm_os_wait_stats and you see that PAGEIOLATCH wait type is at the top. You know that it is related to disk performance. It may be because of the high IO issue or disk related issue itself....

It is recommended to disable guest user in every database as a best practice for securing the SQL Server. Guest user permits access to a database for any logins that are not mapped to a specific database user. The guest user cannot be dropped but it can...

It is not recommended to keep “In Percent” File Growth option for database files. If “In Percent” option is used for any database file and if the file size is very big, it may cause performance degradation during the file growth phase. It may not be a...

How to identify SQL Server version Open SQL Server Management Studio and run of the following queries. First Query: SELECT SERVERPROPERTY ( 'productversion' ),        SERVERPROPERTY ( 'productlevel' ),       ...

In the first part of this series, I explained you how to install and get started with Distributed Replay. I continue in this series by showing you how to actually capture and replay workloads. After we have configured the Distributed Replay as explained...

This is the first part of a two part series where I explain how to use the new Distributed Replay functionality in SQL Server 2012. The first part covers setup and the second one covers the usage. Have you decided to migrate SQL Server to a newer version...

Sometime it may be useful to find all the big tables in all databases. There may be performance issue on the system and it can be necessary to move some tables to another disk to decrease the disk latency. So additional File Groups and Files can be created...

What are our databases sizes in SQL Server? How much space is Available? How can I prevent the automatic auto growth of data and log files? How can I be notified if there is not enough space in the log file? It will be really good to consolidate all the...

[Note: Before working with the example please read the VERY IMPORTANT NOTE at the end of this page.] If your database files (data and log files) are stolen, those database files can be attached in another SQL Server instance, or if your backup is stolen...