Category Archives: SQL Development

What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL in SQL Server 2012?

What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL Q. What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL in SQL Server 2012? Ans: Before dig into these data types we must have a … Continue reading

Posted in SQL Development | Tagged , , , , , , , | 3 Comments

SQL Server Backup and Restore Interview Questions

SQL Server Backup and Restore Interview Questions   Here are the list of SQL Server Backup and Restore Interview Questions which are asked in SQL Server DBA interviews. 1. How does the database recovery model impact database backups? Ans: First the … Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , | 14 Comments

SQL Server Architecture Questions and Answers

SQL Server Architecture Questions and Answers   Here are the list of Sql Server Architecture Questions and Answers which are asked in SQL Server developer / DBA  interviews Q. Can you draw SQL Server architectural diagram with all the components? … Continue reading

Posted in Database Design, Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | 60 Comments