First you need to improve the select part of your query, also from your query it is difficult to understand to which table the field [Local_Date_Key] belongs.
Can you show...

The most appropriate solution is create a custom logon trigger. So I would say there is no appropriate solutions in the provided list...

For example, -mSQLCMD ...

Why 42?

Hi,

Will you consider someone who required visa sponsorship?

What is wrong with this answer?

CREATE NONCLUSTERED INDEX IDX_A ON #temp1(a)

Even though I agree that only order by guarantee the order...

Do you consider candidates who required H1B sponsorship?

In question, you should mention that first 2 steps should be performed on master database.

I failed my exam (88-986). I think it become more difficult than for SQL Server 2008 but it is only my opinion.

I did it in Berlin. Test center was very...

Can someone change the date of this question? It is July but should be June! Question from the future )))

In case of separate servers you will need additional MS SQL Server license.

Also I found that this index works much better for my query:

HowardW (6/5/2013)

---

It was new to R2, though, I believe? 2008 allowed the OS limit in...

After executing both queries many times, sometimes I1 overweight I2 but very rare. Looks like I2 is better, but it goes across with my knowledge.

I did test in this way:

create table:

populate it with data:

declare @i int=0;

while @i<100000

begin

insert dbo.orders(orderDate, orderType, orderAmount, orderDiscount)

values(

DATEADD(mi, -1*ABS(CHECKSUM(NEWID()) % 10000), GETDATE()),

ABS(CHECKSUM(NEWID()) %...

GilaMonster (6/3/2013)

---

Key columns, because the ordering of them may be useful to the optimizer and query processor. Very much depends on the rest of the index and the rest of...