milos.radivojevic (3/21/2014)

---

You cannot say in advance if Key Lookup is good or bad. If your query needs to return several columns you cannot avoid it (or you can if you...

In general a key lookup means that the index used didn't have all the columns available so it had to go to the clustered index to get those missing columns....

Yeah, I'm with Luis. Most tables should have clustered indexes. Since it stores the data, it should generally be the primary path to the data. That's not necessarily the primary...

Availability Groups are a mechanism for setting up the ability to fail a database or a set of databases from one server to another. With this setup, there is nothing...

You can run Hadoop on Windows just fine. I've done it. Micrososft does have a port of it available in Azure called HDInsight. Here's a link to check it out[/url]....

roblew 15918 (3/21/2014)

---

Thanks,...

Backing up Gail, piling on and reinforcing this one.

REPAIR_ALLOW_DATA_LOSS is extremely dangerous. It will attempt to fix the database without any regard to your data at all. You could lose...

If you don't mind spending a little money, Red Gate SQL Prompt[/url] is a tool that I can't live without. It formats your code. And it provides code completion way...

If, logically, you need all the rows from one table, but only the matching rows from another table, then some type of OUTER JOIN is necessary. They're not inherently evil.

VMs are pretty solid and work quite well. Just as well as physical machines these days if they're properly set up and maintained. But, performance could be an issue there...

Other than what Gail outlines, which is a good way to get a new plan every time, why are you trying to "ignore the cache"?

Can you tell what is slowing down the inserts? I mean other than the obvious, this index sucks. What does the execution plan look like? What are the wait stats...

I'm curious what you mean by administration commands? Except for the direct manipulation of data within the tables (and even that) almost every single command is going to be an...

If it's integer data, use the integer data type. Done.

Numbers in general are stored basically the same way within SQL Server. The only differences really are in the size and...

Rebuilding the log file requires that no open transactions exist in the database. Try deleting the log file and attaching the database without the log. It might not work, but...