Sign in
SQL Server Knowledge by Batuhan YILDIZ
Notes From The Field Experiences and Useful Scripts - By Microsoft Premier Field Engineer
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
Available Space
Biggest Table
Busy Tables
Computed Column
Distributed Replay
Expensive Tables
Fragmentation
PATH Index
Persisted Column
Primary XML Index
Script
Secondary XML Index
SQL Server
SQL Server 2012 New Features
SQL Server Auto growth
SQL Server Best Practice
SQL Server Index Maintenance
SQL Server Information
SQL Server Version
Statistic
TDE
Transparent Data Encryption
TSQL Database Size
TSQL Log Size
XML Index
Archive
Archives
April 2013
(1)
March 2013
(5)
February 2013
(2)
January 2013
(2)
October 2012
(1)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server Knowledge by Batuhan YILDIZ
How to identify and solve the fragmentation in SQL Server?
Posted
1 month ago
by
BatuhanYildiz
1
Comments
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...
SQL Server Knowledge by Batuhan YILDIZ
Which one is better? PERSISTED Column or XML Indexes?
Posted
2 months ago
by
BatuhanYildiz
0
Comments
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...
SQL Server Knowledge by Batuhan YILDIZ
How to find busy tables in SQL Server?
Posted
2 months ago
by
BatuhanYildiz
1
Comments
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....
SQL Server Knowledge by Batuhan YILDIZ
Guest user account in SQL Server
Posted
2 months ago
by
BatuhanYildiz
0
Comments
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...
SQL Server Knowledge by Batuhan YILDIZ
Autogrowth option for SQL Server database files
Posted
2 months ago
by
BatuhanYildiz
2
Comments
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...
SQL Server Knowledge by Batuhan YILDIZ
SQL Server Builds
Posted
2 months ago
by
BatuhanYildiz
0
Comments
How to identify SQL Server version Open SQL Server Management Studio and run of the following queries. First Query: SELECT SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ), ...
SQL Server Knowledge by Batuhan YILDIZ
Using Distributed Replay to load test your SQL Server–Part 2
Posted
2 months ago
by
BatuhanYildiz
0
Comments
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...
SQL Server Knowledge by Batuhan YILDIZ
Using Distributed Replay to load test your SQL Server–Part 1
Posted
2 months ago
by
BatuhanYildiz
0
Comments
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...
SQL Server Knowledge by Batuhan YILDIZ
TOP N Biggest Tables in every database
Posted
4 months ago
by
BatuhanYildiz
0
Comments
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...
SQL Server Knowledge by Batuhan YILDIZ
TSQL for database size, data and log available size
Posted
4 months ago
by
BatuhanYildiz
0
Comments
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...
SQL Server Knowledge by Batuhan YILDIZ
How to enable/remove Transparent Data Encryption (TDE)
Posted
7 months ago
by
BatuhanYildiz
0
Comments
[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...
Page 1 of 1 (11 items)