-
March towards SQL Server : Day 5 – SQL DBA Interview Questions Answers – Data File and Transaction Log File Architecture
This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not add any troubleshooting questionnaire in this blog because I will post a separate Questions\Answers blog for the same. 1) Explain the SQL Server Database Data File structure? SQL server divides the…
-
March towards SQL Server : Day 4 – SQL DBA Interview Questions Answers – Database Architecture and Database Properties
This article comprises of Questions answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, Backups, Restore, Data File and Transaction Log Architecture Questions from this series because I will cover them in a complete separate series on Database Backup, restores and File Architectures. 1) How many types of files…
-
March towards SQL Server : Day 3 – SQL DBA Interview Questions Answers – SQL Server Architecture
I am writing this blog based upon the Experience and knowledge which I gained after reading lot of Articles, Blogs, and Microsoft Documentation on SQL Server Architecture. Though it takes lot of time to collect this information and summarize it in a question series but I feel very proud and happy that I am giving…
-
March towards SQL Server : Interview Question & Answer series
March towards SQL Server. This is a series of interview questions & answers on a new topic every day for SQL DBAs. Special thanks to Parvinder Pal for his enormous efforts for SQL Community. Stay tuned for whole month. One Blog Daily! Casino welcome bonus rankings 2019 bonushitlist.com: we rank the top 100 online casino…
-
March towards SQL Server : Day 1 – SQL DBA Interview Questions Answers – Installation
I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. I have planned to segregate the entire questions series, topic wise to make it easier to explore. So here comes the First blog of this series based on SQL Server installation topic. I hope it…
-
10 Interesting things that ‘CAN NOT’ be done in SQL Server
I was just thinking about few interesting facts about SQL Server properties which are good to be known for a SQL Server DBA. You can not add data and log files in master and model database. You can not add User Defined File Groups in master, model and tempdb database. You can not change the recovery…
-
How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?
How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?
-
How to create Drop and Recreate Script of all Indexes in a database?
I found this interesting script once so thought of sharing with everyone. Special thanks to the Unknown-Creator of this script. This script generates the ‘create’ & ‘drop’ index script for each and every index in a database. I have tried this number of times and it does what is expected from it. What all you need…
-
SQL DBA Cheatcode Part 2 : Few Important Queries for any DBA
Hi Friends, From last few days, I was thinking about writing a series on Queries\T-SQL commands that we use in our day to day operations or those queries which should be handy for any SQL DBA(Junior or senior) out there. In this series, I’ll try to share as many queries as I have or I…
-
What are naming standards/conventions for SQL Server? (1/5)
I think it will be good idea to setup some naming standards throughout your database servers’ farm. Most of us already have these standards in place. And if there is nothing, I understand that it’s not going to be an easy task to implement standards, especially within an existing environment. BUT, it’s never too late.…
-
Common Human Errors as DBA (Part 3)
In continuation of the series of “Common Human Errors as DBA” – here I am posting Third Part of it. You may check others here. Part 1 & Part 2 Poor naming standards & Lack of documentation: This is a common mistake (not human error) that frequently happens. From the very beginning, a DBA…