Microsoft SQL Server Interview Questions And Answers (SET -11) You are considering consolidating a number of your existing SQL Servers onto a new, large SQL Server 2005 server. You have 3 SQL Server 6.5 servers, 6 SQL Server 7.0 servers, and 16 SQL Server 2005 servers. You cannot make any application changes, but you can [...]
Microsoft SQL Server Interview Questions And Answers (SET -10) What result would you expect from this statement? Select * from dbo .MyTable All records from [dbo].[MyTable] The answer is all records from [dbo].[MyTable]. Qualified names can include white space before and after the dots. Restrictions apply only to the names themselves that may need quoted [...]
Microsoft SQL Server Interview Questions And Answers (SET -9) What does this method in SQL Server 2005′s SMO equate to in T-SQL? db.CheckTables(RepairType.None) DBCC CHECKDB WITH NO_INFOMSGS This SMO method executes a DBCC CHECKDB with the NO_INFOMSGS option set. In SQL Server 2005, can you include a user-defined role as a member of another user-defined [...]
