rambilla4 (4/6/2010)

---

On a san, assuming it's properly configured, what you're seeing as "disks" in your OS and SQL Server should be, not a single monolithic disk, but a whole bunch...

It doesn't sound like a trigger is what you're looking for, especially since you're trying to check for a negative, rows that have not been added to the table. Since...

I'm unaware of any systemic issues with Server 2008 R2. Were any other changes introduced to the system? I'd suggest drilling down at the OS level to see what might...

Yes, I definately recommend running server side traces to capture query calls for performance metrics. But be careful here. Don't run the SQL Profiler GUI against your production systems. You...

It sounds like you're just getting started working with databases. I'd suggest a few things. First, be sure that you're not doing these experiments and learning tasks with your companies...

rambilla4 (4/6/2010)

---

Hi,

We have SQL Server 2005 EE x64 with SP3 and have the storage on SAN with RAID 10 configuration

and have the below drives:

C- OS

D- Data

E- Log

T -TempDB

Z- Backup

Total...

2008 does offer the query governor as a mechanism for preventing long-running queries. You can also set a a remote server connection timeout setting for the server, however, this is...

To be completely honest, one of the best things you can do is learn to operate the search routines either on google or here at SSC. For example, your question,...

Steve Jones - Editor (4/2/2010)

---

Definitely version specific, though I'd also add I...

CirquedeSQLeil (4/2/2010)

---

Grant Fritchey (4/2/2010)

---

Lynn Pettis (4/2/2010)

---

I also believe that the certification should be renewed periodically, minimum 3 years, maximum 5 years.

Recertification should include testing, presenting original material at users groups/conferences,...

Lynn Pettis (4/2/2010)

---

I also believe that the certification should be renewed periodically, minimum 3 years, maximum 5 years.

Recertification should include testing, presenting original material at users groups/conferences, attending appropriate conferences...

Well that depends on the context. Depending how you are connecting to the database server, different rules are going to apply....

CirquedeSQLeil (4/2/2010)

---

You make a good argument against the Time in Service.

If we drop the time in service, would we implement more tests? I see more tests as a way...

TheSQLGuru (4/2/2010)

---

I don't understand this talk about numbers since the OP clearly stated "... a code with numbers and characters". Can't put those characters in an int, bigint, numeric,...

I think the time in service, as part of the bridge between MCTIP and MCM, actually adds unecessary overhead that is simply going to be gamed anyway. I'm assuming this...