Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
1058you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
939Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
1028You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
1098You 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?
1117What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
988
How you can minimize the deadlock situation?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Difference between connected and disconnected database in .net with sql server?
what purpose does the model database serve? : Sql server database administration
What is a not null constraint?
What is sub-query in sql server?
What is the difference between Normalization and De-normalization?
What is the sql server 2000 version number?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is purpose of normalization?
Benefits of Stored Procedures?
What is importing utility?
What is mssql?
Difference between aggregate functions of sql?
What is the need for group functions in sql?