Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script these exports...

Just checked. I've got a list about 3-4 times as long as that, plus those objects. I suspect you might be experiencing a bug of some sort.

Jeff Moden (4/28/2016)

---

Ah, careful now. Specifically, REORG does NOT rebuild stats. ...

I've reformatted the code so that it's readable:

SELECT POC.[Prod_ Order No_],

CASE WHEN POC.Status = 1 THEN 'Planned'

...

It just means that on a given server, the DLL and EXE files that make up the behavior of SQL Server can, for the most part, be installed once, and...

It still sounds like the stats are getting stale. If the statistics get...

Steve Jones - SSC Editor (4/27/2016)

---

tindog (4/27/2016)

---

I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know anyone! (Never...

Track me down and say Hello. I get there Thursday afternoon (assuming the trains work).

Thanks for reporting back. Glad what I said was helpful.

I would follow the recommendation from Jonathan Kehayias[/url].

SQL Server will use every bit of RAM that you give it (assuming you have enough data to fill the cache).

For a good calculation of how much RAM you should...

rodjkidd (4/27/2016)

---

Steve Jones - SSC Editor (4/26/2016)

---

rodjkidd (4/26/2016)

---

TomThomson (4/26/2016)

---

Trains? ...

Steve Jones - SSC Editor (4/26/2016)

---

rodjkidd (4/26/2016)

---

TomThomson (4/26/2016)

---

Trains? UK...

GilaMonster (4/26/2016)

---

Grant Fritchey (4/26/2016)

---

GilaMonster (4/26/2016)

---

Grant Fritchey (4/26/2016)

---

I do not recommend this because it will seriously negatively impact your startup time, but if you really want it to immediately use the...

SQLRNNR (4/26/2016)

---

jeff.mason (4/26/2016)

---

I was thinking Rey, Finn and Kylo. They obviously need a villain figure, but the idea of an emo Dark Lord who has no control of his...