Or even:

DELETE dbo.Table1 WHERE id = ANY (SELECT D.id FROM dbo.Table2 D);

I would just add that if you are doing a lot of work with this type of thing, you might want to take a look at the geometry data type...

No, not as far as I know. Seems an odd requirement though.

Take a look at the data available from the sys.dm_exec_sessions and sys.dm_exec_connections DMVs.

You can get packet counts, reads,...

If you are looking to simulate a computed column across three tables (and it sounds as if you are), consider a view:

USE tempdb;

GO

-- Three related tables

CREATE TABLE dbo.T1 (PK INT...

That looks like an ugly workaround for something the previous guy didn't know how to do properly.

Check for...

In case the syntax is new to you, Flo is referring to INSERT...EXEC:

INSERT {table-name}

EXECUTE {stored-procedure-name}

You must create the table (normal, temporary, or variable) beforehand, and it must have a structure...

F. van Ruyven (1/29/2010)

---

...again it gave the expected result set, but now with a different execution plan and (even more disturbing) a better performance! Is this a bug? Our...

In case anyone's interested, we might have a new option for this sort of thing in 2008 R2 - the stupidly-named but nonetheless intriguing 'DAC packs'. See http://www.brentozar.com/archive/2009/08/sql-server-2008-r2-the-dac-pack/

Avoid string manipulation of dates and times if at all possible.

An alternative approach might be:

DECLARE @DateOnly DATE = GETDATE(),

...

While you're reading up on it, pay close attention to the importance of trying to back up the 'tail of log' before commencing recovery operations.

The start of a very useful...

rambilla4 (1/27/2010)

---

We are planning to install SQL Server 2008 EE on Windows 2003, which is a production box. In production box, do we need to install the .NET Framework 3.5...

Ritesh Medhe (1/29/2010)

---

is there any sepcial kind of optimisation setting that needs to be done if SS2008 is running on AMD? I ran same SQL query on Intel and AMD...

Matt,

I wouldn't take it too much to heart. There is always a risk of misunderstanding arising when communication occurs in this medium. Personally, I didn't find too much...

Thanks

Jason,

What the heck is that new avatar? I miss the old one 🙂