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,...

Gail was still right. There is...

This is opinion, but no. I'd say 2008 is more of an upgrade than 7 to 2000 was. Not by a lot, but more. However, knowledge learned of 2005 is...

I worked for a dot com that had almost a tb on SQL 7. I'm working now for an insurance company and we don't have any databases over 100gb (yet,...

Are you sure? 😉

But since you shouldn't automatically rebuild all indexes all the...

If people are posting code on the net, it has to be with the expectation that it will be used by others. I know that's the assumption that I have...

Tell them not to drop tables. In 2000 we couldn't revoke their privileges to create indexes. We had to tell them not to do it. Although, since we built our...

Create a role that you're going to add your developers to. Then add ddl_admin and security_admin roles that role. Then deny CREATE TABLE to the role. That about does it....

Yeah, but I'm a head case on the best days. I'm talking about...