What is the default Port No on which SQL Server listens?
What is difference between table aliases and column aliases? Do they affect performance?
Can we use trigger new in before insert?
Is sql server free?
How to create a new table in a given schema?
Does full backup break log chain?
What is Files and Filegroups in SQL Server & it's implementation.
Where do you think the users names and passwords will be stored in sql server?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is the security principal at the server level that represents your session?
What are sql server functions?
Can a database be shrunk with users active?
What is collation sensitivity? Explain different types.