Just keep in mind you have all doc in you hands - well pc/server actually - if you have installed Books online.

Congratulations Gail.

It may take me another couple of years - say 10 😉 - to get near to that number.

as you can see, inner join has nothing to do with primary key or foreign keys.

It is just a comparison of one or more columns of a data collection with...

it went into suspect mode, because sqlserver keeps synchronisation indicators internally. Because you copied the mdf and then brought the db online, the log file got another sync number than...

Just a little warning if you want to do this using a trigger :sick::crazy:

- a trigger is always executed "in transaction". If the trigger fails, your whole original transaction fails!!...

Tom.Thomson (10/28/2010)

---

Jeff Moden (10/27/2010)

---

You shouldn't mention that in an SQL forum: "Row" is unspeakable,...

GilaMonster (10/28/2010)

---

Craig Farrell (10/27/2010)

---

Although, I'm with Wayne. Where do you find the 'last time index changed' date? 🙂 I'm relatively sure you can't do it in 2k, but...

how about :

- Anger management 101

- HowTo handle people "who don't know what, but want it now"

- Comforting for beginners

- HowTo tell you boss (s)he's a dumb a$$...

I see no tuples in your table list, does that mean you only need to know the last time a table has changed ?

Do you have to datetime_updated column in...

do you also need to "decrypt" these columns ?

If you answer is "No" or "I don't care rubbish is published", just put blancs or NULL in your columns, or "censored"...

checkout the left function, combined with charindex.

books online has nice info.

Off course your update statement should contain a where clause :

where servername like '%\%'

GSquared (10/27/2010)

---

...

Read what he writes, but filter for opinion vs fact, and decide for yourself what's useful to you and what isn't. He's worth reading, you just have to...

Disappointing, indeed.

Another reason to actually put your lobs in a separate filegroup.

Keep in mind I can only carry up to 25kg of goods in my filght case 😀

(I should double check that weight limit)

Indeed, the cleantable isn't common with your request.

I was especially aiming for:

There is a known issue where on a database having a LOB data in it, the SHRINK operation will...