DBCC CHECKDB uses internal database snapshots which are created at the same location of the corresponding database data file and grow as data is changed in the original data file....

Sharing some windows updates which are applicable on Win 2012 R2 & worthy instead of /L.

There ‘ve been some changes in the NTFS on Win 2012 R2 once these HF...

•Avoid running DBCC CHECKDB at a time when other / major data modifications are taking place.

•Divide the database into a multiple files. The limitations are per sparse file and each...

This message has to do with all the SQL versions after SQL 8.0 and is caused due to file system (OS) and not SQL. Windows 2k8 & R2 solve it...

When is this occurring?

Are you running a DBCC or BAckup at that time?

Thanks for your contribution RON, I'll update these & a few more in the July release.

Check this.

http://gallery.technet.microsoft.com/scriptcenter/Get-List-of-Linked-Server-d6c95d9c

Good work.

Stay tuned, I'll update it soon.

Check this.

http://technet.microsoft.com/en-us/library/ms178083.aspx

Thanks I'll add it up in the next update.

This may help http://blogs.msdn.com/b/blakhani/archive/2007/12/31/how-to-create-sql-20005-cluster-on-virtual-server.aspx

The browser service wont help detect the listener port. You will have to specify that in the conn string.

Unless that 1433.

Similar message popped up when installing SQL 2012 on a two node multi-subnet cluster. This was not a clustered SQL install, the fix was to get the WFC back up.

Next update coming on 05 Jul 2013.