Another option if you wanted to have the collation changes apply to existing objects, you could migrate the data to a new database with the desired collation.

Depending...

Thanks Jeff for sharing your knowledge here.

Kevin, I'll have to read up on Latching. Thanks guys.

Please try a quick Internet search:

I quickly found this here

http://social.msdn.microsoft.com/forums/sqlserver/en-US/6680aada-dabf-447d-be77-a2088018594a/info-about-latin1generalbin-collation-s2008r2

The one on your test server was case insensitive (hence the CI portion in the name). That is no...

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