PREEMPTIVE_SP_SERVER_DIAGNOSTICS just reflects the cumulative wait time of stored procedure sp_server_diagnistics. This proc was introduced in SQL Server 2012 (https://msdn.microsoft.com/en-us/library/ff878233%28v=sql.110%29.aspx) and takes a @repeat_interval parameter that specifies...

Completely agree with it, as my asnwer was the same as you've mentioned.

Because even I did not notice topic name where the question related to. We all focus on question 😉

or

Drop table BBB

Presume question author made a mistake in sintax, main reason why majority did not accept the answer 'D' as correct solution.

Hi,

To register provider you need one more oracle product instantclient-sqlplus-win-x86-64-11.2.0.1.0.zip and make some changes in register. All details are described in this article. http://nampark.wordpress.com/2011/01/20/installing-64-bit-odac-11-2-to-microsoft-sql-server-2008-r2-x64-for-replication/

Hope it helps. (I used...

Personally we tried to perform SQL and windows upgrade for cluster, as client requested (2005 to 2008R2 SQL, 2003 to 2008R2 Windows server). Unfortunately we ended with up with building...

Might be helpful

http://blogs.technet.com/b/hugofe/archive/2012/12/06/best-practices-for-migration-of-cluster-windows-2008-r2-2012-as-melhores-praticas-para-migrar-um-cluster-de-windows-2008-para-windows-2012.aspx

Go for 2 solution. Just don't forget to take backups before performing upgrade.. I would advise not to detach, but restore databases on SQL2012SP2. Restore would assist system tables upgrade...

We are talking about initial instance configuration. It might expand latter up to 10 GB depending on database size. You misunderstood me, to be frankly. And another thing is.. might...

You do not need tempdb ndf file as large as you can make them. It is more than enough to put as 50 mb each. They will expand as much...

Corrected. Thank you.

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/

Based on this article we are configuring out tempDB. But if it is expanding too much, you definitely have to have a look into code.

Here are some...

Don't get me wrong, backup is against general databases. I had problem with tempDb trying to DBCC one of the biztalk with transactions logs databases.

And again, based on hardware,...

This is something what is being configured by Microsoft script best practice configuration. Depending on environment (hardware) we do create n number of temp databases. Also, we do 15...

Microsoft recommend unlimited growth for temp databases.

Initial size should be 50 MB for all temp dbs with 500MB file growth with unlimited Max Growth. hope it helps