Does this answer your question?

Those are two instances on the same server, one 2012 and one 2014 and I opened both from the same SSMS 2014

Brandie Tarvin (4/8/2015)

---

And on another note, back to SQL 2012 SSMS, does anyone know if that annoying bug with Job Activity Monitor was fixed? The one that puts the big...

On the subject of reading...

https://www.thedodo.com/pets-interrupting-reading-968102862.html

And can we please leave the politics somewhere else?

Specify the correct format code for the CONVERT, the one that corresponds to the format of datetime you're passing.

Grant Fritchey (4/8/2015)

---

Koen Verbeeck (4/8/2015)

---

Grant Fritchey (4/8/2015)

---

Probably get in a little trouble for this, but since I know that many of you are both SF fans and, let's just say,...

I use SSMS 2014 exclusively now, because I'm working on SQL Server 2014 and previous versions of SSMS don't work well up-version. The biggest annoyance is the help file. The...

dwain.c (4/7/2015)

---

I just posted this to "The Worst Comments" discussion thread:

dwain.c (4/7/2015)

---

-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar

-- gave me this...

Index2 is near-useless. It's redundant with the primary key and is extremely unlikely to be used much.

The index that the missing index suggestions are suggesting...

Hugo Kornelis (4/8/2015)

---

Eirikur Eiriksson (4/5/2015)

---

Try out this keyboard sequence:

😎

1. CTRL + H

2. [

3. TAB

4. ALT + A

5. ENTER

6. ...

Yes, those are ALTER VIEW statements running. Whoever told you the views don't get altered is mistaken. The locks involved are Schema Modification locks, those are taken when an object...

On the indexing side: http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/

No, because it's not a comment.

I had to double-check to be sure.

The key is that when a VLF is reused, it's sequence number increases so it never has the same sequence number as a previous...

Also look at Microsoft's Azure offering.

Seconding the recommendation to use Ola's script. He's done all the hard work, his stuff works, it works well, it's easy to use.

Couple things about your code:

TABLOCK WILL CAUSE DBCC...