sql-lover (8/14/2014)

---

-- Another UPDATE ---

After testing on my Dev box I finally deployed the trace flag on two of our live servers. So far so good. And crossing fingers, it...

sgmunson (8/13/2014)

---

Indeed, 9 million rows is an awful lot of data. Also, even assuming the report still has to exist, your execution plan is suggesting an index creation...

I'm not saying that the Microsoft development stack should be used for building the Air Force's mission critical systems (ie: deployed in the field in Iraq). A strong an compelling...

Using the MS SQL Server, MS Office, and MS VisualStudio stack, you can build practically any IT solution, and it integrates well. Often times the tools will integrate, but the...

jay-h (8/11/2014)

---

Eric M Russell (8/11/2014)

---

jay-h (8/11/2014)

---

If the news stories about badUSB are correct even...

jay-h (8/11/2014)

---

If the news stories about badUSB are correct even devices like keyboards or...

Gary Varga (8/11/2014)

---

Eric M Russell (8/11/2014)

---

Microsoft, after taking some hits for their "insecure by default" configurations and applications, tightened things up greatly. It caused project time lines to be extended...

Microsoft, after taking some hits for their "insecure by default" configurations and applications, tightened things up greatly. It caused project time lines to be extended and delayed shipping on some...

This thread make me think of something else from the past. Using the little known STATS_STREAM option of the CREATE STATISICS statement, you can re-create production statistics in another database...

sql-lover (8/8/2014)

---

We're about to try trace flag T272 as a startup parameter on one of our SQL servers. This trace flag brings the Identity key generator to its previous SQL2008...

GPO (8/7/2014)

---

Every column nullable. No constraints. Not even a primary key. No indexes. I think someone is pulling your leg. What possible reliable use could it be? I'm tempted to...

Gary Varga (8/7/2014)

---

Eric M Russell (8/7/2014)

---

Miles Neale (8/7/2014)

---

Eric M Russell (8/7/2014)

---

The Fault (8/7/2014)

---

Eric M Russell (8/7/2014)

---

Even if the QA environment only has 10% the data volume as production; so long...

Miles Neale (8/7/2014)

---

Eric M Russell (8/7/2014)

---

The Fault (8/7/2014)

---

Eric M Russell (8/7/2014)

---

Even if the QA environment only has 10% the data volume as production; so long as the object schemas, configuration,...

The Fault (8/7/2014)

---

Eric M Russell (8/7/2014)

---

Even if the QA environment only has 10% the data volume as production; so long as the object schemas, configuration, and data cardinality are equivalent,...

Staging a high transaction volume OLTP environment for QA and performance testing is actually much harder than a data warehouse environment. Data Warehouses tend to be static with fewer users....