It won't delete data, but you really want to remove the Shrink Database option from your maintenance plan.

For more information, read this (and the links in that article): http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/

Sean Lange (12/2/2015)

---

That is...

Gazareth (12/2/2015)

---

jasona.work (12/2/2015)

---

Hmm...

Here's a way to maybe sort of settle the semi-colon discussion amongst the forum dwellers!

PAINTBALL!

Split into two teams, semi-colon as statement terminators vs semi-colons OK at the start...

Scalar UDFs have problems with plan/row estimates. I'll try to avoid them at all costs. Maybe this can give you an idea on how to improve it: http://www.sqlservercentral.com/articles/T-SQL/91724/

GilaMonster (12/2/2015)

---

We can compensate for badly written code with more badly written code. Excellent plan.

Correctly terminate all statements with a semicolon (they're statement terminators). The end.

If someone did not...

xsevensinzx (12/2/2015)

---

GilaMonster (12/2/2015)

---

!Gah !No

.A semicolon is a statement *terminator* .It is not something that gets placed at the...

Are your referring to the square brackets or the unrelated table aliases?

JustMarie (12/1/2015)

---

Why not use _sp as a suffix? It still shows that the code is a stored procedure and lets you group things by name much more easily.

I've advocated...

I agree on having a team standard for code formatting. However, if you want examples, here's one that I created some time ago. One image is described and the other...

You shouldn't use an index hint to be sure that the index is being used. If it's useful, it should be used automatically. If it's not used, maybe the query...

Do you really need the hints? Do you understand the problems of NOLOCK? Why do you need to specify the index? Wouldn't the query processor use it? Why not?

Check this article for better (or actual) help:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

You have 2 options. One is exactly the same as the query that you have, and the other one will bring additional rows. I won't tell you which is which...

It's called a correlated subquery. Basically, for each ID in the JOB table...

Then it might depend on the platform. Oracle has something called START WITH...CONNECT BY which could help you.

If you give...