What do you mean by that?

What's exactly happening when update is running?

does not log updates where the value has not changed and does...

Yes, of course.

Just use SET ANSI_WARNINGS OFF in procedures which select from the view.

If you have a single script ready you may just run it from Command Shell using sqlcmd tool (2008 replacement for osql)

If you actually have a bunch of scripts you...

GilaMonster (8/15/2012)

---

The question was not, does the update cause any log records to be written to the log. The question was, does the update dirty the page if the update...

patrickmcginnis59 (8/14/2012)

---

The routines are simple enought that I also tried perl and vba but couldn't find anything slower than T-SQL. Obviously testing a c version would be sort of silly....

CHECKPOINT -- just to be sure and to allow for multiple tests

DECLARE @I int

SET @I = 10

WHILE @I > 0

BEGIN

BEGIN TRANSACTION

UPDATE test SET name = name

SELECT ...

Dropping an index by name might not work when there is an index on the same column(s) under a slightly different name.

Proper solution should include comparing entries in sysindexkeys to...

GilaMonster (8/13/2012)

---

As far as I can tell, updating a row and not actually changing the values does not mark the page as dirty, meaning it won't be written back to...

That's probably the worst possible one.

It delivers pretty much the same result as mine...

Turns out New Zealand is way more sophisticated than Australia.

About by 1/3 more...

UPDATE sf

set JUL_SAL = isnull(sf.JUL_SAL,0) + isnull(ss.SLS_DOL,0)

FROM

DIAPLUSDB.dbo.SalesForecast sf

left join (

SELECT CSCODE, PLT_NO, SUM(SLS_DOL) AS Total_SLS_DOL

FROM ...

Triggers, for example. transaction logs. Users sitting...

CELKO (8/10/2012)

---

like the idea of having a sid (a surrogate id) on my tables, even if I do have a natural key that can serve as a primary key.the...

You may choose "Unique Key" instead of "Index".

That...

kenneth.mofokeng (7/5/2012)

---

I need help with SQL 2000 Query to get time difference between 1st row and 2nd, 2nd and 3rd, 3rd and 4th and so forth on Column Datatime..

I used...