On our clustered instances, every once in a while the linked servers just give up

In our case that is not deadly because the...

could be something like this :

CREATE TRIGGER TrIU_T_Mytable ON dbo.Mytable

FOR INSERT, UPDATE

AS

   IF MyEmailColumn is NOT null

      begin

-- must be unique where not null

  If exists (select * from dbo.Mytable...

maybe for performance reasons it is better to split up your queries !

This effort must only be done once (and at maintenance time...

What 's happening if he copies the 65/76Mb files again from his backuplocation to another location (or renames them) at the db-server and then sp_attachdb them to a new db...

I just checked a couple of servers and we also run extra sp_updatestats every 4 months as well as dbcc updateusage because auto-stats get inaccurate after a while.

check out : The Curse and Blessings of Dynamic SQL

http://www.sommarskog.se/dynamic_sql.html

Thanks Razvan Socol  ! That's what I was looking for

I'll take a look at the...

autoextend is indeed a slow process, but 1 - 2 hours

If you create a new db with a datafile of 700mb at...

Thanks for the feedback.

FYI :  we have auto-update-statistics on all our sql7- and sql2k-db.

I know it's a basic rule, but I wanted to work out a litle case so I can show developers the effect. Not only within QA, but also within their...

".. but the second one will return all rows in the table .."

No. Test it.

Left part contains only those with Associated?="No"

Right part contains only those with Associated?="yes"

joined by

July 28, 2004 at 3:46 am