Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Do you know what is a trace frag? Where do we use it?
What is a collation?
How would you use user_constraints table in DB?
What are the different authentication modes in sql server?
which table keeps the locking information? : Sql server administration
How to add additional conditions in SQL?
What is blocking and how would you troubleshoot it? : sql server database administration
Explain linked server in sql?
Tell me what is fill factor?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
what's new in sql server 2016?
What are the instances when triggers are appropriate?