As Grant has mentioned about whether or not NOSQL databases will stay is an unknown. Personally the organisation I work for had implemented a new website using Mongo which...

Remeber that looking up dependancies is only going to give you the results you want as long as relationships have been defined with primary \ foreign key relationships. I...

Dont have one to hand but this might help:

http://www.youdidwhatwithtsql.com/monitoring-starting-services-with-powershell/113

Have you tried

select * from sys.dm_os_performance_counters

where counter_name = 'Buffer cache hit ratio'

This might help:

http://gallery.technet.microsoft.com/scriptcenter/ed188912-1a20-4be9-ae4f-8ac46cf2aae4

As long as you have not restared the SQL Server since the deadlock you can get it retrospectivly using this query:

IF OBJECT_ID('tempdb..#ring_buffer_data') IS NOT NULL

...

Developing your own is always an option. I have worked on projects doing just that with my current and previous employer. Its a big challenge though, hundreds of hours...

Redgate SQL Abckup and Quest Litespeed dont have this issue so may be worth investing in the software if space is an issue. Both products can compress upto 90%.

Looking at the two execution plans there are two key lookups on each plan that take approx 36% each.

In the prod one the number of executions is 1677 and in...

As everyone else has said the topics are huge.

However in my past experience when companies have asked for knowledge of these areas it is generally been in the context of...

I'm pretty sure you need to capture it as part of the trace as the 42 is just an internal number used as a pointer to the SQL.

Sorry...

Saw this a few years ago, do you have an app coded in delphi connecting to the server? If so It does a prepare statement then runs the code....

Have you tried running each of the three select statements outside of the UNION? It will help identify which if any of them is the cause to start from.

Thanks Gail, online rebuild isnt possible as that table has BLOB data. Log is another issue too.

What we are looking at developing a SSIS package that starts the reorganize....

From memory all you need to do is drop the clustered index on the table (most likely the primary key) and recreate it specifying the partition scheme in the on...