If there becomes some type of RSA rolling number then how does one used a C Card to pay for something like a cell phone bill where you get your...

Reindexing can help.. but it depends. If you have auto stats on the database that should update your stats on the table(s). However, for heavy delete,insert type tables...

At first glance that looks like some serious issues. As a first try do NOT run repair data loss as you will loose random data within your database and...

I never upgrade in place. If something goes wrong the backout is quite ugly.

How large is the transaction log file? When the backup runs is there some very long running update, delete, insert process running that hasn't committed yet?

Next time you run...

Steve Jones - SSC Editor (12/15/2016)

---

Charles Kincaid (12/11/2016)

---

One possible downside of the fast release pace is the expense of upgrading. Paying new license fee each year or two is...

Thanks everyone. I guess I didn't search enough myself. I guess I am surprised that they still support SQL 2005 into 2016... good for those still on SQL2005.

GeorgeCopeland (12/14/2016)

---

Again, any database that is not being upgraded should be on the list for decommissioning. Make the owner of the data aware that they are on the decommissioning path....

Thank you for your input everyone.

sgmunson (12/14/2016)

---

Markus (12/14/2016)

---

Our vendor has a new version of their application that we will be upgrading to in the coming year. Today the database is in SQL 2008 (NOT...

GeorgeCopeland (12/13/2016)

---

The release cadence may be increasing but the issues remain the same. I recommend upgrading vigorously, say 3-6 months after a release so there is enough time to find...

It is going to be a nightmare for DBAs... just think in 10 years how many different versions of SQL Server we will have to support.. not to mention Microsoft...

Each version of SQL Server had had at least one SP or CU that within a week or so gets pulled or updated for some reason so I am hesitant...

Ray K (12/1/2016)

---

All-Star game will no longer determine who gets home field in World Series.

It's about freaking time. I never liked this idea in the first place. Good...

Accidentally that happened on a couple TEST SQL Servers until I had them exclude that. I DO however, have them apply any security patches for SQL Server that come...