On the point of halving the row versions:

Let's say you have a table with people's names in it, and LastUpdate (datetime) and LastUpdateBy (varchar) columns.

So, you issue a command to...

If you're going to add an...

What you did is just fine. Saying "thanks, that helps" pretty much closes the thread. (Then, of course, some overly helpful person like me will come along and...

It's important to know about cursors. Mainly so you can fix them when other people have mistakenly used them for ... well ... almost anything.

I would think, if the database were in 80, that "CROSS APPLY" would get an error message instead of the thing about table hints. I don't have access to...

You can use SSIS to automate output for files, including automatically naming the files. That's probably the best way to do what you want.

SSIS can run each script and...

foxjazz (1/6/2009)

---

it's probably easier to use a cursor to iterate through your first table.

declare @c1 varchar(50), @c2 int

declare @rowcount

declare @sel cursor

set @sel = cursor for

select c1,c2 from t1

open @sel

fetch...

You could also set up a hierarchy table that would include all codes that fall under any other code. That would give you a way to quickly determine which...

I'd use Gail's second script to find all the tables that don't have PKs, then review them and figure out what PK each one needs.

Some might have an ID column...

When you say you want differences, what exactly do you mean?

Do you just mean rows that exist in one that don't exist in the other? Do you mean rows...

The only things I can think of that power failure would do that would improve performance like that would be to flush the execution cache, which might get rid of...

You say you need to create some indexes very urgently, but how can you be sure indexes are what you need if you don't know how to create them?

What problem...

If the UDFs are the ones that you define a table variable for the output (called "multi-value UDFs"), then that's probably the biggest source of the performance problem. Those...

If you can guarantee that the only way for this data to be updated is by procs, then including the update date and user in the procswould be better, since...

Knowing the differences on these can make a big difference in your ability to read execution plans, so I suggest looking all of them up in Books Online, which has...