13K IOPS at 64KB seems pretty good to me.

TheSQLGuru (9/23/2014)

---

2) You have no explicit begin tran/commit tran, so the log buffer flushes KILL you here. Do that and see...

I'm thinking that 'System.OutOfMemoryException' means you're out of the memory you're allowed, rather than the server itself is out of memory. In Powershell the default seems to be 1GB so...

GilaMonster (9/14/2014)

---

Sometimes advice on a blog still scares me. Not often, but sometimes. Like today

Consider using a RAMDisk for Index filegroups.

Putting non-clustered indexes on a RAMDisk...

Nope, absolutely fine. Just don't shrink them to...

As regards the query, are there any indexes on the table in the 2008 server that aren't on the 2014 one?

There's some info here on configuring Memory usage in Powershell: http://blogs.technet.com/b/heyscriptingguy/archive/2013/07/30/learn-how-to-configure-powershell-memory.aspx

Beyond that, as a complete guess, try writing/appending to a file instead of the console?

Found this: http://www.dbi-services.com/index.php/blog/entry/sql-server-2014-select-all-users-securables-a-db-admins

Short story, Grant Control Server & Deny Select All User Securables.

But the deny can be overridden by the grantee.

I remember hearing something similar too when SQL 2014 was announced.

SQL 2014 introduces 3 new permissions:

CONNECT ANY DATABASE

IMPERSONATE ANY LOGIN

SELECT ALL USER SECURABLES

Which it's quoted in many places as saying...

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the...

Sean Lange (9/3/2014)

---

Gazareth (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to...

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read the reactions...

SQLRNNR (9/3/2014)

---

Nah. Just...

Presumably, although there are...

I've just been told: "We don't recommend running SQL commands against the database"

Right. May as well go home then!

Nice Q, thanks.

Wish I could get more devs to use this type of parameter!