And, of course, there's always the MSDN Books Online published by Microsoft. The documentation for SQL Server is always helpful to use.

Parameters or local variables? There is a difference. Parameters can be sniffed, sampled, so that the known value is used to retrieve statistics from your columns or indexes as part...

But they should.

More and more, it's a requirement for new functionality within SQL Server. Ultimately it's going to be a...

xsevensinzx (12/2/2015)

---

Can't stress semi-colons enough. I didn't have it in my sample, but it should be at the end of each statement. Don't forget to put it at the beginning...

Glad the book is proving useful. If you are interested in the aspects of the book not covered in the first chapter, database deployment, automation, source control, etc., we have...

Not that I know of. FORCE ORDER might do the trick. Forcing HASH or LOOP might also work. Experimentation is probably the only hope. It's just bad code.

GilaMonster (12/1/2015)

---

Yes, good teams do, because they know that making time to establish standards and practices saves time later on.

If...

GilaMonster (12/1/2015)

---

Grant Fritchey (12/1/2015)

---

GilaMonster (11/30/2015)

---

Welsh Corgi (11/30/2015)

---

If you have on Index with Column A and another Index with Column A and Column B can't you just have the Index with...

GilaMonster (11/30/2015)

---

Welsh Corgi (11/30/2015)

---

If you have on Index with Column A and another Index with Column A and Column B can't you just have the Index with Both Columns as...

For the slow query the optimizer is not seeing the old ANSI '89 style joins as having a join predicate. Everything goes south from there. I'm not entirely sure why...

WhiteLotus (11/30/2015)

---

Actually there is 1 query which confuses me , so I added cover index (non clustered index ( key column is ABC.number with included columns – all columns...

GilaMonster (11/30/2015)

---

Those rules should be agreed with your team. There's no hard and fast rules there, I would indent differently to how Grant did in the queries above. Neither of...

Most of the time, these days, you don't need to sweat disk placement... until you do. If you're experiencing serious IO issues, and you've worked with the SAN team to...

Plan forcing can't change the T-SQL syntax. Nothing can, other than rewriting the T-SQL syntax.

Sorry.

Nice!

Good job and congrats.