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

When you say "foreign", I assume you mean identifying any characters not belonging to the Latin General language. Maybe I'm way off base, but as a first stab, experiment to...

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 concern for number of...

What I've done is create a change order ticket for each deployment. ServiceNow happens to be the production control system we use. Within the source control system for each project...

How about a licensing model that simply charges for and caps the number of concurrent connections or non-system session SPIDs without concern for number of cores, distinct users (CAL), or...

Eirikur Eiriksson (1/20/2016)

---

...

...

Quite impressive, 28 operators in the execution plan, parallel execution, four full table scans and I'm now putting out the fire ignited by the CPU when running this...

Here you go. It's entirely possibly for multiple rows, or multiple columns within the same row, to tie for having highest date, so it will potentially return multiple rows in...

"Gut Feel"? There is a pill for that.

Jonathan-Fussell (1/20/2016)

---

I am a Linux user at home (MS Environment at work), I use Crossover (by Codeweavers) to run windows programs and it works really well. They make a version...

Someone should do a spoof of the mockumentary film 'A Day Without a Mexican'. The premise and title would be: 'A Day Without a DBA'.

http://www.rottentomatoes.com/m/day_without_a_mexican