Eliza (10/7/2012)

---

This wouldn't work as its a...

Eliza (9/17/2012)

---

Hi all,

Can I ask please if I have a row and one column has a csv list in it. Is there a way please to split the csv...

SELECT R1.Report_ID, R1.[ReportHistoryID], R1.modified_by, R1.last_modified, R2.[ReportHistoryID], R2.modified_by, R2.last_modified

FROM [dbo].[Reporthistory] R1

INNER JOIN (SELECT report_ID, MAX(last_modified) LastModified

From [dbo].[Reporthistory]

WHERE Report_status_id = 2

GROUP BY report_ID

) RLM ON RLM.report_ID = R1.report_ID

INNER JOIN [dbo].[Reporthistory]...

Clustered index on [LogTime] should solve the problem.

I did a little experiment using string values of different length.

Here is the base script:

USE tempdb;

SET NOCOUNT ON;

GO

CREATE TABLE dbo.Test

(

Name char(200)

COLLATE Latin1_General_CI_AI NULL

--COLLATE Latin1_General_BIN NULL

);

GO

INSERT dbo.Test

SELECT...

SQL Kiwi (9/16/2012)

---

Sergiy (9/16/2012)

---

Actually, you did. Trigger is executed after UPDATE. If SQL Server figures out that the values are the same and does not proceed with writing to the...

SQL Kiwi (9/16/2012)

---

Sergiy, I should add that the fun in the example was in working out *why* that particular case gave the performance results it did. With a long...

L' Eomot Inversé (9/16/2012)

---

Do you really imagine that the query processor's interface to the storage engine operates on pages as opposed to on rows or attributes?

How does it matter what...

Can you please provide a reference to a document saying that storage engine operates rows?

So far every...

SQL Kiwi (9/16/2012)

---

No! I have never said anything like this. The inserted and deleted pseudo-tables in a...

No, it's actually quite easy to see.

Some proper experiment.

Not the one-sided script specifically baked to...

Not necessarily.

If you add a computed column at the end of the table it would not break existing inserts,...

Actually hardcoding business rules is an extremely bad practice.

So, none of the options is preferrable.

(do I sound like you know who? 😉 )

If you follow the proper DB modelling rules...

carlosaamaral (9/11/2012)

---

SELECT table1.column1,

'99',

left(table1.column2, 2),

max(table1.column3),

'Yes',

'Test'

FROM table1

WHERE NOT EXISTS ( SELECT 1

FROM...

I changed the execution part of you script a little bit:

EXECUTE dbo.UpdateSame;

SELECT * FROM dbo.Test -- added to check that the value in...