Any database with the recovery model set to Full will require log backups. If the log isn't backed up and autogrowth is enabled, you'll see auto grow occurring. Normal operations.

sjimmo (9/7/2016)

---

If you just move the tables, but not the data, what's the point. You could simply script the database. If you move the tables, but not the foreign keys,...

Nice work Luis.

The question is, what are your primary keys and your foreign keys. From the layout it could be either order number or order number and location or just location. Your...

Why?

If you just move the tables, but not the data, what's the point. You could simply script the database. If you move the tables, but not the foreign keys, constraints...

They did say thanks. That's more than we get sometimes.

If the function starts with the definition of a table like this:

...RETURNS @somename TABLE

(...

Then it's a multi-statement table valued function. You can read more about the three kinds of functions...

If you used extended events, you don't have to track down columns. The event package will include everything. It does make things easier. However, on 2008, you'll have to consume...

GilaMonster (8/31/2016)

---

So, I got roped into doing a professional development session for the local SQL Saturday.

"Becoming a successful SQL Developer"

Never done a professional development session before. Not sure how to...

Eirikur Eiriksson (8/31/2016)

---

Grant Fritchey (8/25/2016)

---

The...

Sergiy (8/31/2016)

---

Grant Fritchey (8/31/2016)

---

Sergiy (8/30/2016)

---

A clustered or covering index having the column used for the range selection...

Sergiy (8/30/2016)

---

A clustered or covering index having the column used for the range selection as a first...

Take a look at the Microsoft documentation.

Best thing to do here would be to set up an extended event session to capture the security changes.

Take a look at the wait statistics. Understand what is causing the server to run slow, if it is. It could be fine, but you'll only know by monitoring.

I would...