Jeff Moden (5/27/2014)

---

Ryan Keast (5/27/2014)

---

Hi there,

I had the following script that used to work in SQL2000 but now that I have migrated it, it no longer does.

,TEN.[tncy-sys-ref]

+...

Jeff, I wanted to get your take on something Gail posted once :

http://www.sqlservercentral.com/Forums/FindPost485499.aspx

The way I read it, a clustered index (pk or not) won't necessarily cause a huge slowdown to...

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 ...