SET PARSEONLY (Transact-SQL)

Well!! get a gun or hire a shooter.

What is...

It needs a covering index.

See here[/url] and BOL

This could help as reference for execution plans.

free_mascot (3/18/2014)

---

If I understand correctly; second answer can be consider correct too.

How second answer is applicable: in this scenario distributor needs to be on highest version of SQL Server that...

This may help

http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx

jeandlauro (3/14/2014)

---

I am running SQL Server 2012 on a VM and am trying to pull data from a network drive (S: or \\misvnascfs0003\)

I can import data using the Import...

This may help

http://www.sqlnotes.info/2012/10/10/update-with-updlock/

BOL confirms deprecation, Here is citation from

http://msdn.microsoft.com/en-us/library/ms151149(v=sql.110).aspx

Heterogeneous replication to non-SQL Server subscribers is deprecated. Oracle Publishing is deprecated. To move data, create solutions using change data...

Basically you would like to see who is using all the memory from SQL end.

What are the max and min values for counters Page Life Expectancy and buffer cache hit...

Possibly blocking may be the primary issue that makes you feel huge traffic in-spite of NOT HUGE data in the database.

Do you use CAML query designer for sharepoint to...

MAXDOP

http://support.microsoft.com/kb/2806535

You could query SSISDB to get metadata/configuration details in 2012.

This query would help

select ie.environment_id, ie.environment_name,

iev.name, iev.value

from internal.environments ie

JOIN internal.environment_variables iev ON ie.environment_id = iev.environment_id

UPDATE x SET x.b = y.d

FROM TABLE1 x

JOIN table2 y ON x.a = y.c

Did you try rebuilding table including all the indexes? That would release space to database, then shinking file would relase space at OS.

Did you check the status of database MSDB and are the queries executed successfully in MSDB?

Any clue with errors in SQL Error log?

Check out this, may help.

http://support.microsoft.com/kb/2519834