Marios Philippopoulos (4/9/2008)

---

Thanks, that's a great way of doing this, but I'm wondering, is it useful to apply this to all tables or just the larger ones? Any hints as...

Then we have...

Someone ran a script with a whole lot of truncate and drop statements in it?

SQL doesn't randomly go and drop tables. Someone would have had to do it.

I've seen...

I'm reading your posts just fine, thank you.

I don't see why I would want to fail the entire load if I know there's dups in the source data that, for...

ronefrati (10/11/2008)

---

In regards to: "I'm not sure that reproducing both the parser and the algebratiser (the component of the SQL engine that converts queries into expression trees) in the .net...

By what definition?

A delete on a staging table is like saying "I don't care about this row coming from...

Jeff Moden (10/11/2008)

---

... and, here's the tests... these work on both 2k and 2k5. According to Gail's fine blog, some of these tests will not work on 2k8 (which...

Well, as the error says, CURRENT OF is only allowed for updates and deletes. You use FETCH to get values into variables. Fetch isn't always next. You can get the...

Or, since you're using 2005 you can simply use

SELECT name from sys.databases where state = 'OFFLINE'

No way to know directly. If you need that info, you'll have to add a piece of code to each proc to log when it last ran. Can't do that...

A trigger always runs within the context of the transaction started by the statement that fired it. If you issue a rollback statement within a trigger you will roll back...

Look in Books Online for the index architecture. You'll notice that the index is in the form of a tree. The 4 rows refer to different levels of the index....

More than slightly better...

http://sqlinthewild.co.za/index.php/2008/09/04/comparing-date-truncations/

Duplicate post.

Please direct replies to:

http://www.sqlservercentral.com/Forums/Topic584339-5-1.aspx

I wish all the source data that I had to work with was as clean as...