The only thing I see you are missing is the check for is_default. If you have any other traces running on the instance you may be picking up that one....

dave-L (11/21/2012)

---

Our web-based app exposes these IDs in the URL. Although their is additional security checking when executing queries based on the passed in URL UUID, in our shop...

GSquared (11/21/2012)

---

opc.three (11/20/2012)

---

GSquared (11/20/2012)

---

opc.three (11/19/2012)

---

GSquared (11/19/2012)

---

Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow...

Why do you need randomness in your UUID?

Babar

Caruncles (11/20/2012)

---

Here are the results. Looks like quite a difference from the intital settings.

namedb_filename ...

GSquared (11/20/2012)

---

opc.three (11/19/2012)

---

GSquared (11/19/2012)

---

Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow accessing tables...

james.johnson 22741 (11/20/2012)

---

When I tried to modify the size of the tempdb on my system the results suggested that I was unable to specify the size of something smaller than...

Caruncles (11/20/2012)

---

Would timing-out errors be a symptom of improper TempDB settings? Especially, during peak times. We are in our busy season right now there is a lot...

It seems plausible. It appears tempdev has grown...

sql.com (11/20/2012)

---

Can you use Extended Events to track TempDB growth? I have read Jonathan Kehayias's article on tracking database growth, I wonder if that can be applied to tempdb too?

p.s....

dave-L (11/19/2012)

---

Thanks for all the comments. I have one more idea for addressing this. I'm thinking about partitioning my table. Everything that has already been created with...

Lowell has covered the database-level concerns well. All I'll add, at the server-level, is if you are concerned about the new vendor seeing databases other than their own when using...

GSquared (11/19/2012)

---

Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow accessing tables directly, then...

Jeff Moden (11/17/2012)

---

Apologies......