Well now that's just strange. What the heck?

You may have to edit the SSIS package the import/export wizard creates.

Don't migrate the timestamp column. It will generate on it's own.

Then you can probably get what you need by querying the DMV's.

Yep. I just tried the update. It didn't seem to affect things at all. It sure sounds like the PK was not defined as the script you supplied. I can't...

I agree. First option would be to query the DMV's to see what has been run. However, if you wanted to know what was run yesterday or last week, the...

Jeffrey Williams (5/27/2009)

---

Yes, statistics are updated after rebuilding the index - on the statistics that support that index. If the index is reorganized, statistics are not updated. 😀

If...

And evidently a volunteer for the head author position. Well done.

Oh, I thought that was a digit. All this computer-ese is so confusing.

Actually, I haven't for about a year and a half. I miss it, but between writing...

GilaMonster (5/27/2009)

---

I wouldn't mind giving it a shot, however it's ramping up to the busy time of the year, TechEd in Aug and PASS in Nov, and usually work picks...

GilaMonster (5/27/2009)

---

And the problem is I doubt most publishers would want to touch something like that. It's a very specialised topic and not too many people (relatively) would want a...

Gail has a couple of articles on performance tuning[/url] over at Simple Talk. You might want to check them out. I have an introductory article[/url] on execution plans that might...

You could set it this way, not that I'd want to:

DECLARE @myval varchar(max)

SET @myval = '(''5'',''4'',''3'',''2'')'

The two single quotes will turn into one inside the variable.

But, the real question is,...

Something else must be going on in your code. I copied these two lines:

CREATE TABLE OverallStatus (ID BIGINT IDENTITY(1,1) PRIMARY KEY, YP_code VARCHAR(15), datum DATETIME, Description VARCHAR(5000))

INSERT INTO OverallStatus (YP_code,...