Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How to get a list of all tables with "sys.tables" view in ms sql server?
List some case manipulation functions in sql?
When you should use a low fill factor?
What do you mean by authentication modes in sql server?
Do you know what is sql injection?
What is nonclustered index with included columns ?
Can you explain what is indexed view? How to create it?
explain different types of joins? : Sql server database administration
can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)
What is SCOPE_IDENTITY() in sql
What is faster join or union?
What is log in sql server?