I'm guessing the recovery model of the database is set to FULL but no log backups are taken so the TLog grows and grows, gets shrinked every day only to...

I bet it's the table variables. They can't have indexes on them nor stats maintained for the data.

Gila, you're such a pedant!

OP, in terms of SQL it can be as simple as (but this is jus an example) When you select from the first drop down you...

Was waiting for your solution 😀 Nice!

What about this?

select a.*, ISNULL(b.result, 0)

from [Table_A] as a

OUTER APPLY ( SELECT *

FROM (SELECT DeliveryDate, MIN(ID) as ID, SUM(Pass) as Pass, SUM(VM_Id) as VM_ID,

CASE WHEN SUM(VM_ID) > 0 THEN...

Quick attempt, any good?

select a.*, ISNULL(b.result, 0)

from [Table_A] as a

OUTER APPLY ( SELECT DeliveryDate, MIN(ID) as ID, SUM(Pass) as Pass, SUM(VM_Id) as VM_ID,

CASE WHEN SUM(VM_ID) > 0 THEN (SUM(Pass)...

;with SCC_cTE(ID ,Name)

AS (SELECT 1, 'srinivas' union all

select 2, 'ravikumar' union all

select 3, 'jaipal' union all

select 4, 'ravisekhar' union all

select 5, 'ramugopal' union all

select 6, 'harikuma')

select id, name, SUBSTRING(REVERSE(name),...

Have a read of this: http://msdn.microsoft.com/en-us/library/ms189121.aspx

So you can either go with the predefined database roles and choose the appropriate roles (db_datareader, db_datawriter, db_ddladmin) to the mapped users.

Or

Create a database role,...

You can use the Export wizard?

sp_whoisactive is just a TSQL sproc but as Grant has already mentioned, there are DMVs that will give you information on possible locking/blocking.

Can i suggest you install Adam Machanic's sp_whoisactive:

http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx

and when you run your select, run sp_whoisactive to see what's going on?

pradeep.mohan (4/24/2013)

Log shipping (backup job) failed after we change SQL service account in our production database and DR database server.

Earlier its was working fine with existing account name (Account...

Read this: http://msdn.microsoft.com/en-gb/library/ms187004(v=sql.105).aspx

Fair points Kevin. I'm not a C# coder really so I know it's not the best written code in the world.

I will speak to one of our developers to...

Thanks Kevin. I wil try the join hints and report back

Here is one of the CLR TVFs I use to score Email addresses:

using System;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

using System.Net;

using System.Data.SqlClient;

using System.Collections;

using System.Collections.Generic;

using...