Are you the kind of DBA who rebuilds all indexes nightly? Your differential backups can easily be nearly as large as your full backup. That means you’re taking up nearly twice the space just to store the backups, and even worse, you’re talking about twice the time to restore the da...
This article will help you with some popular SQL Server DBA Interview questions and answers. I would recommend you to read this article as well asSQL Server Interview questions and answersto learn more about SQL interview questions. In this article also, I tried to answer each question in a ...
Interview Categories: DB Programming Btrieve Clipper Data Modeling Data Structures Database Administrator (DBA) Database Analyst Database Developer Database Hierarchical Database Network DB Development EDI/Data Integration Expert Firebird IBM DB2 Informix Java Database MariaDB Microsoft Access Developer Mongo...
Prepare yourself for PostgreSQL from ourPostgreSQL DBA Interview Questionsblog 19. Which Cursor Attributes are the Result of a Saved DML Statement, when it is Executed? The statement’s result is saved in four cursor attributes. The four attributes are: ...
Most Frequently Asked SQL Server Interview Questions 1. Compare SQL Server with Oracle. 2. How can SQL Server instances be hidden? 3. Can we add a CPU to SQL Server? 4. How can we check whether the port number is connecting or not on a Server DBA? 5. How can you start SQL Server...
sql server interview questions,SQL DBA interview at Microsoft,SQL DBA Interview questions,SQL Server interview,SSAS interview questions,SSIS interview questions,SSRS interview questions,T-SQL interview Question,Tech Mahindra Interview Questions,tech mahindra sql server interview questionsVirtusa Interview ...
若你觉得你就是干不了开会,扯皮,来回折腾的活儿,就喜欢指挥机器干活,那就选择偏技术的方向,比如运维DBA,数据库研发。从事这条路线,意味着你要懂的更多的边角料知识,比如操作系统,网络协议,自动化编程,架构设计,分布式计算,云计算等。这些知识资料早已有现成的资料可以参考,只要耐得下心来学,一定有成功出头的那一天...
This is a very important question and you better be able to answer it if consider yourself a DBA. SQL Server books online is the best place to read about SQL Server architecture. Read up the chapter dedicated to SQL Server Architecture. 13. What is lock escalation? Lock escalation is the...
tmp.sql_class_question where status=7 然后再看id连续增长的次数。跟前2个小题不同,连续登录失败次数,连续的变化点是此次登录失败,上次登录成功;而id连续增长的变化点是此次的id与前一次id的差值不是1,因此同理的思路,代码如下: with tt as ( select id,log_time ,lag(id) over(order by log_time) id...
Note :- Check MSDN for list of all DBCC commands, it is very much possible specially during DBA interviews they can ask in depth individual commands.Below is a sample screen in which DBCC SHOWCONTIG command is run. DBCC SHOWCONTIG is used to display fragmentation information for the data and...