Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What is SQL Profiler?

SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. A programmer can capture and save data about each event to a file or SQL Server table to analyze later.




Next 5 interview question(s)

1
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
2
What is OLTP (Online Transaction Processing)?
3
What are different types of Collation Sensitivity?
4
What are the different index configurations a table can have?
5
Which TCP/IP port does SQL Server run on? How can it be changed?