GilaMonster (1/2/2014)

---

Implying that Management Studio is badly written (but we already knew...

david.alcock (1/2/2014)

---

Grant Fritchey (1/2/2014)

---

The application name is a connection string bit of information that you can put anything in. You could say "Bob" for the application and SQL Server wouldn't...

Perry Whittle (1/2/2014)

---

Unless its an FCI then you are required to use shared storage not...

The only way to determine "normal" for any system is to measure it over time.

The application name is a connection string bit of information that you can put anything in. You could say "Bob" for the application and SQL Server wouldn't know what you're...

If you want the redundant storage that a SAN gives you, yes. If you want faster performance for the system databases, you might consider local storage. Everything is a tradeoff.

In the free arena you might want to check out Kendal Van Dyke's Powershell scripts.

Unless there's a specific reason for it, 4 logins/sec isn't freaking me out. It's just an indication of load, not a problem.

Jeff Moden (12/30/2013)

---

Grant Fritchey (12/30/2013)

---

Jeff Moden (12/29/2013)

---

Grant Fritchey (12/18/2013)

---

I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much...

Jeff Moden (12/29/2013)

---

Grant Fritchey (12/18/2013)

---

I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about the key structure...

Marek Grzymala (12/30/2013)

---

Except that in SQL 2000 there is no sysschedules table. What worked for me was this:...

You either already have that foreign key in place, or the data there is different between the two tables and is preventing you from putting it into place.

masoudk1990 (12/24/2013)

---

Much appreciated, Ive read from somewhere if I use QUOTENAME(@FieldName,'''') with 4 single quotations, it makes stored procedure bullet proof from sql injection, but Im still in doubt if...

MadAdmin (12/23/2013)

---

So Diff's don't worry me too much.

A failed backup is of course top...

In addition to the Books Online, I'd recommend getting a copy of SQL Server Internals by Kalen Delaney. It might be over your head now, but the more you study...