GSquared (8/24/2009)

---

I don't think anyone yet has accused...

Welcome to my list, Skipdick.

Good on you Arup. 😎

Paul

Gail,

I think you have mis-read one or more posts at some stage.

My points about ANSI_NULL and the Constant Scan iterator quoted this code:

select * from sys.databases where name not in...

Jeff Moden (8/17/2009)

---

Grant Fritchey (8/17/2009)

---

I don't know about integrity, but if I got it wrong, I got it wrong and it needs to be clarified. However, with a bit of...

playm77 (8/17/2009)

---

Depends what you mean by "default port".

If you mean port 1433 as used by a default instance of SQL Server, then no.

If you mean that each named instance should...

GilaMonster (8/17/2009)

---

Considering I never switch it off, anything I post about nulls can be assumed...

rja.carnegie (8/17/2009)

---

IN(...) doesn't seem to mind if a NULL is in there. But NOT (name IN (...) ) apparently also does the same as (name NOT IN (...) )....

I think I posted something about the query missing table aliases so it wasn't clear which column...

Elliott W (8/14/2009)

---

Paul:

I think that the definition of default port precludes much of your post, SQL's default port is 1433, if you are using dynamic port allocation there really isn't...

Depends what you mean by "default port".

If you mean port 1433 as used by a default instance of SQL Server, then no.

If you mean that each named instance should listen...

Jeff Moden (8/13/2009)

---

For me, that would really be a bad thing. Do you happen to...

Here's a script you can use to experiment:

USE tempdb;

GO

SET NOCOUNT ON;

GO

-- Add one row (will fit on one page)

CREATE TABLE dbo.AllocationTest (row_id INTEGER IDENTITY, col1 CHAR(8000) NOT NULL);

DBCC TRACEON (1118,...

rja.carnegie (8/13/2009)

---

I don't get why the traceflag creates a problem in user databases that needs a hotfix in 7.0 but apparently doesn't demand a hotfix in 2000 and later. ...

GilaMonster (8/13/2009)

---

Reading carefully, she hasn't made an error, but it's easy to draw an...