Gene Roddenberry invented the floppy disk, just like invented the smart...

I'm sure that scribes in ancient Egypt saw papyrus as an innovation over clay tablets. However, today most of what we know about Egypt comes from the clay tablets as...

So this basically just T-SQL with additional extensions for sourcing from or outputting to flat files and also perhaps analytical functions?

It's easy to give away millions when you have billions; you just setup a charity, skim a small percentage of profit off the top, and appoint other people to muck...

chris 24158 (6/17/2016)

---

The latest series of posts you enjoy so much from Microsoft says:

I can’t emphasize this patch enough. There is a MSVC, runtime library patch needed by...

Jeff Moden (6/20/2016)

---

Eric M Russell (6/20/2016)

---

Jeff Moden (6/17/2016)

---

As a bit of a sidebar and like anything else in SQL Server, saying something like the use of SELECT * always being...

In addition to table scans, another common problem is hash match joins, which occur when SQL Server builds up an index on the fly, consuming time and tempdb storage, when...

Jeff Moden (6/17/2016)

---

As a bit of a sidebar and like anything else in SQL Server, saying something like the use of SELECT * always being bad is the wrong thing...

Jason A. Long (6/17/2016)

---

Eric M Russell (6/17/2016)

---

Using index operational stats, if you see an index where the total writes exceeds the total reads, then it probably useless. But generally speaking,...

Using index operational stats, if you see an index where the total writes exceeds the total reads, then it probably useless. But generally speaking, I'm comfortable with non-clustered indexes contributing...

Jeff Moden (6/16/2016)

---

HappyGeek (10/21/2015)

---

Not quite sure this is the right place for this, forgive me if I have it wrong. :blush:

To rapidly document a database I open Excel, start...

Steve Jones - SSC Editor (6/15/2016)

---

TheFault (6/15/2016)

---

Having worked at a company who are supposed 'industry experts' in data security, I can tell you it is no better behind closed doors...

Luis Cazares (6/17/2016)

---

Eric M Russell (6/16/2016)

---

In the past there was an ETL process where a standard deviation in record counts based on the previous X runs would flag the dataset...

In the past there was an ETL process where a standard deviation in record counts based on the previous X runs would flag the dataset in staging and prevent it...

Some coding practices, like cursors and SELECT *, are known to be bad and you can spot them just be reading the code or performing a text search across your...