There's a lot to it. I wrote a book on the topic (look in the links below). But, to get you started, I'd recommend this blog post.[/url]

If I have a query that searches:

WHERE Col1 = @val1 AND @Col2 = @val2 and @Col3 = @val3

It's pretty likely that first index is better. But, if I have a...

That's an interesting solution.

Not sure what you're referring to.

Not questioning Gail at all, because I'm sure she's right, but, you did you try compiling those queries natively? That's where some of the bigger performance results are achieved. Gail...

If they even do an SP. I've...

hans.pret (4/2/2014)

---

I got more information on this.

I reviewed the sql logs again and saw that a checkpoint is created in the master database every time the server is restarted. If...

You have to change your code to use the full text index. It's not like a regular index where the optimizer just picks it up. You need to read up...

GilaMonster (4/1/2014)

---

I don't have too much beef with the language, but the way the fans talk about it, you'd think it was about to end poverty and bring about world...

Take a look at the execution plan. It's possible that you're seeing scans across all those other tables. Maybe some indexes are in order.

Nothing was available until 9AM West Coast time. I understand most of it's online now. I just used Azure to spin up a VM. A lot quicker than downloading if...

Jeff Moden (4/1/2014)

---

jasona.work (4/1/2014)

---

Grant Fritchey (4/1/2014)

---

jasona.work (4/1/2014)

---

April 1st, the day when the internet loses its collective mind (did it ever have it to begin with?) and starts throwing out "jokes"...

Ditto. I'm 51.

The one recommendation I can make is that the defaults don't really work well as your databases get bigger. Growing by percentages gets worse as the databases get larger ...

jasona.work (4/1/2014)

---

April 1st, the day when the internet loses its collective mind (did it ever have it to begin with?) and starts throwing out "jokes" (term used loosely, your sense...