TFS has a schema compare feature, not sure if you use this source control program. I fished this out with a quick Internet search on applying the schema change function....

TomThomson (8/2/2014)

---

MMartin1 (8/1/2014)

---

Its quite clear that a csv column is not only not normalised, but given the leading % in the search condition (doing a LIKE '%someTerm%' search) will create...

+1 for SSIS, and given what you said

SSIS has a Merge...

Alvin Ramard (5/28/2014)

---

ChrisM@Work (5/28/2014)

---

Alvin Ramard (5/28/2014)

---

Luis Cazares (5/27/2014)

---

Alvin,

The code makes clear that there's a concatenation based on multiple values on a single column.

CASE WHEN A.[COL_1] LIKE '%cricket%' THEN 'ck'...

I know this is not a current post but one thing to check is that in your desing environment you are pointing to the same data source as in the...

I am curious if the report accesses the same tables set for all users, if not then look at index maintenance on the tables used by the slow user.

One thing you can do is ...

create procedure myProc

(@status char(1))

AS

BEGIN

set nocount on;

IF (@status ='B')

BEGIN

/* run this code with no filtering by the field 'active'*/

END

ELSE

BEGIN

SELECT /* your...

I guess I need a definition of a 'user' and a definition for a 'customer' for you are asking us to understand the business logic to see if your query...

In the Aggregator transform you select columns to group by and those to aggregate on, so the other 23 would indicate a group by. Note that you can use this...

I am not sure how well I follow as there are details being lost in translation that I am not getting. It seems though you could benefit from a Calendar...

Lookup SQL Server Agent jobs in books online. It is fairly intuitive to do what you are requiring.

For database mail you need to create a profile or use a...

If I run this

declare @salesperson table(pid int,name nvarchar(10),sales int)

insert into @salesperson

values (1,'gary',0),(2,'sam',0)

declare @salesHeader table(id int,pid int, sdate date,amt int)

insert into @salesHeader

values

(2,1,'2014-04-21',130),(1,1,'2014-05-29',100), (4,2,'2014-04-14 ',40), (3,2,'2014-05-29 ',90)

select * from @salesHeader...

It doesn't seem to update the results the right way, at least from my understanding..

I get results as

pidnamesales

1gary 100 ...

Have you had a chance to configure distributed ad hoc queries to see if this helps?

I did find something interesting on Books Online regarding CHECKDB : Just wanted to note here >

"databases that are created on SQL Server 2005 and later should never contain...