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...

Rows are not guaranteed to return in any specific order unless you specify an ORDER BY clause. Please provide the DDL for the table so we have a better picture...

Changing the clustered key from a ramdom GUID to a sequenial integer will help prevent page splits, so that that helps reduce I/O and blocking during inserts. It appears that...

Wayne West (1/21/2016)

---

Eric M Russell (1/21/2016)

---

... With connection pooling, the number of SPIDs won't measure the total number of "users" or "seats", but counting concurrent SPIDs can be used to...