-
Series : SQL DBA Cheatcode
SQL DBA Cheatcode is a series or you can say a collection of those SQL Server scripts which we find very useful while troubleshooting issues day to day. These scripts are trusted and tested however there are some chances that a script may not work with some versions of SQL Server. SN Date Topic Part…
-
March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning
Dear Reader, Today, I thought of writing interview questions on SQL Server Performance Tuning. I tried my best to touch upon many areas however Performance Tuning is something that can’t be covered end to end – you know that. Let me try starting from basic concepts to some scenarios type question. What is the use…
-
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…
-
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…