Big is all relative. The title here is about "big data", which is an overloaded, hyped term meaning multiple things from JSON structured data to lots of text files.

There's a DMV as well: https://msdn.microsoft.com/en-us/library/ms190484.aspx

We have an article as well: http://www.sqlservercentral.com/articles/T-SQL/77057/

SP1 had a SSDB Catalog issue. It was corrected and re-released.

However, there is a CU1, but it has lots (100+) fixes. I'd go with SP1 for now. Seems stable.

YMMV

chrisn-585491 (6/23/2015)

---

Why should I use RavenDB when I have SQL Server, Postgres and other databases, SQL and NoSQL that have more developers, users and admins with more experience? Isn't this...

TomThomson (6/23/2015)

---

And maybe the decision by companies that they can't pay people to learn new skills (your last paragraph, Steve) is the cause of so many people being imported from...

emmchild (6/23/2015)

---

Steve it would be awesome to have RedGate tools for Postgresql. It would be awesome to have a Postgresql Server Central site. I would be willing to...

This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.

Disclosure: I work for Redgate.

If Windows sends a shutdown, SQL will usually perform a clean one. I haven't seen issues with Windows patches causing issues, but if you're worried, check the error logs and...

jasona.work (6/18/2015)

---

Steve Jones - SSC Editor (6/18/2015)

---

Those are good memories, but I'm glad we're past that.

Left the kids on their own as my wife and I are in the UK....

You can't do

select sum( select myfield from mytable)

from mytable

If you want to work with two sets of data from the table and calculate different aggregates, then you need...

That's interesting. Didn't know that.

You can't easily do this from T-SQL. T-SQL/SSMS executes inside of the server, not in the file system. There is no BULK EXPORT, mostly because the commands you run are...

Teach him to just drag the columns from Object Explorer (or get SQL Prompt). Easy fixes for the dev that aren't a big deal.

Those are good memories, but I'm glad we're past that.

Left the kids on their own as my wife and I are in the UK. At 14, 16, 23, they're managing...

Do you mean backups? These are noted in the log, there are trace/events...