My primary question would be 'why?'

Automatically killing SPIDs is never a good idea. What if these are legitimate queries that simply need to use tempdb? Maybe there's a...

As Grant pointed out, you...

I do the same thing once a quarter for my business. I use the following script in my environments to monitor file size. I took this basic shell...

New features are generally available to any database attached to the instance, regardless of compat mode. Example here, you can create columnstore indexes in a database attached to SQL Server...

Ken Overton (3/30/2015)

---

SQLFRNDZ,

Thanks for the response. You answered the main point of my question about the SA being a yearly renewal. The SQL licensing I already understand pretty...

Availability Group, it's a High Availability solution that allows 2 servers to stay in sync and fail over to each other.

Can't...

Even crazier, check out what version it upgrades to, this is from SQL2005 SP3, being restored to SQL2014 CU6:

Database 'Utilities' running the upgrade step from version 781 to version 782.

So...

SQLRNNR (3/30/2015)

---

The documentation poses an interesting conundrum for which I previously submitted connect items (MS closed saying they won't fix).

If you try to change to compat 90 (sql 2005) you...

You sure can, 2005 SP4 will go to 2014.

We are...

RonKyle (2/2/2015)

---

I'm also interested to hear this, but we have had a lot of success with a multiple file...

Just my .02, but why not open SSMS, navigate to Server Objects - Linked Servers, use View -> Object Explorer Details then highlight them all, Script As -> Create To....

I'm with Grant on this one. Are your DBs in 2014 (120) compatibility mode? If so, you are using the new CE. We are going to 2014...

Awesome question, learn something new every day.

I like to think of anyone with sa as someone who could potentially cost me my job. As a DBA, your #1 priority is to protect the company's data....

I thought I'd interject here and make sure that we understand that CXPACKET waits are not, inherently, a bad thing. It just means that queries are going parallel. ...