Brandie Tarvin (12/16/2014)

---

WHOO! #HappySnoopyDance

I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.

Current execution...

WHOO! #HappySnoopyDance

I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.

Current execution time ......

ramana3327 (12/13/2014)

---

We created a seperate login. And gave db_owner permissions for the remaining databases. But my doubt is about the server level permission.

We are assigned public server role to that...

Yes. That will prevent them from accessing server level...

ScottPletcher (12/11/2014)

---

Don't forget the other side of the issue.

Have you compressed large indexes when useful?

Have you reviewed that you have the best clustered index on each table? After that,...

Brandie Tarvin (12/11/2014)

---

There is your...

If you are sure that your growth rate holds steady at 70 GB per month, then take that number multiplied by the number of months you're projecting. Add that to...

So again, what are you trying to accomplish?

Without that context, your original question is rather meaningless to the rest of us.

As much as it pains me to say this (because it could cause performance issues), I think your best bet is to put in an AFTER trigger to rollback the...

I've never actually disabled any login except the sa and guest (old days) logins. And so far as I know, that's a server-level setting only. I'm pretty sure that once...

I think you are correct. I would advise creating a server level public login to go with that DB login, though, for ease of maintenance and to prevent it from...

GilaMonster (12/11/2014)

---

Depends how often you want to add space to your drives.

There's no need to have free space on the drive, as long as there's free space in the database...

I apparently am not understanding what your needs are. Do you need to size the database for auto-growth? Are you trying to add more space to the drive where your...

pdanes (12/11/2014)

---

I didn't specify schema, and in fact, have no idea how a schema could be...

There is your answer right...