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

Brandie Tarvin (6/10/2016)

---

Steve Thompson-454462 (6/10/2016)

---

Brandie Tarvin (6/9/2016)

---

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you...

ScottPletcher (6/15/2016)

---

Eric M Russell (6/15/2016)

---

Jeff Moden (6/14/2016)

---

Eric M Russell (6/14/2016)

---

You'll rarely ever be asked pop quiz style questions like "What is a clustered index?" or "How do you get...

Jeff Moden (6/14/2016)

---

Eric M Russell (6/14/2016)

---

You'll rarely ever be asked pop quiz style questions like "What is a clustered index?" or "How do you get the current date and...