From what I've seen, often times...

Your boss may be the simple one to request such a thing. However, to fullfill the...

When crafting a resume, keep in mind that your primary audience is either a recruiter (external or internel to the organization) or a non-technical HR manager. That's who gets the...

GilaMonster (1/22/2016)

---

Or a committed transaction. It's a page that has been...

Ed Wagner (1/22/2016)

---

mjh 45389 (1/22/2016)

---

I think I am somewhat underpaid but I do work in a pleasant location with agreeable individuals which is worth a lot in itself. The problem...

A dirty page is simply a page that been written to during an active (ie: uncommitted) transaction. Normally (when default READ COMMITTED is in effect) readers will attempt to take...

Gary Varga (1/22/2016)

---

Eric M Russell (1/22/2016)

---

Gary Varga (1/22/2016)

---

Eric M Russell (12/22/2015)

---

Remotely hacking another driver's Bluetooth component system is a way cooler and less violent way to express road rage than...

There are a lot of IT departments who get some extra funding in their budget and then try to fill slots with warm bodies in an extremely short timeframe. Maybe...

As the DBA, you may not be able to stop developers from not following design rules in development, but you at least should stand between development and production. You do...

Gary Varga (1/22/2016)

---

Way...

Yes, as with any major purchase like automobiles or realestate, it may...

Most languages, particularly scripting languages like JavaScript and PHP (ie: Eval function), support dynamic execution. It's just more problematic with SQL because it's a language that enables retreival and modification...

sql-lover (1/21/2016)

---

Eric M Russell (1/21/2016)

---

sql-lover (1/21/2016)

---

Eric M Russell (1/21/2016)

---

The DMV dm_exec_procedure_stats returns one row for each cached stored procedure plan. There can be multiple cached plans for a single procedure...

sql-lover (1/21/2016)

---

Eric M Russell (1/21/2016)

---

The DMV dm_exec_procedure_stats returns one row for each cached stored procedure plan. There can be multiple cached plans for a single procedure (database_id, object_id). The column...

The DMV dm_exec_procedure_stats returns one row for each cached stored procedure plan. There can be multiple cached plans for a single procedure (database_id, object_id). The column 'plan_handle' is the plan...