this makes no sense without years. Are you saying that you'd need Jul '14 through Dec '14 and then Jan '15 through Jun '15?

Or are you saying a rolling year...

What you could do is set up a baseline of how things perform now. Then implement a small replication system, maybe a single table/article that has enough activity to show...

Is this a default instance?

Are the agent jobs running?

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.