|
|
-
|
|
What are the requirements for setting up database mirroring?
Additional question: can you mix versions in mirroring (e.g. 2005 and 2000)?...
|
|
-
|
|
What are the limitations with SQL Functions or what are the disadvantages of User Defined SQL Functions?
...
|
|
-
|
|
How many non clustered indexes can be created in SQL Server?...
|
|
-
|
|
Which SQL Server database does not follow ACID properties? Explain the reasons behind your answer....
|
|
-
|
|
While database is recovering, after which phase will the database be available/online?...
|
|
-
|
|
When you create a stored procedure you provide an option with RECOMPILE
What does this do?...
|
|
-
|
|
In SQL SERVER, what are EXCEPT and INTERSECT?...
|
|
-
|
|
If a table has no clustered index defined on it, What it will be called?...
|
|
-
|
|
One of my favorite SSIS questions: Is it possible to use a lookup transform when the source are both flat files, and we do not have staging tables to dump these data, in SSIS 2008?...
|
|
-
|
|
In what way an identity field differentiates the delete and truncate command?...
|
|