Login with Windows authentication and be logged into windows with the account that you installed the instance as. Part way through the installation it would have prompted you for windows...

lw1990 (1/8/2016)

---

I tried it as you said. But after I detached the old database and was trying to restore to it, I got the "database is in use" error when...

Because it's not an explicitly granted permission. It's part of what CONTROL SERVER grants (which is basically sysadmin rights). You can DENY the right, and the DENY will overrule the...

You don't need to create a new database and then restore over. Doing so is why you got an error, the database in the backup didn't match t\he one you'd...

Edit: nm

er.mayankshukla (1/8/2016)

---

In a unique non clustered index, the clustered key comes to leaf level only

in a non unique non clustered index, the clustered key comes to leaf and non leaf...

It's the number of milliseconds that the query spent actually executing (as opposed to

Can we convert that value to a...

A couple things

The waits are cumulative since SQL started. So unless you're taking snapshots and comparing them, a change won't appear to have had any effect because there's all the...

True, I overcomplicated things a little.

The = should have been a LIKE, sorry about that....

Look at the two pieces I gave you. The one I said you can't do is what you're trying. So take the one I said you can do (which is...

The thing to remember is that the output of the CASE statement is an expression, not a piece of code. That is, it's something that you could put after a...

Looking at the score, you probably missed it by one or two questions.

For aggregates, read up and practice group by, the aggregate functions (sum, count, min, max, etc), practice using...

Probably yes. You'll get a...

Won't be related to TempDB. If it was, the temp table one would have performed badly as well.

It probably comes down to row estimations. With local variables, the optimiser can't...