I hope that mission critical software for things like airplanes and nuclear reactors don't run on Windows or Linux. I'd expect something like an embedded chip that contains both the...

Stuart Davies (8/17/2015)

---

I have two:

Live

and my laptop.

This can often make my life "interesting" as the Live servers are running SQL 7 , 2000, 2005, 2008 R2 and 2012.

Don't...

tfeuz (8/14/2015)

---

I will Check that index!

when I refer to the server being slow here are some examples

- sms takes a good 3-5 minutes to open before it even...

... I will also point out that simply just navigating around their server is extremely sluggish - whether we are in SQL or not. We are highly suspicious that there...

g.britton (8/14/2015)

---

I just wish it wasn't called a "Tally" table. I don't tally things, I count them. fwiw I usually call my "tally" table "N" to reflect it's relation...

Jeff Moden (8/14/2015)

---

I'll strongly second that wish. I also wish that there were a way to...

Copying database1 to server2 and finding that the runtime drops to normal range was useful in that you've confirmed it's probably an issue with the server. However, to properly diagnost,...

Daily build and prototyping (local)

Team development

QA

UAT

Production

Disaster Recovery (ostensively)

Grant Fritchey (8/13/2015)

---

They should be. They don't have to be. I'd sure put them up there. You'll pay for those VMs, but those costs should, by and large, be less...

Sean Lange (8/13/2015)

---

SQLRNNR (8/13/2015)

---

Or a user-defined table type?

Better yet...

A user defined memory optimized table...

Long overdue praise for the lowly tally table. I declare August 33rd as the official Tally Table Appreciation Day.

Grant Fritchey (8/13/2015)

---

Eric M Russell (8/13/2015)

---

SQL Azure should be technically up to the task. However, my understanding is that you get billed based on network transfer fees. How many GB...

Generally speaking:

Table variables have scope limited to what one would expect with other types of variables, and it allow for fixed plans, which is a strong and compelling reason to...

SQL Azure should be technically up to the task. However, my understanding is that you get billed based on network transfer fees. How many GB total of data do you...

Luis Cazares (8/13/2015)

---

Eric M Russell (8/13/2015)

---

Luis Cazares (8/13/2015)

---

Ed Wagner (8/13/2015)

---

Eric M Russell (8/13/2015)

---

But where do you get your tally? There are examples out there; Jeff's is popular. However, it would...