TSQL script to get the index size and information in SQL Server

TSQL script to get the index size and information in SQL Server

TSQL script to get the index size and information in SQL Server

TSQL script to get the index size and information in SQL Server post can help you in getting the index information from a database in SQL Server. There are two scripts provided:

Script 1: It captures all possible information of all indexes in the given database

Script 2: Captures the table wise number of indexes and total index size on a table

Script 3: Captures the index fragmentation details in the given database

TSQL script to get the index information in SQL Server:

 

TSQL script to get the index size and count in SQL Server:

 

TSQL script to get the index fragmentation details in SQL Server:

Here is the script file: TSQL script to get the index size and information in SQL Server

Posted in Performance Tuning, SQL Development | Tagged , , , , , , , , , , , | Leave a comment

Happy New Year 2017

Happy New Year 2017

Thanks to all our Readers, Authors, Advertisers and Partners for their everlasting support over the past 9 years. We really couldn’t do what we do without you all. Wish you a very Happy New Year 2017.

Team udayarumilli.com Wishing you a Happy New Year with the hope that you will have many blessings in the Brand New Year 2017 to come. Write it on your heart that every day is the best day in the year

List-out your priorities (Health, Family and Profession) today, make some resolutions and achieve your Goal.

Happy New Year 2017

happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017 happy new year 2017

Posted in Miscellaneous | Tagged , , , , , | Leave a comment

1000 Plus SQL Server Interview Questions and Answers

1000 Plus SQL Server Interview Questions and Answers

SQL THE ONE Book Preview

1000 Plus SQL Server Interview Questions and Answers

The book “SQL THE ONE” contains 1000 Plus SQL Server Interview Questions and Answers. This post takes you through the SQL THE ONE book preview and insights. SQL Server interview questions are categorized into 12 chapters which makes interview preparation easier. Below is the category wise question count:

Please click on the chapter name to view the top questions.

 

Chapter Total Questions
Chapter – 1: SQL Server Architecture 40 +
Chapter – 2: SQL Server Installations and Upgrades 100 +
Chapter – 3: SQL Server Security 70 +
Chapter – 4: SQL Server Backup & Restore 50 +
Chapter – 5: SQL Server Log Shipping 30 +
Chapter – 6: SQL Server Database Mirroring 40 +
Chapter – 7: SQL Server Replication 60 +
Chapter – 8: SQL Server Failover Clustering 70 +
Chapter – 9: SQL Server ALWAYSON 90 +
Chapter – 10: SQL Server Concurrency & Locking 50 +
Chapter – 11: SQL Server Performance Tuning 250 +
Chapter – 12: SQL Server DBA General 180 +

There are total 1000 Plus SQL Server Interview Questions and Answers available in this book and you would see most of the questions are answered with lengthy explanation which gives you more insights of the specific topic. Usually in any interview you might find a chain questions which means a question comes from the previous question answer. “SQL THE ONE” is not just for interview preparation it also helps you to quickly revise and understand the SQL Server concepts. For any comments / Feedback / concerns please reach us on sqltheone@gmail.com.

Visit here for more details about the book availability and formats

Posted in High Availability, Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , | 3 Comments