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

Wayne West (1/21/2016)

---

Eric M Russell (1/21/2016)

---

Also, Microsoft TechNet provides pre-configured virtual labs (a browser based on-demand VM) to go along with topical step-by-step instructional videos. You only need a Microsoft...

ZZartin (1/21/2016)

---

Eric M Russell (1/21/2016)

---

Alex Gay (1/21/2016)

---

Eric M Russell (1/21/2016)

---

How about a licensing model that simply charges for and caps the number of concurrent connections or non-system session SPIDs without...

Also, Microsoft TechNet provides pre-configured virtual labs (a browser based on-demand VM) to go along with topical step-by-step instructional videos. You only need a Microsoft Live login ID to spin...