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

Ed Wagner (1/19/2016)

---

Eric M Russell (1/18/2016)

---

Ed Wagner (1/18/2016)

---

One thing to consider if you're going to run SQL Server locally is memory. SQL Server loves memory. Whatever you give...

Jacob Wilkins (1/18/2016)

---

Yup, that's what my proposed solution does. Just have to account for the fact that the bitwise operator is...

Why not use the T-SQL bitwise operators?

https://msdn.microsoft.com/en-us/library/ms174965.aspx

For example:

3 & 0 = 0

3 & 1 = 1

3 & 2 = 2

3 & 4 = 0

123456 & 1 = 0

123456 & 2...

Ed Wagner (1/18/2016)

---

Eric M Russell (1/18/2016)

---

Another scenario that can cause page splits is when users are updating columns contained in the table's clustered key, and this applies not only to...

Ed Wagner (1/18/2016)

---

One thing to consider if you're going to run SQL Server locally is memory. SQL Server loves memory. Whatever you give it, it will happily use...

If you have the Micrsoft developer stack installed on your PC at work, and you're essentially wanting to experiment and learn from comfort of home after hours, then consider using...