Everything you upload is an attachment, and you can see them here: http://www.sqlservercentral.com/Forums/EditAttachments1.aspx

I think the service packs will shut down SQL Server as the binaries are replaced.

We've started putting lists together of SQL 2016 related content, so feel free to try things out and write about it: http://www.sqlservercentral.com/articles/SQL+Server+2016/127518/

That would be fantastic. Getting a...

I'm torn here. Windows people need to ensure things are protected, and I'd appreciate them letting me know if things get booted, but if it doesn't affect me or the...

Thanks

Jeff Moden (6/24/2015)

---

With the interviews...

What patches? Some patches will be putting the server in single user mode when they run.

clean dbcc checkdb?

My short list, which is probably incomplete as I've never done this. I've gone the other way.

Look in these areas, for dependencies. You should be able to query DMVs for...

Are these databases that were backed up from this instance? If so, then the msdb database has the names.

If not, this is better done from PoSh, though there are scripts...

Quick drive by, but what about using a CASE with the letter to check if there is something returned form the second query, return the letter. Otherwise, return a space?

K, just checking

sqlinterset (6/23/2015)

---

Actually ordering in ssms is being done through this way. But when i am pasting same query in excel pivot tables then this is giving data in normal order...

It did. Kevin Boyles and I broke it, but someone else broke one as well.

I'm...